Bank Sheets

[andreimilea]

Hello , i have recently moved to a new bank and they use Excel instead of Access , with which i was familiar.So , maybe you can help me solve a problem.here it is :
i have a huge table with alphabetical ordered clients.since there are two persons who manage the clients , each client has a code, let's say some have 1 and some have 0, so two columns : one with the name and one with a code for every client. Secondly , i have a table with the clients processed in the last month , they all are found in the first table and i have to make a function that selects only the clients which have code 1 in table 1 . Assuming i can copy&paste the column in the second table into the first one , thus making it 3 columns in the first , can you tell me what function must i use to make such filtering ? thank you

[EdMac]

You have already posted this in the General section - please don't post duplicates as it wastes peoples time.