Filtering by text

S

saltarazan

Hi,
Take a look please at the attached file (filter.doc).
I want to get the rows that have the world "three" in column D to sho
up, AND if there are rows that are related to column A and B, to fix th
number (column A) and the date (column B) that include them.
I hope the explanation is clear

+-------------------------------------------------------------------
|Filename: filter.doc
|Download: http://www.excelbanter.com/attachment.php?attachmentid=733
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index function 1
need help with function 4
Search a range for instances of a text string, return neighboring cell values each ti 2
Get sum of values in a cell based on unique values in another cell 3
Lookup value across multiple columns and rows 0
frustraded with conditional values return in a range of dates 1
Custom Autonumber with Prefix and Category Grouping 3
Complex Lookups 6

Top