Friends,
Although I have been a member for a while I rarely post. I usually just look for answers. But! I am stumped on this one! I have two columns; A:A has text and B:B has a numeric value. For each text there can only be one associated numeric value. There can however be duplicate text in column A:A, just cannot allow duplicate numeric value in column B:B. Can I prevent this with formulas or Data Validation? I THOUGHT I was savvy with excel. I stand corrected!