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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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