Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Formula Creation??
I am trying to a create a dynamic formula which can reference the
right-most column in a particular row which has data in it. For simplicity sake let's say I have a list of salemen in column A, & then in cells B1-M1, I have the months of the year. After each month ends, new sales data is populated in the next column (the 'right-most'), & that process continues each month. On another sheet, I have a cell which I want to show "last month" sales & "last month-1" sales. Obviously as each month is completed, "last month" moves from column b, to c, to d, .... So if I want to reference John Smith's last month sales volume & he is in row 5 & the current month is March, then the cell & want to reference to get that value is "C5"...w/ 'C' having Feb dated & his being in row five. I have tried playing around using OFFSET, but haven't gotten it to return what I'm expecting it to. Please share any suggestions that you may have.....THANKS!!! M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Formula Creation??
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
Need help with a dynamic lookup and logical formula | Excel Worksheet Functions | |||
Help with dynamic sum formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |