Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Report within a row the Last used ColumnNr minus ForeLast Used ColumnNr
Hello,
New challange :). I tried to figure it out with Index/Match formula, but........ :( Better (?) to solve with a macro. So if there's a solution.... Thx! In column H (=8) I need to report the last used column with data, within the same row, within the range of column I (=9) till AP (=42) minus the ForeLast used column with data. For example; Column AA (=27) has data "xx" Column AL (=38) has data "xxx" Column AO (=41) has data "xxxx" Then reporting in the specific row in column H - 41-38= 3 because LastUsedColumn = 41 and ForeLastUsedColumn = 38. Then reporting 41-38=3 regards, Johan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change all cells from minus to plus and plus to minus | Excel Worksheet Functions | |||
YTD value minus prev mth value = curent month - Rolling Report | Excel Worksheet Functions | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
Fill an individual report with values from a team report? | Excel Programming |