Macros or Formula? [Closed]

Report
Posts
1
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 30, 2015
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
I have a report to run for work each week. Simply said, I obtain the raw data and need to sort and filter it based on a certain criteria. Then I need to match and label 1,2,3,4 in column "A" based on what is in that same row for column "BF".

For example, if Cell BF3 = X then A3 =1
if Cell BF4 = Y then A4 = 2

I don't know if a macro is needed or a formula. Thank you for all the help!

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Hi Orlatstm,

For that you can use a formula like this:
=IF(BF3="X",1,IF(BF3="Y",2,""))

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!