All
Bit of help required.
looking to enter a custom formula in data validation to do the following
the data entry has to start with "county" or "area"
any help would be appreciated
Barbara Excel
All
Bit of help required.
looking to enter a custom formula in data validation to do the following
the data entry has to start with "county" or "area"
any help would be appreciated
Barbara Excel
Try
=OR(LEFT(A2,6)="county",LEFT(A2,4)="area")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks