R
Rashid.adam
I have a spreadsheet that contains 3 columns
Column A is called Deal Number
and contains:
A1:1
A2:2
A3:1
A4:3
A5:1
Column B is called DND
B1:a
B2:a
B3:b
B4:a
B5:c
Column C is called Alert
What i want is to put the word "alert" if column A appears more tha
once and column B is the last letter of the range.
For example for the above entry, it should only "alert" C5
Hope that makes sense.
Many Thanks for all your help.
Kind Regards,
Rashi
Column A is called Deal Number
and contains:
A1:1
A2:2
A3:1
A4:3
A5:1
Column B is called DND
B1:a
B2:a
B3:b
B4:a
B5:c
Column C is called Alert
What i want is to put the word "alert" if column A appears more tha
once and column B is the last letter of the range.
For example for the above entry, it should only "alert" C5
Hope that makes sense.
Many Thanks for all your help.
Kind Regards,
Rashi