If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
counting unique text values in an array of data
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/comm...et.f unctions |
#2
|
|||
|
|||
counting unique text values in an array of data
Hi,
Could you provide a sample of your data and of the expected results? "selltrue" wrote in message ... 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/comm...et.f unctions |
Thread Tools | |
Display Modes | |
|
|