We're looking to quickly identify the highest AR totals on a spreadsheet but the data is not uniform. There are numerous blank cells throughout the columns, and overlapping data. I have no clue where to start other than there is no quick way and the table needs to be reformatted. I uploaded a sample. Actual file is about 1900 rows
Thanks for your help
Bookmarks