I have a spreadsheet of 10 employees (column A) with a data validation list of products (column b). I created two different formulas in columns C & D to extract all of the digits from the product names in column A in attempt to setup a rank formula from lowest to highest $ amount. The problem is employees can have two different products or the same, but the formulas view them the same (ie $500-$20 & $500-$40 - formula views them as 500). I am searching for a rank formula solution that can differentiate products that have the same dollar amounts.
Desired Result:Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks