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

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

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

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