Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old November 27th 20, 09:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default Show value of first non contiguous data

Hi,

Am Fri, 27 Nov 2020 12:46:15 -0800 (PST) schrieb Xxer Xxes:

for this above one , is my last request on today ;
to change rows instead columns, and bring the adress number of
the row with data ,
for below range adress :

=INDEX($A$101:$A$1500,SMALL(IF($A$101:$A$1500<"", ROW($1:$1400)),ROW(A1)))


try:
=SMALL(IF($A$101:$A$1500<"",ROW($A$101:$A$1500)), ROW(A1))
and copy down.


Regards
Claus B.
--
Windows10
Office 2016

  #12   Report Post  
Old November 27th 20, 10:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Show value of first non contiguous data

Pe vineri, 27 noiembrie 2020, la 22:55:38 UTC+2
Claus B.
--
Windows10
Office 2016


It work btilliant !

What can I say ...
In a blink of eyes ... so smart

Many many many thanks Sir !


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
Function to return the last value in a contiguous set of data Deb Excel Worksheet Functions 3 May 13th 09 01:48 PM
Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column Sam via OfficeKB.com Excel Programming 8 November 5th 07 08:18 PM
charting non-contiguous data tom Charts and Charting in Excel 10 July 17th 07 05:04 PM
Sorting data in non-contiguous cells jonco Excel Programming 1 April 27th 06 09:59 PM
large non contiguous data set bhofsetz Charts and Charting in Excel 0 May 25th 05 05:30 PM


All times are GMT +1. The time now is 07:11 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017