Oh my! I was able to press alt+f8 and enter the function. I pasted the formula in a blank cell (AA) and it did exactly what was expected. I did receive a few #value! errors. Luke - Thank you so very much. I am in awe.
With this, is there a method to delete the duplicate lines after this runs...
I have been tearing out what is left of my hair trying to sort data in a spreadsheet. The long and short of it is I have a sheet of data related to member information. Column's A-Z. Column A has case_num and can be listed several times within rows of data.
Many of the lines can have dup...