IF & COUNTIFS formula when dealing with names
Hi! I deleted rows which contained formulas and saved (i know i shouldn't have) and I tried getting it back, but can't figure out what the formula should be. It keeps saying #unparseable.
If a name is unique, they were given a number and if the name was repeated, it was supposed to be blank. This is how it should look:
When Megan repeats, NameID column should be blank.
Instead, it's showing this:
It looks like the formula was
=IF(COUNTIFS(#REF:Name@row, Name@row) = 1, COUNTIFS(#REF:Name@row, OR(ISBLANK(@cell), NOT(ISBLANK((@cell))))))
I tried removing where the #REF is in the formula, and it shows #1 for everyone, where it should be Megan 1, William 2, Armine 3, etc.
I'm hoping someone can help me fix my mess.
Help Article Resources
Check out the Formula Handbook template!