Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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!
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response