Macros or Formula?

Closed
ORLATSTM
Posts
1
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 30, 2015
- Jul 30, 2015 at 12:49 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jul 30, 2015 at 10:56 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
512
Jul 30, 2015 at 10:56 AM
Hi Orlatstm,

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

Best regards,
Trowa
0