Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 11th 19, 07:17 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2019
Posts: 30
Default 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   Report Post  
Old September 11th 19, 07:56 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,713
Default 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   Report Post  
Old September 12th 19, 04:35 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2019
Posts: 30
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change all cells from minus to plus and plus to minus Rockbear Excel Worksheet Functions 3 October 10th 08 09:49 AM
YTD value minus prev mth value = curent month - Rolling Report karenm Excel Worksheet Functions 0 September 27th 07 09:16 PM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS Socal Analyst looking for help Excel Discussion (Misc queries) 2 May 12th 06 07:17 PM
Fill an individual report with values from a team report? alymcmorland[_4_] Excel Programming 2 October 13th 05 09:39 AM


All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017