Hi guys,
Really need your input on how to generate a list of unique values based on the following conditions:
- Ignore blank cells
- Ignore cells starting with a "dash"
- Take into account only the first 5 letters of every entry
So far, I've only managed to come up with a formula to ignore the blanks:
Could you please help me out with the rest of it. I can't seem to figure out where the LEFT(kor!C$2:C$999,1)="–" bit goes to make the formula ignore "dash"-initial cells as well, and also how to make it match only the first 5 characters of every entry...Please Login or Register to view this content.
Thanks in advance. Every bit of advice will be deeply appreciated.
Bookmarks