A Ashu New Member Apr 3, 2014 #1 I want to know how to use formula in excel to sort parts in column A by price in column B. The desired result would be that after putting in the formula in column C I should be able to get the ranking based on price. Please see attached spreadsheet. Attachments sort by formula.xlsx sort by formula.xlsx 9.3 KB · Views: 13
I want to know how to use formula in excel to sort parts in column A by price in column B. The desired result would be that after putting in the formula in column C I should be able to get the ranking based on price. Please see attached spreadsheet.
H Haseeb A Active Member Apr 3, 2014 #2 Hello Ashu In C2, then copy down. =COUNTIFS(A$2:A$11,A2,B$2:B$11,"<"&B2)+1
A Ashu New Member Apr 3, 2014 #3 Thanks for the quick response Haseeb. The formula works. Appreciate your help on this one.
