What's the easiest way to test, in a calculation, if A=B=C=D=E?

I feel like there might be something more compact than "A=B and A=C and A=D and A=E". Is there?

- RG>

What's the easiest way to test, in a calculation, if A=B=C=D=E?

I feel like there might be something more compact than "A=B and A=C and A=D and A=E". Is there?

- RG>

The use case is hard to generalize, but I want to verify that all instances of an item have the same category.

Category (itemA) = Category (itemB) = Category (itemC) etc.

This way I can say that N items are in Category (itemA) instead of having to list the categories for each item repeatedly.

Thanks for confirming.

- RG>

I'm afraid that's not the right answer.

What you mean is

Let (

testList = List ( B ; C, D ; E ) ;

ValueCount ( testList ) = ValueCount ( FilterValues ( testList ; A ) )

)

because that tests on complete lines, not just sub-strings.