Log In
Register
Home
January 24, 2023
Offline
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
See Answer
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
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.
Answers Post
January 24, 2023
Offline
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
1 Guest(s)
