xcellnoob
Board Regular
- Joined
- Apr 6, 2005
- Messages
- 188
Just curious as to how to perform a count operation to determine how many cells to rank. What I have is this:
{=SMALL(G18:G23,ROW(INDIRECT("1:"&ROWS(I18:I23))))}
on the range I18:I23
If there are only values in G18 and G19, the whole "I" range displays #N/A
What I want is for it to only do the operation on the cells that have values. Help? Thanks in advance. Let me know if there is any more clarification necessary.
{=SMALL(G18:G23,ROW(INDIRECT("1:"&ROWS(I18:I23))))}
on the range I18:I23
If there are only values in G18 and G19, the whole "I" range displays #N/A
What I want is for it to only do the operation on the cells that have values. Help? Thanks in advance. Let me know if there is any more clarification necessary.