Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of items in a set
Hi there
Is there a formula to get the number of items in a list defined like this:, product a, b, c ... has points, and the list is ordered with decreasing points values. The set is composed of the products that have points greater or equals to the number in the set. So for example, with two columns: a 6 b 6 c 4 d 4 e 2 f 1 g 0 The set is made of a, b, c, d and the result would be 4. I know I could solve this with vb, but I wonder if a formula could give me the result. I have tried something with COUNTIF be the trick is that I would need a criteria saying value in current cell <= row of the current cell Thanks a lot for any help Francois |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum a variable number of items | Excel Worksheet Functions | |||
Sum a different number of items | Excel Worksheet Functions | |||
number of items fit into item | Excel Worksheet Functions | |||
Number of items in a colum | Excel Worksheet Functions | |||
Number of items per day in chart. | Charts and Charting in Excel |