Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clustering
Hi,
I have following data in columns A and B. Column A is the average price column B is the number of guests that paid this price A B 4,5 10 4,6 8 5,2 1 7,2 2 7,4 4 9 2 I would like to count the guests that paid a price between 0 and 5 (10), 5,1 and 7 (1), 7,1 to 8 (6) and more than 8 (2). In my real problem have 1200 different prices with 250000 guests. I tried to use the histogram function but that counted only the number rows and not the content of the column B. How can I do this? Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|