Hi,
How can I find rows that only match 2 columns among multiple columns with same values?
I need to find rows that have same values in 'layer' and 'left(distance)' columns and make another table consisting only these values.
Hi,
How can I find rows that only match 2 columns among multiple columns with same values?
I need to find rows that have same values in 'layer' and 'left(distance)' columns and make another table consisting only these values.
for your first one in J3, use this array formula...
=INDEX($A$2:$A$30,MATCH(1,(L3=$C$2:$C$30)*(M3=$D$2:$D$30),0))
Activate it by pressing ctrl+shift+enter at the same time so the {} appear on either end of it, you cannot put them in your self as it will not function.
for the other columns just change the $A$2:$A$30 to B for the area, E for path, F for UFID, G for left max and H for left dista.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
if you need help with activating an array, go to this link and post #17 where I put in three PDFs to show how to activate it...
https://www.excelforum.com/excel-gen...r-sheet-2.html
after giving it a little thought, once you've used that formula in J3, it would be easier for you to use these vlookup formulas in K, N, O, P and Q as it isn't an array formula. Because your sheet showed individual UFID numbers.
in K3 =VLOOKUP(J3,$A$2:$B$30,2,FALSE)
then in N3 and dragged right ...
=VLOOKUP($J3,$A$2:E$30,COLUMN(E$1),FALSE)
so the only array you would need is the first one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks