counting unique text values in an array of data

S

selltrue

I have filtered data which contain key text with 3 possible options within
each cell, how can I count the text and lookup an additional text in a column
next to the cell?
ex. f1, f1.5, f2 is the criteria which could be "within" the string of text,
there is also a 6 digit number within the same text which can be looked up in
a column to the left. If this 6 digit number is the same, the criteria
should not count.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 

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

Top