Please help!
I need a formula to count the number of occurances of a range within a column. I have 9,000 rows with number that range from 1-1,000,000. When the number gets above 500,000, I need to count that range as 1. I don't need to count the total number of times a number =>500,000 occurs. Just need the number of ranges from 500,000 to 1,000,000 occurs.
Does this make sense? For instance, the answer below would be 3.
458,852
456,381
455,653
532,919
651,894
458,852
456,381
455,653
902,403
901,299
456,381
455,653
899,106
901,783
Bookmarks