Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Formula Help (Excel XP)

    In column |i| of a very large table, I have the following formula:
    =IF(AND(C5="CC",G5>0,L5>0),G5/L5," - ").

    Specifically, this formula was taken from cell [i5]. the result is either numerical or a simple hyphen "-". Where there's a numerical result is where I need something different...

    I could end up with as many as 25 different numerical results scattered about the |i| column. In the end, I need those results to be the numbers 1 through 25. A ranking of the results I'm getting now. Low to High.

    Thoroughly confused? Please see the attached sheet.

    I really need to accomplish this by just correcting the formulas in column |i|. I can already do it by using additional columns but that creates problems while sorting the table by the various headings.

    I'm almost certain that this calls for the use of an array formula but I can't seem to get it done...

    <img src=/S/please.gif border=0 alt=please width=31 height=23> <img src=/S/help.gif border=0 alt=help width=23 height=15>
    - Ricky

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (Excel XP)

    I do not think that it is possible to do this in the same column. The attached file puts the ranks in column J and I did not have any problems sorting.
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Help (Excel XP)

    Hmmmmm. Will sorting still work if I were to HIDE the |i| column? I'm going to give that a try...if it works, I'm going to use your solution and move on. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (Excel XP)

    It should work fine.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •