hi,
sorry if this question has already been addressed.
I would greatly appreciate if someone could help me set up a formula to rearrange the order of cells if the value in one cell is greater than in another.
EX:
A1 = "Team 1"; B1 = "25"; C1 = "Team 2"; D1 = "30"
how would you write a formula or macro that would swap A1 with C1 and B1 with D1 if the value of D1 is greater than B1?
I learn quick but am not an Excel pro.
many thanks.
Bookmarks