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
|