I'm building a list from a set of data. I am trying to find the 3 smallest numbers in - let's call it Column R - and there are some empty cells there. The list is populating with data I'm actually trying to ignore.
Is there a simple fix?
=IFERROR(SMALL(IF(($C$4:$C$26="GENERIC SEARCH TERM"),$R$4:$R$26),ROWS($1:1)),"") [Entered as an array with CTRL+SHIFT+ENTER]
small addition...
=IFERROR(SMALL(IF(($C$4:$C$26="GENERIC SEARCH TERM")*($C$4:$C$26<>""),$R$4:$R$26),ROWS($1:1)),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
with CSEFormula:
Please Login or Register to view this content.
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
If there's a formula in that cell - in Column R - though, will it still return a zero?
Welp, tried it and it seems to work fine. Thanks folks.
Perhaps you should provide some sample data and then we can all stop guessing. And expected results would be helpful. Have you tried the formulae provided? What result does it give?
Seems you got what you needed
That's good, seeing as the two formulae do different things
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks