Forum Discussion
Solved
Help with a lookup
I have a table with 6 columns and I need a formula that count the numbers of times that "End A" and "End B" shows for example row 3 and 4 match columns A (A3 = B205 and A4 = B205) and E (E3 = B260 a...
Hi Fernando,
Please try this formula in cell F2
=IF(COUNTIFS($A$2:A2,A2,$E$2:E2,E2)=1,"",COUNTIFS($A$2:A2,A2,$E$2:E2,E2))
And find it in the attached file.
Regards
Hi Fernando,
Please try this formula in cell F2
=IF(COUNTIFS($A$2:A2,A2,$E$2:E2,E2)=1,"",COUNTIFS($A$2:A2,A2,$E$2:E2,E2))
And find it in the attached file.
Regards
Thanks