Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort By Find All
Hi,
Is there a way that I can I use "Find All" and and get Excel to show me the result sorted instead of viewing them one at a time. I cannot use "Sort" as "Find" can pick my criteria anywhere in a cell. -- tarig |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort By Find All
Perhaps you might want to try autofilter (DataFilterAutofilter)
For the sorting bit, you could copy n paste the filtered results into a new sheet (only the filtered results gets pasted over), then sort it to taste -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tarig" wrote: Is there a way that I can I use "Find All" and and get Excel to show me the result sorted instead of viewing them one at a time. I cannot use "Sort" as "Find" can pick my criteria anywhere in a cell. -- tarig |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort By Find All
Hi Max,
Actually I am new to auto filter. Will auto filter pick my criteria even if it is in the middle of a cell? for example if among many cells I have two cells contain "total gold sales" and in another one I have "cost of sales (gold)" can I put "gold" as my criteria and get those two line as a result for my auto filter? Thanks in advance -- tarig "Max" wrote: Perhaps you might want to try autofilter (DataFilterAutofilter) For the sorting bit, you could copy n paste the filtered results into a new sheet (only the filtered results gets pasted over), then sort it to taste -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tarig" wrote: Is there a way that I can I use "Find All" and and get Excel to show me the result sorted instead of viewing them one at a time. I cannot use "Sort" as "Find" can pick my criteria anywhere in a cell. -- tarig |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort By Find All
It has the option you seek ("contains")
In the autofilter droplist, click Custom, then choose the droplist option: contains under "Show rows where", & input: gold as your criteria -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Tarig" wrote: Hi Max, Actually I am new to auto filter. Will auto filter pick my criteria even if it is in the middle of a cell? for example if among many cells I have two cells contain "total gold sales" and in another one I have "cost of sales (gold)" can I put "gold" as my criteria and get those two line as a result for my auto filter? Thanks in advance -- tarig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and replace--Sort Of | New Users to Excel | |||
Where do i find the sort tool in Office XP? | Excel Discussion (Misc queries) | |||
find then sort formula | Excel Worksheet Functions | |||
VBA, excel - find, resize and sort | Excel Worksheet Functions | |||
VBA, Excel - Find Range, Sort | Excel Worksheet Functions |