Hi,
I need urgent help in order to meet a dead line -
Attached is an excel file with two columns of numbers. The first formula I need to formulate is a formula that will automatically count how many unique numbers there are in a column of numbers which has been sorted from smallest to largest (or vice versa). See example in column D. The amount of times each unique number came up I manually typed in adjacent column E. I need a formula (or Excel function) that will automatically count those values for me. This is such a simple and basic function that I am surprised that there is no function for it in the top function banner of Excel.
The second counting formula I need is a formula which will count how many times a specified value appears in a cell directly below, then 2 cells below, and then 3 cells below a cell with a specified value. See example in attached file. Column B contains cells with different values. For this example, I have highlighted the cells which contain the value 5. All I need is a counting formula which must be added next to each purple cell in the 3 charts which will automatically count the number of times each value specified in each purple cell came up. I must be able to apply the formula to any number I want to target and not only the number 5.
I have done the count manually so that when the formulas are typed into each cell in the three charts, the value shown matches the value I have typed into each cell next to the purple cells. This will also help you understand what I need counted. Please paste the formulas directly into the charts in the attached excel file, since I am not a computer programmer so I won't understand how to write out the formula if you explain it to me step by step.
Thank you so much to whomever can formulate these simple counting formulas.
Jackblack2
Bookmarks