It was suggested that a workbook that I use be sorted using a prato search.
I cannot find anything on this. Could anyone help?

Are you sorting towns in Tuscany or locations within the town of Prato?
--
Gary''s Student


"Excel Searches" wrote:

It was suggested that a workbook that I use be sorted using a prato search.
I cannot find anything on this. Could anyone help?

I am actually filling in a workbook that shows all complaints I have received
in our quality department. Our auitor suggested using a prato search to sort
the data so that I can group them together and track my complaints that are
the same.

"Gary''s Student" wrote:

Are you sorting towns in Tuscany or locations within the town of Prato?
--
Gary''s Student


"Excel Searches" wrote:

It was suggested that a workbook that I use be sorted using a prato search.
I cannot find anything on this. Could anyone help?

In that case, they probably meant Pareto search. The Pareto search algoithm
is used in decision analysis and in general six sigma work.
--
Gary''s Student


"Excel Searches" wrote:

I am actually filling in a workbook that shows all complaints I have received
in our quality department. Our auitor suggested using a prato search to sort
the data so that I can group them together and track my complaints that are
the same.

"Gary''s Student" wrote:

Are you sorting towns in Tuscany or locations within the town of Prato?
--
Gary''s Student


"Excel Searches" wrote:

It was suggested that a workbook that I use be sorted using a prato search.
I cannot find anything on this. Could anyone help?

ES,

Possibly they meant...A Pareto diagram (chart)
From a Tushar Mehta posting...

A Pareto chart is a column chart of data sorted in descending order.
To have XL do the work, check the 'Histogram' capability in the Analysis ToolPak...
Tools | Add-Ins | Analysis ToolPak
then...
Tools | Data Analysis... | Histogram.

Jim Cone
San Francisco, USA


<Excel
wrote in message
...
It was suggested that a workbook that I use be sorted using a prato search.
I cannot find anything on this. Could anyone help?

Jim -

Unfortunately, as I recall, the Pareto option of the Histogram tool is of
very limited value because, once again as I recall, it requires numeric
data. It would be more useful for most purposes if it could work on a list
of text values. So, COUNTIF could be a useful workaround if the data are
text values; then, sort by counts, and construct a Column chart type.

- Mike
www.mikemiddleton.com

"Jim Cone" wrote in message
...
ES,

Possibly they meant...A Pareto diagram (chart)
From a Tushar Mehta posting...

A Pareto chart is a column chart of data sorted in descending order.
To have XL do the work, check the 'Histogram' capability in the Analysis
ToolPak...
Tools | Add-Ins | Analysis ToolPak
then...
Tools | Data Analysis... | Histogram.

Jim Cone
San Francisco, USA


<Excel
wrote in message
...
It was suggested that a workbook that I use be sorted using a prato
search.
I cannot find anything on this. Could anyone help?

Mike,
Yes, when I gave a quick try with the histogram before I posted my reply,
it refused to continue because the column title was included in the selection.

A pivot table is probably the quickest way to get an item count from a single
column list. It's frankly amazing.
Regards,
Jim Cone


"Mike Middleton"

wrote in message
...
Jim -
Unfortunately, as I recall, the Pareto option of the Histogram tool is of
very limited value because, once again as I recall, it requires numeric
data. It would be more useful for most purposes if it could work on a list
of text values. So, COUNTIF could be a useful workaround if the data are
text values; then, sort by counts, and construct a Column chart type.

- Mike
www.mikemiddleton.com

"Jim Cone" wrote in message
...
ES,

Possibly they meant...A Pareto diagram (chart)
From a Tushar Mehta posting...
A Pareto chart is a column chart of data sorted in descending order.
To have XL do the work, check the 'Histogram' capability in the Analysis
ToolPak...
Tools | Add-Ins | Analysis ToolPak
then...
Tools | Data Analysis... | Histogram.
Jim Cone
San Francisco, USA


<Excel
wrote in message
...
It was suggested that a workbook that I use be sorted using a prato
search. I cannot find anything on this. Could anyone help?