Hello!
I have two columns which I've converted into tables.
I need a formula to fill in a third column, on a second sheet, which will pull all the unique values from the two tables.
I've got this array formula going, but it only works for one of the columns.
=INDEX($D$11:$D$18,MATCH(0,COUNTIF($H$10:H10,$D$11:$D$18),0))
Thanks in advance!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks