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

p45cal · #1 07-17-2024, 09:21 AM

Select the range you want to process A6:L1130, then in name box here, type the name (if the name doesn't already exist you'll see the cell address A6, which you overwrite):

2024-07-17_170309.jpg

2024-07-17_170543.jpg

Changing its extent is a bit different if it already exists. You can go into Name Manager on the Formulas tab of the ribbon:

2024-07-17_170752.jpg
and either delete it in the dialogue box, then go back into the sheet and recreate it as before,
or
you can edit it directly in the dialogue box:

2024-07-17_171543.jpg

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