Maybe
=COUNTIFS($B$1:$B$19,B2,$A$1:$A$19,"<>"&A2)
Note: the formula can't tell how many ID, just tell have 'another' ID (value 1 or more)
Regards.
Maybe
=COUNTIFS($B$1:$B$19,B2,$A$1:$A$19,"<>"&A2)
Note: the formula can't tell how many ID, just tell have 'another' ID (value 1 or more)
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks