Forum Discussion
Help with Sorting\Duplicates
Hi there, I'm trying to group duplicates but excel does not see A020601E and A02-06-01E as a duplicate due to the dashes. Is there a way to trick it into thinking this ?
2 Replies
A few options might work for you depending on version and data set.
Formula (see attached xlsx):
=LET(arr,BYROW(D2:D11,LAMBDA(row,TEXTJOIN(,,TEXTSPLIT(row,"-")))),SORT(arr))You might also consider creating a custom list and then sorting on the custom list if the number of unique items you have is reasonable.
- thank you, this formula will at least allow me to now highlight duplicate values and count available space faster.
