G
Guest
I know to pull the earliest date or latest date from a range of cells I use
the min or max functions, but I need to wirte a more complex statement.
1.) I need to search a range of cells and pull the earliest date and latest
date for all those tools.
2.) The problem is that tools are not in any order, but they are all in one
column.
3.) There is duplicate tools, I just want to find the earliest date and
latest date for that tool.
4.) I also need to group all the blanks together and group them into one tool.
5.) I know it probably needs to be an if statement, i just don't know how to
write it.
(Lets assume the tools are in column A and the dates are in column B through
Z)
Example tools:
EWR - 6.75
ALD - 6.75
IQ
the min or max functions, but I need to wirte a more complex statement.
1.) I need to search a range of cells and pull the earliest date and latest
date for all those tools.
2.) The problem is that tools are not in any order, but they are all in one
column.
3.) There is duplicate tools, I just want to find the earliest date and
latest date for that tool.
4.) I also need to group all the blanks together and group them into one tool.
5.) I know it probably needs to be an if statement, i just don't know how to
write it.
(Lets assume the tools are in column A and the dates are in column B through
Z)
Example tools:
EWR - 6.75
ALD - 6.75
IQ