Computer Hope
Microsoft => Microsoft Windows => Windows XP => Topic started by: sanjeev on September 30, 2008, 07:22:20 AM
-
suppose if I have a name of different cities in column A, and in column B also I have a names of cities.
I want to find out how many cities in column B are already there in column a as well & how many are not.
for e.g. mumbai can be in both in a and in b column
-
welcome Sanjeev :)
Glad you made it!
Now wait for someone to answer this question, you can also check later :)
-
Hi
This site has other forums more suitable for this question.
Personally I think I could provide a DOS answer,
I just don't have the energy or time to waste with totally unsuitable tools.
To start with, you may need to convert the data to pure upper case (or pure lower case). It would take far to much effort to have the computer compensate for any spelling mistakes or variations in what gets a capital letter.
I suggest you use a spreadsheet.
I prefer Open Office, but Excel may also be up to it.
Just paste your multi-column table into the spreadsheet,
and so long as choose as column delimiters the Tabs, Spaces, whatever that have been used in the original document, they should appear in separate columns.
Simple spreadsheet tricks :-
1) Copy column A into empty column C
2) Copy column B and append below what has just gone into C
3) Select each column, one at a time, and sort that column
4) Select portions of A and slide down, leaving vertical gaps, so that each town is on the same row as in column C
5) Repeat "4" upon column B
6) Look at columns A and B - you should now see duplicate towns side by side.
Regards
Alan