H
Hall
My table looks like this:
A 100
A 110
B 300
B 310
B 320
C 200
D 210
D 220
How would I identify the rows with B in the first column to be used in the
INDEX formula's first parameter?
=INDEX( [rows with B], 2, 2 )
giving me the value 310
Thanks!
A 100
A 110
B 300
B 310
B 320
C 200
D 210
D 220
How would I identify the rows with B in the first column to be used in the
INDEX formula's first parameter?
=INDEX( [rows with B], 2, 2 )
giving me the value 310
Thanks!