Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset/COUNTA problems
I have a spreadsheet that looks like this:
A B Time In Time Out 12:15 PM 8:00 PM 2:00 PM 3:00 PM 4:00 PM 6:00 PM 6:00 PM 6:30 PM 8:00 PM 11:30 PM I'm trying to use the formula: =OFFSET(HeadCount!$B $1,0,0,COUNTA(HeadCount!$B:$B),1) to come up with the last value in column B, which should be 11:30pm. However, I keep getting a #VALUE! error. If I take out the COUNTA part and just use: =OFFSET(HeadCount! $B$1,0,0,6,1) I still get the error. If I replace the Row value of 6 with 1 in this formula, it gives me the correct value of "Time Out". Why won't it return the value when it is a time format? Can anyone tell me what I'm doing wrong. COUNTA and OFFSET work fine independently. Thanks for any help! -Josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Problems with offset/average formula | Excel Worksheet Functions | |||
COUNTA | Excel Worksheet Functions | |||
Problems copying cells using offset and counta | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |