how do i referance an adjacent cell from a search?
Worked great in formula arguement box, but when i hit ctr-shift-enter it
gives the error "Array formulas are not valid in merged cells"
"excelent" wrote:
=INDEX(A1:A30,MATCH(MAX(IF($B$1:$B$30="NVG",$A$1:$ A$30,0)),$A$1:$A$30,0))
insert and hit ctrl+shift+enter (array)
"UH-60 Crew Chief" skrev:
i have a table in excell, Column A is the Date of the flight, Column B is the
mode (day, night, NVG) and column C is the number of hours flown.
i need the formula to find the most recent date that i flew night in one
cell and in another cell i need to find the most recent date that i flew NVG.
can anyone help?
|