San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
In Column A I have names, in Colum B I have it counting how many matching names on next page =COUNTIF(Sheet1!A1:C14,A1)
In column C, I would like it to give me text for the results I have, Example would be in C1 if B1 is a 1 then the text Signed Player appears, if B1 is a 0 the Free Agent appears, thx guys
In column C, I would like it to give me text for the results I have, Example would be in C1 if B1 is a 1 then the text Signed Player appears, if B1 is a 0 the Free Agent appears, thx guys