• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match Problem

Kaiser

Kaiser

Member
I am trying to work this formula but not working. I am trying to work this formula in Column B B. In Column B , it will cross check the first 7 digits of the Card No given in Column A along with the Bin No provided in Column C and it will reflect with the name as given with the Product in Column D. For example, if the card no is 4902630588902345 then in Column B it will say it is a TQ Card. I hope I could explain the problem. I have already tried with the formula but not working at all. Thanking you.

Kaiser
 

Attachments

Somendra Misra said:
Welcome back anytime @Kaiser

Regards,
Click to expand...

Dear Somendra, once again I am giving a trouble. I am attaching an Excel sheet which will describe the problem. But still if there is any queries please do mail. Please do let me know how shall I make this macro (if needed) step by step brother. Two Tab in one sheet. One is the main and the other is the example. This is a regular work, so the Card No, Country and the Amount will always keep on changing.Thanks a lot.

Take care..
 

Attachments

Dear Satish once again I am giving a trouble brother. I am attaching an Excel sheet which will describe the problem. But still if there is any queries please do mail. Please do let me know how shall I make this macro (if needed) step by step brother. Two Tab in one sheet. One is the main and the other is the example. This is a regular work, so the Card No, Country and the Amount will always keep on changing.Thanks a lot.

Take care..
 

Attachments

Hi Kaiser,

There no data available for all the card number in Column 'F' and 'G'

Should it show 'How Many Times the same card used' for duplicate card numbers also
 
You must log in or register to reply here.
Back
Top