Sort By Find All

T

Tarig

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.
 
M

Max

Perhaps you might want to try autofilter (Data>Filter>Autofilter)
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
 
T

Tarig

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
 
M

Max

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
 
Top