Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number of times a number is shown
I am wondering if there is a formula to show how often a number is listed.
ie. List 1, 2, 3, 4, 5, 2, 4, 3, 1, 1, 5, 2, 3 This would show 1: 8, 1 2: 4, 6 3: 5, 5 4: 3 5: 6 in other words show the number of times between when the number showed and the next time it showed. Thank you. PS - It would be even more help if the numbers are listed down the column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of times a particular charcter ("." say) | Excel Discussion (Misc queries) | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
how do I get a calculation to repeat various number of times? | Excel Worksheet Functions |