| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
Great, that worked, Thanks!!
"JE McGimpsey" wrote: One way: =INDEX(H29:IV29,COUNTA(H5:IV5)) In article , carol wrote: Hi, I have a worksheet with information on money held by 20 different people. In each sheet (1 per client), I input the latest values in the column next to the last column used. I dont overright the previous value, therefore it tracks the performance of the money at periodic intervals. The date of these values is recorded at the top of the column, with the values below. Therefore the date cells aH5, I5, J5, K5 (with K5 being the latest valuation date) The value cells a H29, I29, J29, K29 (with K29 being the latest value) In sheet 1, I want to see at a glace the latest valuation per client. This needs to look into the date row and pick out the latest date, then generate the corresponding value for it. Any ideas? Please help, I have racked my brain with this one! Thanks in advance. |
Threaded Mode
