So my job requires me to take a spreadsheet and sort its items by kit version. So, 2500 rows (stores) and 50 columns (items). I use concat from say M2:BJ2 and copy it down to all the rows. All the item cells within are filled with a number, some are 0 if a store does not get that item. In the end, I want to sort the concatenated column so I can determine how many like kit versions there are. This has worked flawlessly in the past, but recently I am having issues with the larger sheets. The concatenated column does not sort properly, so my formula in the column next to it gives me 429 kit versions, but if delete all the duplicate values in the concatenated column, i get 122 unique values. Not sure what the issue is, but hoping someone may be able to help. Thank you!
Bookmarks