Search:

Type: Posts; User: el0rg; Keyword(s):

Search: Search took 0.00 seconds.

  1. Excel considers all text to be "higher" than all...

    Excel considers all text to be "higher" than all numbers, so if you sort descending, the text will come first.
    A solution is to add another column with formulas like

    =ISERROR(AVERAGEA(A3:D3))
    ...
  2. Have you tried using the Worksheet_Activate event...

    Have you tried using the Worksheet_Activate event instead?

    You know what, that's a way better idea.. I have it working the way I want! Thanks!

    The only issue now, is this..

    Not all of the...
  3. I guess that's why this isn't working: Sub...

    I guess that's why this isn't working:


    Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("A5:A319")) Is Nothing Then

    Run "Top10Update"

    End If
  4. Which version of Excel do you use? 2003

    Which version of Excel do you use?

    2003
  5. Welcome to the Lounge! Filtering and sorting...

    Welcome to the Lounge!

    Filtering and sorting are different operations, so i don't understand what you mean by "I'm using autofilter to sort column B descending". Could you explain?

    Well, column...
  6. Hello, I've got a list like this: ...

    Hello,

    I've got a list like this:

    _____A______B____
    1 | name1 | number
    2 | name2 | number
    3 | name3 | number
    ...
Results 1 to 6 of 6