| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count the number between range of cell for a particular person
I want to count the numbers between 1 to 10 from the range for a particular person as seen in the below example.
Keyword Rank__________Person Name 1_____________John 5_____________Agnes 8_____________Agnes 12____________John 20____________Agnes 13____________Agnes 3_____________John 40____________John 8_____________John 15____________Agnes 10____________John I want to count the the numbers that John has between 1 to 10 only. In the above case John must have 4 Keyword Ran between 1 to 10 Please help! Thanks in advance Faiz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of a range of words in a cell | Excel Worksheet Functions | |||
| Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
| count a number range and a letter in a cell | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Threaded Mode
