Hello -
I have thousands of ID's in a single column and need to find all ID's that have a (-#) the # are varied; 1, 2 3 etc... at the end. Sorting does not work, the -# are at the end of the ID.
Thank You!!
Hello -
I have thousands of ID's in a single column and need to find all ID's that have a (-#) the # are varied; 1, 2 3 etc... at the end. Sorting does not work, the -# are at the end of the ID.
Thank You!!
Try the autofilter - Custom - Select "ends with" and use -* as string ( that is supposing ther are no other such strings in the cell - If not please provide a small sample sheet
In a helpcolumn =right(a1,1) and then you can filter on that.
Otherwise post an excelfile without confidentional information.
Please also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here is an example. The raw data is in column A
The formula in column B displays only those values with the trailing -*.
Column C results from copying column B over and sorting descending.
Applying an Advanced filter to column C and selecting unique records only results in column D
Gary's Student
Pepe - Thank you for the suggestion, I am dealing with 10's of thousand of rows, to many for the auto filter. My apologies for not sharing that in my original post.
oeldere - Thanks for the suggestion. That did not work, it provided me with the final digit in the ID. I need to find only the ID's with a -1 or -2 or -3 etc... I am dealing with 10's of thousands of ID's so filtering does not work either.
Jakobshavn - Thank You, this worked great!! Exactley what I need...Thank You!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks