pairing data

May I know how to check whether the Current Pairs match with the Ideal Pairs by using excel functions? For example: The Current Pair of 1&8 does not match with the Ideal Pair of 1&14 and 1&29. It is possible to create a new column that shows 1 for matching and 0 for not matching? As I would...

Hi all, Firstly apologies for the vague title, I had no idea what to call it. My problem: I have two sets of multiple drop down menus (data validation lists) (let's say in column A and B), and I want to present the information which repeats the values in column A for every value in column B...

Hi, I have a large data that I exported in excel that include debit and credit in a column. I would like to find an easier way to pair the debit and credit to offset each other by a formula and easily find the variance. So the column would look something like this. Column A 250 400 350 -250...

Hi everyone, I have data that looks like this: <tbody> Location Value Name 1 1 Ann 4 2 Pete 3 3 Sylvia 3 2 Bob 4 3 Pete 2 1 Jack 4 3 Bob 3 5 Bob 1 2 Ann </tbody> I would want to pair data by criteria of column 1 and 3. So that it will look something like this: <tbody>...