Hi
i think this is an easy one, but not so easy for me.
is it possible to count a value in each column per row of the range , and then move on to the next row looking for the same?
for example:
so we have three columns wide and 5 rows deep. 123 appears in 3 of the rows (what i want to find) although it appears within the entire range a total of 4 times.
TIA!
tx
i think this is an easy one, but not so easy for me.
is it possible to count a value in each column per row of the range , and then move on to the next row looking for the same?
for example:
Code:
target number: 123
123 456 345 <-- 123 shows here
123 445 271 <-- 123 shows here
445 445 255
636 636 300
300 123 123 <-- 123 shows here
so we have three columns wide and 5 rows deep. 123 appears in 3 of the rows (what i want to find) although it appears within the entire range a total of 4 times.
TIA!
tx