Remove one item from a named range (google sheets)

[yomarcos]

Hi everyone,

Is there a way to remove a specific item from a Named range without creating a new one?
For example, I have a named range called 'Builders' in A1:A4 with Peter, John, Mark, Charles. Peter is the supervisor.
I have a formula where I need to use all of them so I use 'Builders' and I have another formula where I need all of them except for the supervisor (Peter).

Is that doable?

Thank you!!

 

[Muhammad_Usman]

Hi everyone,

Is there a way to remove a specific item from a Named range without creating a new one?
For example, I have a named range called 'Builders' in A1:A4 with Peter, John, Mark, Charles. Peter is the supervisor.
I have a formula where I need to use all of them so I use 'Builders' and I have another formula where I need all of them except for the supervisor (Peter).

Is that doable?

Thank you!!

Hey yomarcos!

You can use two name ranges one with four name and other with three name. In this way you can use your name range according to your formula.
Hope it will work.

Like below in example.

Book1.xlsm
	A	B	C
1	1
2	2		15
3	3		14
4	4
5	5
6
Sheet1

Cell Formulas
Range	Formula
C2	C2	=SUM(group1)
C3	C3	=SUM(group2)

Named Ranges
Name	Refers To	Cells
group1	=Sheet1!$A$1:$A$5	C2
group2	=Sheet1!$A$2:$A$5	C2:C3

 

[yomarcos]

Hey yomarcos!

You can use two name ranges one with four name and other with three name. In this way you can use your name range according to your formula.
Hope it will work.

Like below in example.

Book1.xlsm
	A	B	C
1	1
2	2		15
3	3		14
4	4
5	5
6
Sheet1

Cell Formulas
Range	Formula
C2	C2	=SUM(group1)
C3	C3	=SUM(group2)

Named Ranges
Name	Refers To	Cells
group1	=Sheet1!$A$1:$A$5	C2
group2	=Sheet1!$A$2:$A$5	C2:C3

Thank you muhammad_usman. That's what I was trying to avoid. I guess I have no choice.