Counting populated cells (range) in one column, that fall between 2 (diff) values in another column

p45cal · #18 08-02-2024, 08:39 AM

You could try and test this incomprehensible formula in the single cell M7:

Code:

=BYROW(A7:A1130,LAMBDA(c,IF(LEN(TRIM(c))>0,SUMPRODUCT((SCAN("",A7:A1130,LAMBDA(a,b,IF(b="",a,b)))=c)*(LEN(TRIM(C7:C1130))>0)),"")))

See attached.
Named range not required, no Power Query query.

Edit: Added the equivalent named lambda formula in cell N7.
2024-08-02_170342.jpg

If you want to transfer this named lambda function to your own workbook, an easy way is to copy my worksheet to your workbook then immediately delete it from your workbook; the function should remain.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying column to another column with deleting date due to blank cells	Sportsmen	Excel	3	04-18-2023 06:16 AM
display a change in column cells counting the number of months	oscarlimerick	Excel	4	03-14-2022 12:22 AM
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column	nytvsh	Excel	2	12-06-2021 12:33 AM
Formula to check combinations of values in one column to find match from another column	kong1802	Excel	1	06-15-2018 05:26 AM
Shortcut to haven ascending values in row/column of cells	Straitsfan	Excel	1	08-09-2016 05:28 AM