Search : in
By :

Find The Value of one column in another colum

Last answer on Jul 2, 2009 1:19:32 pm BST vnitnagpur, on Apr 20, 2009 8:41:04 am BST 
 Report this message to moderators

Hello,
I want to check what are the elements from a column that exists in columns(Previously containing rows) and what are the elements that are new to the column. what Excel formula i can use for that. Or is any shortcut method present for this.

Desc:
Column A contains 50 rows of element with heading NAME . Now In comes a new Set of NAMES containing 6 rows.
Now i want to know which all of these 6 new rows are present previously in Column A (NAME) and which all are new in the column B (NAMES).
Whichever element is new in column B(NAMES) copy those element into column A(NAME).

Configuration: Windows XP
Internet Explorer 8.0

Best answers for « Find The Value of one column in another colum » in :
Adding data from one column using another Show Adding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Introduction to MTU ShowIntroduction to MTU What is MTU Calculate the MTU Find the value of the MTU on Windows Changing the MTU on Windows Find the value of the MTU on Linux What is MTU The Maximum Transmission Unit (MTU) (maximum size of transfer...
What is your MAC address? ShowWhat is your MAC address? Windows Linux If you want to know what your MAC address is, this is an easy process. MAC stands for Media Access Control and the MAC address enables you to locate the network adapters address of your PC....
Download MagicScore ShowYou often look for a good software to publish scores, but it is difficult to find a good one like MagicScore. The software is powerful, magnificent and especially designed for professional musicians but it can also be used by loving music people....

1

 hggh, on Jul 2, 2009 1:19:32 pm BST
  • +9

WE ALSO NEED THAT

Reply to hggh