May 15 2018
09:27 AM
- last edited on
Jul 31 2018
08:08 AM
by
TechCommunityAP
May 15 2018
09:27 AM
- last edited on
Jul 31 2018
08:08 AM
by
TechCommunityAP
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 and E4 = B260) so the formula in row 3 it will show as blank but in row 4 it will show count 2 of B205 & B260. The problem is when has more than 2 equal the formula have to look up without entering any information if up contain the same information.
May 15 2018 12:34 PM
If I am correct, the vlookup function only allows you to check for one condition. You may want to look into using the sumifs function as you can use multiple conditions to work with and then use the count function within it too. It also has many other advantages than vlookup cannot do. Hope it helps!
May 15 2018 12:47 PM
SolutionHi 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
May 15 2018 12:47 PM
SolutionHi 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