Leorand
New Member
- Joined
- Nov 25, 2022
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hello Masters,
I would like to ask about data validation like title above, let say I want to make data validation formula using combined count if to prevent duplicated data in one sheet and for the source I set it to different workbooks,
The formula is like this :
=COUNTIF('[Workbook2.xlsx]Sheet1'!$A$1:$A$1000,A1)+COUNTIF($A$1:$A$1000,A1)=1
but i got error message while try to apply those formulas.
I had done search on google how to solve this case, but it just not helping at all.
Can you help me with this problems?
Any help will be appreciated. Thank you.
I would like to ask about data validation like title above, let say I want to make data validation formula using combined count if to prevent duplicated data in one sheet and for the source I set it to different workbooks,
The formula is like this :
=COUNTIF('[Workbook2.xlsx]Sheet1'!$A$1:$A$1000,A1)+COUNTIF($A$1:$A$1000,A1)=1
but i got error message while try to apply those formulas.
I had done search on google how to solve this case, but it just not helping at all.
Can you help me with this problems?
Any help will be appreciated. Thank you.