Hi All,
Struggling to get a formula to work:
Overview
Multiple Personnel Records need to be spread across various action groups by Surname Initial letter
A to E
F to J
K to O
P to T
U to Z
I have tried in my sampling
=IF(OR(LEFT(CELL,1)={"A","B","C","D","E"}),"A to E","ERROR")
But when run ALL results return the True (A to E) value
I'm sure it's something simple but it have me stumped.
Thanks in advance
Paul
That formula seems to work just fine for me, though it's not very dynamic due to the hard-coding of both the conditions "A,B,C,D,E " and the outcome if true "A-E".
In the attached file I used you formula as you described, but I also included another way to do what I believe you need with the help of a lookup table.
Please come back here if not clear of I missed the point completely.
Thanks Riny,
I had failed to make it an array formula {} so that was the issue; but much preffered your lookup as that will allow me to go over volumes and far easier to change if required.
Thanks again
FYI, that formula did not require array entry since the criteria involved used an array constant.
