| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference
how can I reference to the last cell with numbers in a raw.
example column a to e in raw 2 are days. Column g is last cell updated amount. When Monday is updated Monday amount and when Friday is updated Friday amount Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell reference
To return the number........
=LOOKUP(99^99,1:1) To return the cell address....... =ADDRESS(MATCH(99^99,1:1),1) Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 09:16:01 -0700, Durai wrote: how can I reference to the last cell with numbers in a raw. example column a to e in raw 2 are days. Column g is last cell updated amount. When Monday is updated Monday amount and when Friday is updated Friday amount Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell reference
Sorry I am not an expert My example is as follows
Raw1 Monday Tuesday Wednesday Last inventory raw 2 2000 3000 3000 As above I like to have 3000 as last inventory as that was the last cell updated lately. Please help. Thanks "Gord Dibben" wrote: To return the number........ =LOOKUP(99^99,1:1) To return the cell address....... =ADDRESS(MATCH(99^99,1:1),1) Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 09:16:01 -0700, Durai wrote: how can I reference to the last cell with numbers in a raw. example column a to e in raw 2 are days. Column g is last cell updated amount. When Monday is updated Monday amount and when Friday is updated Friday amount Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell reference
Works very well. Thanks. Please iqnore my earlier reply. Ihad to specify the
range and it worked. "Gord Dibben" wrote: To return the number........ =LOOKUP(99^99,1:1) To return the cell address....... =ADDRESS(MATCH(99^99,1:1),1) Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 09:16:01 -0700, Durai wrote: how can I reference to the last cell with numbers in a raw. example column a to e in raw 2 are days. Column g is last cell updated amount. When Monday is updated Monday amount and when Friday is updated Friday amount Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Hybrid Mode
