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
Post a Comment