maldonadocj
Board Regular
- Joined
- Oct 19, 2004
- Messages
- 103
Hello,
I am trying to create a formula that will create a comprehensive listing of unique data points from two different sheets.
For example:
Sheet 1: "Apple" in Cell A1, "Pear" in Cell A2, "Banana" in Cell A3
Sheet 2: "Apple" in Cell B1, "Orange" in Cell B2, "Pineapple" in Cell B3
On Sheet 3:
The formula in Column A should do the following:
If "Pear" exists in Column A of Sheet1 and Sheet2, then note "Pear" as the output.
If "Pear" exists in Sheet 1 but does not exist in Sheet 2, then note "Pear" also in the output.
If "Pear" exists in Sheet 2 but does not exist in Sheet 1, then note "Pear"
also in the output.
I hope I was able to explain this clearly. Your help is greatly appreciated.
Thank you.
I am trying to create a formula that will create a comprehensive listing of unique data points from two different sheets.
For example:
Sheet 1: "Apple" in Cell A1, "Pear" in Cell A2, "Banana" in Cell A3
Sheet 2: "Apple" in Cell B1, "Orange" in Cell B2, "Pineapple" in Cell B3
On Sheet 3:
The formula in Column A should do the following:
If "Pear" exists in Column A of Sheet1 and Sheet2, then note "Pear" as the output.
If "Pear" exists in Sheet 1 but does not exist in Sheet 2, then note "Pear" also in the output.
If "Pear" exists in Sheet 2 but does not exist in Sheet 1, then note "Pear"
also in the output.
I hope I was able to explain this clearly. Your help is greatly appreciated.
Thank you.