| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Hi Daniel
thanks for the hint. You're right, my original formula works only if there're no blank rows in between. -- Regards Frank Kabel Frankfurt, Germany "Daniel.M" schrieb im Newsbeitrag ... Hi Frank, You should always use ROWS(A1:A20) instead of COUNTA(A1:A20) because the result of MATCH() can produce a number higher than COUNTA(). Therefore the FREQUENCY() will distribute ALL those values in the SAME bucket (the last one). Ex with A1:A5 range: blank 34 blank 34 blank 34 1 200408 2 200408 Returns 1 but should return 2. Regards, Daniel M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| How do I get unique values from 2 columns? | Excel Discussion (Misc queries) | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
| Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
Threaded Mode
