Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
question for indexing a table
if i have this table:
name status cris single jasper single apple married rd single jojo married how can i create a new column that will show all single persons lined up at the top. and would look like this. NAME STATUS QUERY cris single cris jasper single jasper apple married rd rd single jojo married thanks in advance -- technical newbie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
question for indexing a table
Use DataFilterAdvanced filter or Automatic filter
HTH -- AP "martin" a écrit dans le message de news: ... if i have this table: name status cris single jasper single apple married rd single jojo married how can i create a new column that will show all single persons lined up at the top. and would look like this. NAME STATUS QUERY cris single cris jasper single jasper apple married rd rd single jojo married thanks in advance -- technical newbie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
question for indexing a table
thanks! :)
but do you have a formula or something like index(....). im not sure though. thanks again. -- technical newbie "Ardus Petus" wrote: Use DataFilterAdvanced filter or Automatic filter HTH -- AP "martin" a écrit dans le message de news: ... if i have this table: name status cris single jasper single apple married rd single jojo married how can i create a new column that will show all single persons lined up at the top. and would look like this. NAME STATUS QUERY cris single cris jasper single jasper apple married rd rd single jojo married thanks in advance -- technical newbie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
question for indexing a table
In I1 type name
J1: status J2: single select A:B Goto Data.FilterAdvanced Filter click the Copy to another location button In Criteria, select I1:J2 In Copy To select C1:D1 OK -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "martin" wrote in message ... thanks! :) but do you have a formula or something like index(....). im not sure though. thanks again. -- technical newbie "Ardus Petus" wrote: Use DataFilterAdvanced filter or Automatic filter HTH -- AP "martin" a écrit dans le message de news: ... if i have this table: name status cris single jasper single apple married rd single jojo married how can i create a new column that will show all single persons lined up at the top. and would look like this. NAME STATUS QUERY cris single cris jasper single jasper apple married rd rd single jojo married thanks in advance -- technical newbie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Pivot Table Question - a puzzler | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
Data Table Question | Charts and Charting in Excel |