Excel Formula: return a range of cells that match

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Formula: return a range of cells that match

08-26-2014, 11:31 PM

tinfanide

Windows 7 64bit Excel Formula: return a range of cells that match

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Excel Formula - Conditional replacement of cells	mag	Excel	0	10-27-2012 08:30 PM
Sum Formula in the range with Numeric and NonNumeric data cells	Spanec	Excel	2	01-12-2012 09:15 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:43 AM.