jevi
Active Member
- Joined
- Apr 13, 2010
- Messages
- 339
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have the first table when I have 8 column and different names in it. Then I have table 2 where I have a list of names (it has more than table 1 and some might not be in table 1, but the one that are in table 1 are in table 2).
I would like a formula to do the countif for each name based on the match with the name.
Example Name: Jevi in only in column 1 so I count it one time on the row of table 2 where is Jevi.
Thank you so much,
I have the first table when I have 8 column and different names in it. Then I have table 2 where I have a list of names (it has more than table 1 and some might not be in table 1, but the one that are in table 1 are in table 2).
I would like a formula to do the countif for each name based on the match with the name.
Example Name: Jevi in only in column 1 so I count it one time on the row of table 2 where is Jevi.
Thank you so much,