Seqno check in excel

[louisjeorge75]

hi ,

i need some help on

in the below table i multiple id with 11 currency and seqno for each combination, what i need to check is to see if HKD is always in 1 and AUD is in 2 and so on for a unique id's. can someone help.

SEQNO ID CURRENCYCODE
0000001 11111111 HKD
0000002 11111111 AUD
0000003 11111111 CAD
0000004 11111111 CHF
0000005 11111111 CNY
0000006 11111111 EUR
0000007 11111111 GBP
0000008 11111111 JPY
0000009 11111111 NZD
0000010 11111111 SGD
0000011 11111111 USD
0000012 22222222 HKD
0000013 22222222 AUD
0000014 22222222 CAD
0000015 22222222 CHF
0000016 22222222 CNY
0000017 22222222 EUR
0000018 22222222 GBP
0000019 22222222 JPY
0000020 22222222 NZD
0000021 22222222 SGD
0000022 22222222 USD

 

[louisjeorge75]

any formula i can use to mark HKD as 1 in a column and AUD as 2 and so on so when i filter HKD i should see only 1