Afternoon,
I have a list of 2400 items which I need to extract unique values from. I have this formula:
=IFERROR(INDEX($B$3:$B$2402, ISTEXT(MATCH(0,COUNTIF($D$2:D2, $B$3:$B$2402), 0))),"")
which works, but pulls all unique values when I need only those unique values that contain text (at the beginning) and not a whole number. For example, MF0105, DS5680, CFT253
Can I add an function to this to ignore purely numerical results?
Much appreciated.
Last edited by welshraz; 02-02-2022 at 12:39 PM.
Possibly ...
Is your forum profile up-to-date? Still using Excel 2010?
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
you could try
the pre-emptive just limits how many times you calc unnecessarily (to one)Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks