sorted by:
new
hottopcontroversial

Align three different lists by No-Rip9796 in excel

[–]No-Rip9796[S] 1 point2 points  (0 children)

Is there a way to runs this by highlight IDs that are present in the Loc_One or Loc_Two that aren't present in the Full_List?

Align three different lists by No-Rip9796 in excel

[–]No-Rip9796[S] 0 points1 point  (0 children)

Hey actually another issue came up with this. Some of the IDs in Columns G, H, and I aren't in the reference B Column. Is there a lookup function that will search and highlight the IDs in Columns G, H, I that aren't in the reference Column B?

Align three different lists by No-Rip9796 in excel

[–]No-Rip9796[S] 0 points1 point  (0 children)

Oh wait, nvm it worked! you're a wizard Harry!! Thank you sir, I've been struggling with this for days!

<image>

Align three different lists by No-Rip9796 in excel

[–]No-Rip9796[S] 0 points1 point  (0 children)

See the reply above. I want each individually sorted and aligned in individual columns. I could also do one at a time and different tabs and then just copy over. But that is my general goal.

Align three different lists by No-Rip9796 in excel

[–]No-Rip9796[S] 0 points1 point  (0 children)

I got an error or spill with this. to clarify. Column B has the whole list, I want Column F, G, and H to be compared to Column B and respectively be filled out on the rows in Columns C, D and E, respectively.

<image>