Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting text and numbers from multiple tabs
I have a master file I am working on in which data on one tab is linked to
other tabs. I have a macro for them to be sorted, but when I sort, only the numbers sort and then the words are bumped to the bottom of the sorting block. I end up with numbers sorted and then a huge gap with the words sorted at the bottom. Any suggestions to fix this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting text and numbers from multiple tabs
That's how Excel sorts.
Numbers first then if your link formulas return "" they will appear then text. Gord Dibben MS Excel MVP On Thu, 3 Jul 2008 10:48:01 -0700, Jessabez wrote: I have a master file I am working on in which data on one tab is linked to other tabs. I have a macro for them to be sorted, but when I sort, only the numbers sort and then the words are bumped to the bottom of the sorting block. I end up with numbers sorted and then a huge gap with the words sorted at the bottom. Any suggestions to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting multiple tabs in Excel | Excel Discussion (Misc queries) | |||
Page Numbers and Multiple Tabs (Excel 2000) | Excel Discussion (Misc queries) | |||
Increment Page Numbers for multiple tabs in Excel | Excel Worksheet Functions | |||
Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) | |||
Sorting Numbers with Multiple Decimals | Excel Discussion (Misc queries) |