Hi,
I have the following formula:
(pulled down across the whole column)
It returns the list of numerical values as follows
0081-0074
0081-10056
....
The Source tab gets updated dynamically so the actual list is always changing as well.
Is it possible to exclude 2 cases automatically so that they aren't shown? I'd like to exclude specifically 013-9012 and 013-9013
I have the following formula:
Excel Formula:
=IFERROR(INDEX('Seizure diary'!$E$13:$E$15000,MATCH(0,INDEX(COUNTIF($C$1:C1,'Source'!$E$13:$E$15000),0,0),0)),"")
It returns the list of numerical values as follows
0081-0074
0081-10056
....
The Source tab gets updated dynamically so the actual list is always changing as well.
Is it possible to exclude 2 cases automatically so that they aren't shown? I'd like to exclude specifically 013-9012 and 013-9013
Last edited: