LinkBack URL
About LinkBacks
Hello,
Worksheet attached.
I do not understand why this is happening as it appears as though all the formulas are the same as in cell 6.
I would appreciate any solutions to this issue that you have.
Thank you,
Richard
Hello,
Worksheet attached.
I do not understand why this is happening as it appears as though all the formulas are the same as in cell 6.
I would appreciate any solutions to this issue that you have.
Thank you,
Richard
You're on Row 7 so you are trying to return the 7th largest number. But you have a blank row so there are only 6 numbers to choose from. Hence, the seventh largest number out of six numbers is a problem ... a #NUM! error, in fact.
Either get rid of the blank row or use IFERROR to handle the error.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello TMShucks,
Thank you for your solution.
Total newB here so ...
The blank row is a necessity due to last minute eliminations that occur. So in this
case I should use IFERROR ... Please help me out with where to pu that in a formula.
Thank you,
Richard
Hello RVT,
A typical example would be something like: =IF(Q1="","",IFERROR(MATCH(LARGE(Q:Q,ROW()),Q:Q,FALSE),""))
Copy this formula into R1 and Copy it down. Then go and change the formula in Cell V1, and also Copy it down.
Regards
Last edited by Winon; 11-09-2013 at 02:04 AM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello Winon,
That got rid of the error message but now have a blank in the cell.
Is there away to stay away from the error message yet still have a ranking of the value in the associated cell post in the R and V column?
Thank you,
Richard
As I said, you are using the ROW() function as an index for the LARGE(...) function. This is generating values from 1 to 7 depending on the current row. You only have six values to choose from, hence the error on row 7. Winon has explained how you can hide that. The more blank lines you have, the more errors that would be generated.
I think you'd need to add a helper column to generate an index, ignoring blanks. Most columns have formulae in them so I think you'd need to use column N to determine whether or not to increment the index.
Regards, TMS
See the attached example.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks