Web Development

Ask something
Discussion Locked

Using Excel to filter out lists

0 helpful
5 replies

by junething 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by junething

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.

by shanghai sam

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;

This discussion is closed to new replies.