Please assist. I am looking for a formula that would compare data in column A to data in column B.
If data cannot be found in column B, populate column C with unique data from column A.
Please assist. I am looking for a formula that would compare data in column A to data in column B.
If data cannot be found in column B, populate column C with unique data from column A.
Maybe:
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.Please Login or Register to view this content.
Drag down
Quang PT
Sometimes in a few cases. When you use array formulas, you can use INDEX before ARRAY CALCULATE and your fomulas will become NORMAL FORMULAS:
Formula:Please Login or Register to view this content.
Enter
Also try this one in "C2"
Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thank you for your assistance. This was very helpful.
Thank you. This was just what I was looking for.
Thank you for your help. This was of great assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks