Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value HansVogelaar Hi Hans Problem solved. I deleted a row in my spreadsheet that looked unfamiliar and the formula did as requested. Thank you very much for your reply John why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value Solved
