Hello -
I attached a simple spreadsheet with sample data to highlight my struggle.
I have many records for each customer, each record having a string of text (folder/file name) to identify documents related to that customer. I'm trying to simply identify each unique customer by showing the primary folder/file name for that customer (not the related folders/files). For example, I may have 100 records for Jane Doe, but I simply want to show the first folder/file name for "Jane Doe." Based on my data, I think I can do this by searching for folder/file names that end with "loan file/" and identify that record as a unique customer. My customer list is constantly changing, so I can't have a reference to "Jane Doe" in my formula. I just want to see one cell that I can identify Jane Doe as a unique customer.
Thanks so much for any help!
Jeff
Bookmarks