General discussion

Locked

Using Excel to filter out lists

By junething ·
What I have:
A1: 1 B1:3
A2: 2 B2:5
A3: 3 B3:10
A4: 4
A5: 5
A6: 6
A7: 7

I have 2 colums in Excel, A1 to A7 with values 1-7. I have second colum B1 to B3 with 3, 5, 10

I would like the excel to use compare List B to List A, and tell if if the value in the List B exists in List A.

I have found "=or(exact(B1,A1:A7))" function, but it quite doesn't work for me.

Thanks advance

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Using Excel to filter out lists

by DKlippert In reply to Using Excel to filter out ...

Here's the information you need:

www.cpearson.com/excel/duplicat.htm

There are a number of ways to solve the problem.

Collapse -

Using Excel to filter out lists

by junething In reply to Using Excel to filter out ...

Thank you for the answer. Normally, I do not accept the answer using URL, but because it was very insightfull, I will accept it. Sorry to reply this late, but I wanted to make sure this works. Thanks again.

Collapse -

Using Excel to filter out lists

by Shanghai Sam In reply to Using Excel to filter out ...

I don't know Excel, so I would link to the Excel file from an Access database. I would then construct a query something like this
SELECT Left.*,Right.*
FROM ExcelFile As Left,ExcelFile AS Right
WHERE Left.A=Right.B;
I have a suspicion there is anicer query, but it's not coming to me at the moment. An alternative, not perhaps prettier, is
SELECT *
FROM ExcelFile AS Izquierda JOIN Excelfile AS Derecha ON Izquierda.A=Derecha.B;

Collapse -

Using Excel to filter out lists

by junething In reply to Using Excel to filter out ...

Thanks for the info, at this time, I'm not using ACCESS program to do this.

Collapse -

Using Excel to filter out lists

by junething In reply to Using Excel to filter out ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Software Forums