Hi,
I am trying to extract the 5 smallest numbers from a range, in this case AD490:AH499. There are empty cells in this range. This is because i am adding victories for a fantasy football league, and there may be times where a person may not have any wins for their points to be entered into a cell.
I have been trying to use small formulas such as
=SMALL(AD490:AH499,1>0)
....but that doesn't work.
Anyone have any suggestions?
Thank you,
Damian
Small Function won't consider Blank cells and I presume that the empty cells will have a 0 value in it. In that case try the below method
Formula:
Please Login or Register to view this content.
Drag it down for next four cells.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks