Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter question
Hi,
I have a filter question. column A needs to stay numerical. ( 1,2,3,4,5,6 etc) Columns b to G need to be filtered in order of Client name ( column B) Can this be done? if so, can it be done automatically or with the help of a macro? Thanks, Nigel |
#2
|
|||
|
|||
make sure that column A is numeric and not the result of an equation.
select all that you want to stay together while sorted. select <data<sort and sort by column B "Nigel" wrote: Hi, I have a filter question. column A needs to stay numerical. ( 1,2,3,4,5,6 etc) Columns b to G need to be filtered in order of Client name ( column B) Can this be done? if so, can it be done automatically or with the help of a macro? Thanks, Nigel |
#3
|
|||
|
|||
Nigel
Sounds more like a Data Sort than a Filter. Do you want Column A to read 1,2,3,4,5,6 no matter what order the other columns are in? In A1 enter =ROW() and copy that down to end of data. Now do your sort and the 1,2,3,4,5,6 order will remain. Gord Dibben Excel MVP On Thu, 5 May 2005 03:21:03 -0700, "Nigel" wrote: Hi, I have a filter question. column A needs to stay numerical. ( 1,2,3,4,5,6 etc) Columns b to G need to be filtered in order of Client name ( column B) Can this be done? if so, can it be done automatically or with the help of a macro? Thanks, Nigel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) | |||
Advanced filter question | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions |