Help me filter from 1st table to 2nd table, step to step, thank you very much!
\1
Help me filter from 1st table to 2nd table, step to step, thank you very much!
\1
Last edited by huycuopbien123; 05-13-2014 at 07:42 AM.
You need a bit more explanation.....
Bernie Deitrick
Excel MVP 2000-2010
i mean how to arrange the "name" and "class" in the first table into the second table that fits to the "code"
Last edited by huycuopbien123; 05-13-2014 at 11:38 AM.
In B10
=VLOOKUP($A10,$A$1:$C$5,COLUMN(B$1),False)
and copy down and across. But your example does not have the same values, so some cells may be errors.
thank you man but i dont know why some values are different, this is the excercise the recruiter asked me in the interview and i couldnt resolve it
Last edited by huycuopbien123; 05-13-2014 at 12:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks