How to find a non-sequence match between rows? [closed]

asked 2013-08-30 14:27:15 +0100

snakeat3r gravatar image


I'm a newbie, no experience with excel or any other office tools. Sorry if I labeled the question in a wrong way

I need a function to find matches between two rows.

Lets say I have populated a column with each row containing numbers:

A1: 9 20 53 60 90 40
A2: 5 20 30 45 60 80
AN: ........

So for example - in B1 i write: 60 5 30 80
The function should return a match in A2


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 22:22:19.210710