Thread: [Solved] Excel Formula: return a range of cells that match
View Single Post
 
Old 08-26-2014, 11:31 PM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Excel Formula: return a range of cells that match
A B
cat 10
cat 20
dog 30
cat 40
dog 50
cat 60

How can I return the range of cells that match "cat"?
The assumed answer: A1:A2, A4, A6

Thank you!
Reply With Quote