I have data in a sheet 1 that reference sheet 2 ie ='Main Summary '!F8
Sheet 2 is the "main Summary" sheet where the primary data is entered.
The data in sheet 1 is in a table when i use the sort ( smallest to largest )option it sorts the formulas in blank cell and put them at the top so i get all the blank lines before i get a readable cell.
Does anyone kjnow how to get the sort to ignore the cells that contain formulas or degrade their inportance in the sort so they appear at the bottom of the list.
thanks,
All
Bookmarks