G
Guest
hi all,
i have a simple questions to ask:
I have column A & column B.
In order to make it for users to fill in column B first, I need this
forumla, =ISTEXT(B1) in column A right? So that users cannot enter data in
columnA first. However, I have another forumla in columnA, =COUNTIF(A:A,A1)=1
to help me check for repeated data.
Therefore, =ISTEXT(B1) cannot be placed inside columnA.
So, I would like to ask, if there others way? (I dont wish to create another
column for it).
Also, =COUNTIF(A:A,A1)=1 and =ISTEXT(B1) cannot be combined togther as one?
thanks.
i have a simple questions to ask:
I have column A & column B.
In order to make it for users to fill in column B first, I need this
forumla, =ISTEXT(B1) in column A right? So that users cannot enter data in
columnA first. However, I have another forumla in columnA, =COUNTIF(A:A,A1)=1
to help me check for repeated data.
Therefore, =ISTEXT(B1) cannot be placed inside columnA.
So, I would like to ask, if there others way? (I dont wish to create another
column for it).
Also, =COUNTIF(A:A,A1)=1 and =ISTEXT(B1) cannot be combined togther as one?
thanks.