Hi im having an issue with Excel clearing the cell when trying to enter this formula.
=IF('Employee Data Years to Retire'!N1=1, 'Employee Data Years to Retire'!C1, "")
couldnt find anything related by googling. i tried getting some assistance from chatGPT it gave me these
=UNIQUE(FILTER('Employee Data Years to Retire'!$C:$C, 'Employee Data Years to Retire'!$N:$N=1))
=FILTER('Employee Data Years to Retire'!$C:$C, 'Employee Data Years to Retire'!$N:$N=1)
Anytime the second = in the formula is added the cell auto clears and nothing happens.
Ive tried turning off auto complete with no success. Any ideas? Thanks
Bookmarks