Menu
I read a similar question but, was not exactly what I needed and was over my head.
I have two columns each with a different number of rows. Each column has a single first name in each row. How can I compare the first column to the second column. Removing the names in the first column from the second and create a third column with the result?
I am BRAND new at this and need very verbose example. Thank you!
remove | keep | result
---------------------------
jimbo | griffin | griffin
james | jim | jim
peter | jimbo | sanford
fred | fred |
| sanford |
None of the rows are in any particular order...
Also, the remove column could be in the center and keep column first, matters not to me..
Thanks so much for helping me learn this!!
532
Control + – (hold the control key and press the minus key) to delete the selected cells/rows.
On the Format tab, in the Current Selection group, click Format Selection. In the Axis Options category, do one of the following: For categories, select the Categories in reverse order check box. For values, select the Values in reverse order check box.
Assuming your data is in columns A and B. Paste this formula in column C and fill down:
=IF(ISERROR(MATCH(B1,A:A,0)),B1,"")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
