Hi community,
Need help with an excel rebus. I'm looking to a formula which can substitutes items = "SV" with same items starting from the items with highest value.
It's not possible to replace an item with another one. So "Apple" can be substituted with ohter "Apple".
I attach the file with example and desirable result.
mrxcel.xlsx
thank you in advance for your help.
hern
Bookmarks