excel - Sort 2 Columns + Adj Column by matching Numbers -


In column D-Q, there is my long list of ID numbers in column C with important information

I need to sort with the matching information in Colonel DQ, according to the specific set of ID numbers in column B:

I have this:

  BCDE . 123 234 Male 12 234 345 Female 13 345 555 Male 12 444 123 Male 11 I need this:  
  BCDE . 123 123 male 11 234 234 male 12 345 345 female 13 444 N / AN / AN / A   

Essentially, information about C (and adjacent information) to match me with B Should get sorted in ID numbers in B The file is too big and I need to just drag / sort by a specific group of ID numbers.

Thank you!

EDIT: I have suggested that try to use the following in a new column. However, I get #n / a and #ref error

  = index (D: Q, match (B: B, C: C, 0) error: #N / A and #Ref!    

You index (array, match) You can get all the match data from the CQ using the match () on B and C.

Comments

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

ios - Replace text in UITextView run slowly -