You can add this into next column (row 2,3,4 etc): =SUMPRODUCT(--(B$2:E$2=B3:E3)) and pull down...
You can also by index match pull out row that matching criteria or you can higlight them as in eample.
You can add this into next column (row 2,3,4 etc): =SUMPRODUCT(--(B$2:E$2=B3:E3)) and pull down...
You can also by index match pull out row that matching criteria or you can higlight them as in eample.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks