Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i referance an adjacent cell from a search?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i referance an adjacent cell from a search?
=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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i referance an adjacent cell from a search?
I tried this and in the formula arguement it works perfectly but in the
spread sheet it displays #value. "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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i referance an adjacent cell from a search?
Get rid of the merged cells.
One more reason not to use merged cells............one I never ran across before. I'll add it to the long list of problems caused by these. Gord Dibben MS Excel MVP On Fri, 18 May 2007 06:57:01 -0700, UH-60 Crew Chief wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a cell referance on multipule cells | Excel Worksheet Functions | |||
HOW DO I CREATE LISTS WITH CELL REFERANCE RULES | Excel Worksheet Functions | |||
Change cell referance based on value | Excel Worksheet Functions | |||
Formula that referance a Cell | Excel Discussion (Misc queries) | |||
Cell referance for formula | Excel Worksheet Functions |