I have a spreadsheet with some sumproduct, vlookup and if formulas and when I try to sort the spreadsheet it doesn't work. I mean it sorts but not in any order.
I tried text to column conversion but it doesn't work for columns with formulas .
Any idea how to fix this problem.
P.S. - I know I can paste as special value and maybe sort then but I don't want to do that because I will loose formulas.
Thanks
Bookmarks