| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 81297 | 2007-07-23 08:13:00 | Excel Formula | rodlea (12584) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 571748 | 2007-07-23 08:13:00 | Some years ago there was an article that gave a formula for returning the last number in a column. I have the formula but cannot get it to activate. The formula:- {INDIRECT(ADDRESS(MAX((ROW(1:86)*B1:B86><""))),COLUMN(B:B)))} Where 1:86 is the cell range in column B. Can you help? Thanks Rod |
rodlea (12584) | ||
| 571749 | 2007-07-23 08:14:00 | Reply to rodlea@enterprise2000.co.nz | rodlea (12584) | ||
| 571750 | 2007-07-23 09:29:00 | Um, you'll get a reply right here or as a PM. As a rule and common sense, don't post your email address in here. I'm sure a mod will take it down later. | beeswax34 (63) | ||
| 1 | |||||