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
Which column do you want the Total on
AR total - not sure where it refers to.
If for example you need it for column G, try something like this (OR ON ANY OTHER COLUMN)
Formula:
Please Login or Register to view this content.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks