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!