Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Or this if you prefer: =IF(E2="","",OFFSET(E2,0,IF(D2="",-($B5+1),-$B5))) -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=545449 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
Question for use of offset and range | Excel Worksheet Functions | |||
Date Format Question | Excel Discussion (Misc queries) | |||
OFFSET function question | Excel Worksheet Functions |