Need help with a complex formula I cant solve. Please help. Re-order column numbers.....

Originally Posted by AliGW

There are instructions at the top of the page explaining how to attach your sample workbook.

I am sorry. It will not happen again. I did not have my attention there. I am sorry

Originally Posted by Fluff13

How about

Formula:

=COUNTIFS(C:C,C2,A:A,"<"&A2)+1

I don't believe it. Thank you so much. Of course countifs, this is the problem with me, I always looking to combine formulas instead to write a single function of formula like countifs.

Thank you so much.