Grab unique values from two columns and place it in a third column

[mike4777]

I am trying to grab all the data from column a and b and put it in c. Thanks!

 

[mike4777]

I don't want to count any value twice.

 

[Aladin Akyurek]

I don't want to count any value twice.

See your original thread...

 

[mike4777]

See your original thread...

You are right, I don't need the formula to get rid of duplicates. I am pulling column C to another sheet and can use the formula I received the other day for that (sorry I got lost in details). But I do need a formula to put the data from each column into column c while removing blanks.

 

[mike4777]

Never mind, I figured it out. I would be grateful if you could resolve my other post though about the repeating values in the formula you gave me last night.

thanks

 

[Aladin Akyurek]

Never mind, I figured it out. I would be grateful if you could resolve my other post though about the repeating values in the formula you gave me last night.

thanks

See https://www.mrexcel.com/forum/excel-questions/1054600-retrieving-multiple-cells-correlated-another-cell.html