| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help Fill Down problem
Sorry about the cross post but I'm getting desperate...
row 1 contains headers. col A and C contain values. I need to populate Col B with values like the following B2 needs to read R2C3 B3 needs to read R2C4 B4 needs to read R2C5 B5 needs to read R3C3 B6 needs to read R3C4 B7 needs to read R3C5 B8 needs to read R4C3 B9 needs to read R4C4 B10 needs to read R4C5 etc... I was given... =OFFSET($C$4,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3)) But it's not working because of the values that I have in columns A and C. Any and all help is greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
| Fill handle formula | Excel Worksheet Functions | |||
| Fill handle problem XP | Excel Discussion (Misc queries) | |||
| A different "Fill Color" problem | Excel Worksheet Functions | |||
| A different "Fill Color" problem | Excel Worksheet Functions | |||
Threaded Mode
