I've currently have the following formula:
What this currently does is look in the Data Dump - Retail worksheet and displays the largest value in column L (which is a number value) as long as it meets the criteria that the same row with the highest value also has Column A = 1 and Column C = 0.
The problem that I've run in to is that instead of looking in column A for the highest numerical value, I'd like it to now like in column H for the highest alphabetical value. Column H includes cells that start with #'s and letters so I'd want the numbers displayed first followed by A-Z.
Any help with this would be greatly appreciated. Thanks
Bookmarks