Remember Me?

#1
September 11th 19, 07:17 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: May 2019 Posts: 43
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

#2
September 11th 19, 07:56 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,763
Report within a row the Last used ColumnNr minus ForeLast Used ColumnNr

Hi Johan,

Am Wed, 11 Sep 2019 11:17:15 -0700 (PDT) schrieb JS SL:

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

try:
=MAX((I1:AP1<"")*COLUMN(I:AP))-LARGE(IF(I1:AP1<"",COLUMN(I:AP)),2)
and insert that formula with CTRL+Shift+Enter

Regards
Claus B.
--
Windows10
Office 2016
#3
September 12th 19, 04:35 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: May 2019 Posts: 43
Report within a row the Last used ColumnNr minus ForeLast Used ColumnNr

Claus,

SuperThanks. Works as wished (as usual)
Also thx for youre quick respons on it.

regards, Johan

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Rockbear Excel Worksheet Functions 3 October 10th 08 09:49 AM karenm Excel Worksheet Functions 0 September 27th 07 09:16 PM Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM Socal Analyst looking for help Excel Discussion (Misc queries) 2 May 12th 06 07:17 PM alymcmorland[_4_] Excel Programming 2 October 13th 05 09:39 AM

All times are GMT +1. The time now is 08:12 AM.