Prato Search

E

Excel Searches

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

Excel Searches

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

Gary''s Student

In that case, they probably meant Pareto search. The Pareto search algoithm
is used in decision analysis and in general six sigma work.
 
J

Jim Cone

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 [email protected]>
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?
 
M

Mike Middleton

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
 
J

Jim Cone

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"
<[email protected]>
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
 
Top