Forum Discussion
How to autofill multiple columns in excel based on more than one sheet?
I have developed this formula in Excel to record 1)whether a user name it taken through binary code of 1/0, 2) The name of the person the username is taken by. The sheets I am working with loo...
Detlef_Lewin Hello, Thank you for your help. I have some follow up questions. When I've tried this in B2, it doesn't record that this username is in use in sheet 2. Also the second line of code in C2 returns a #NAME?
Corrected formula for B2:
=COUNTIFS(Sheet1!$B$2:$B$10,A2)+COUNTIFS(Sheet1.5!$B$2:$B$10,A2)#NAME? error implies that your are working with an older version of Excel. What version do you use?