Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Req, Tricky column formula
I have a column 'AO' with numbers 1-9 in rows AO1:AO9 being recovery days. I also have columns 'AR'-'AX' with the number of people i.e. 2,0,2,2,0,0,0. in the first row, representing people on the days of the week in the next row I have 4,4,0,0,0,0,0, and so on for the 9 rows. My problem is that I need to get the result in columns AY1:BE9 the result being: If 'AO1'=1 day recovery and the number of people is 2,0,2,2,0,0,0 (from above in columns AR1:AX1) the number of days should be placed in AY1:BE1 and the answer is 2.0.2.2.0.0.0 If 'AO2' = 2 days recovery and the number of people is 4,4,0,0,0,0,0 the number of days in columns AY2:BE2 should be 4,8,4,0,0,0,0 If 'AO8' = 3 recovery days and the number of people is 0,0,0,2,1,0,0 the number of days in columns AY3:BE3 should be 0,0,0,2,3,3,1 I hope you can understand what I am talking about as it is easier to think about the problem than to write it. Any help would be useful or if you wish any other info please let me know. Thanks stge -- stge ------------------------------------------------------------------------ stge's Profile: http://www.excelforum.com/member.php...o&userid=16068 View this thread: http://www.excelforum.com/showthread...hreadid=276540 |
#2
|
|||
|
|||
Write in AY1:
=SUM(OFFSET(AR1,0,-MIN($AO1,COLUMN()-COLUMN($AY1)+1) +1,1,MIN($AO1,COLUMN()-COLUMN($AY1)+1))) and then copy to AZ1:BE1 and to AY2:BE9. HTH, sulprobil -- Reverse(moc.liborplus.www) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula do I use to add to a date column in Excel? | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Adding TR to the end of each value in a column..formula | Excel Worksheet Functions | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions | |||
Tricky formulas needed | Excel Worksheet Functions |