I am trying to find a formula or something that will let me swap two cell ranges.
I have a starting range with TRUE and FALSE but I am looking for something that will see "if True swap data between G5 and I5 if G5 is greater than I5, otherwise leave as is."
If some one can help me out it will save me alot of time.
I have a starting range with TRUE and FALSE but I am looking for something that will see "if True swap data between G5 and I5 if G5 is greater than I5, otherwise leave as is."
If some one can help me out it will save me alot of time.