formula please

  • Thread starter Thread starter Ivan Palèiæ
  • Start date Start date
I

Ivan Palèiæ

which formula can i use in a table with nummbers that provides the order of
numbers that are most common in that table. example 1- 256times
25-185 times and so on
tnx
 
Hi Ivan
not a formula solution but one way: I#d use a pivot tabel for this. Use
your number column as row in the pivot chart layout. For data use the
Countof for this row. This will create a report with your numbers and
the individual count per number. Just sort this pivot report

HTH
Frank
 
Ivan,
Another option is to create a histogram using Data Analysis. Look under Tools>Data_Analysis>Histogram. If you list the values in your table in a seperate table, you can use this as the Bin Range. Be sure to uncheck the labels box.

If you check the Pareto box excel will produce two tables. The first will have the bin numbers in numerical order. The second will have the bin numbers in size order.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Ivan Palèiæ wrote: -----

which formula can i use in a table with nummbers that provides the order of
numbers that are most common in that table. example 1- 256times
25-185 times and so on
tnx
 
Back
Top