| Home |
| Search |
| Today's Posts |
|
#11
November 27th 20, 09:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
November 27th 20, 10:02 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to return the last value in a contiguous set of data | Excel Worksheet Functions | |||
| Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column | Excel Programming | |||
| charting non-contiguous data | Charts and Charting in Excel | |||
| Sorting data in non-contiguous cells | Excel Programming | |||
| large non contiguous data set | Charts and Charting in Excel | |||
Linear Mode
