Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a range of data that lists the names of items and also the date that
that item was inspected. For example Strawberries are listed numerous times with the date that they were inspected, the same with other fruits. I would like to find out how many times Strawberries were entered into the database and what the last date was where they were inspected. I know that I can use the "countif" fuction to return the number of times that the item was inspected, but I am having a hard time returning the cell that has the date of the last time the strawberries were inspected. Is there some find function that can keep track of the "countif" function and return the value of a cell next to the last "count"? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
finding a max date in a range in vlookup data | Excel Discussion (Misc queries) | |||
finding a value between a range | Excel Worksheet Functions | |||
finding name within range | Excel Worksheet Functions | |||
finding if name within range | Excel Worksheet Functions | |||
Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions |