Thread: return multiple cells meeting a condition
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
QC-Dude QC-Dude is offline
external usenet poster
  
Posts: 3
Default return multiple cells meeting a condition
How do I construct a formula to return multiple entries meeting a criteria?
I want the formula to return a vertical list of names where grade=2 or higher.

Example:
NAME GRADE
Mike 3
Scott 2
Mary 1
Larry 2

--
Warm Regards, MikCra
Reply With QuoteReply With Quote