I have two sheets that contain mostly identical names but a few names with no match on the other sheet. For example:  Sheet 1    1. Kumar 2. Rajiv 3. Ranjith 4. Supriya 5. Sanjay   Sheet 2    1. Kumar 2. Rajiv 3. Ranjith 4. Hari 5. Sanjay 6. Supriya   I need to identify Hari as not having a match on Sheet 1.  How can I identify such names that appear on Sheet 2 but not on Sheet 1?
124003
I'm not sure unique is the right term but what I'm looking for is if I have column A with values 1,2,3,4,5 and column B with 3,4,5,6,7 I want the result to display 1,2,6,7.
66472
Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it.  I have two worksheets in Excel.  Worksheet 1.  Column-A        Column-B Device Names    Total numbers Device A           19  Device B           81 Device C           12  Device D           21  etc.               etc.   Worksheet 2.  Column-A         Column-B Device Names   Total numbers Device D Device S Device Z Device S etc.   I need the formula which will look-up the Device names in Column-A/Worksheet 2 in ColumnA/Worksheet 1. If the device names in worksheet 2 and worksheet 1 match, the data in Column-B of worksheet-1 should be transferred to Column-B in worksheet-2.
57998
I know nothing about Excel, so the first thing I would like to do is to remove any duplicates from within the lists themselves.  But then I would also like any rows from list B that has a duplicate row in list A to be removed.  For example, if the email John@John.com is in list B and there is also a John@john.com in list A, I want to remove John@john.com from list B.
27039
I am trying to get a count of unique addresses from a list of a 1000 addresses in column A if they are in a specific primary week list in column B.  In this example, Monday has 4 addresses but only 2 on them are unique.
123543
I wonder if there is an easy way to check if two strings match by excluding certain characters in the strings. See example below.  I can easily write such a method by writing a regular expression to find the "wild card" characters, and replace them with a common character. Then compare the two strings str1 and str2. I am not looking for such implementations, but like to know whether there are any .Net framework classes that can take care of this. Seems like a common need, but I couldn't find any such method.  For example:  string str1 = "ABC-EFG";     string str2 = "ABC*EFG";   The two strings must be declared equal.  Thanks!
28744
I would like to compare two Excel spreadsheets  Both have the same columns, in the same order, but not the same rows.  I have a spreadsheet with 1,000 rows and 50 columns including a unique ID for each row and personal data (address, phone number, etc.).  I want to compare it with the same base extracted one year ago.  My objective is to know all changes (for example, someone who changed his address).  I tried with spreadsheet (as explained here: ) but it doesn't work because in my "new" file I have new rows, and I have some rows in the old file which are not in the new.  Spreadsheet compare with Excel line number. Is it possible to compare with the first column (Unique ID)?   Here is a very simplified example:    There are two sheets representing my two spreadsheets.  As you can see both have the same columns but:    There are rows that are on both sheets with no changes (all the row is the same)  There are rows that are on both sheets but there are changes (in orange on my example)  There are rows that are only in the December sheet (I don't need to identify these lines)  There are rows that are only in the January sheet (in orange on my example)    The orange color is exactly what I want, but in this example I can do it manually: comparing December and January. In the real spreadsheets I cannot do it manually as there are too many changes, data, lines, columns, etc. and I will do this monthly.   There is only one column which can never change: the column A.
24617
Given two histograms, how do we assess whether they are similar or not?  Is it sufficient to simply look at the two histograms? The simple one to one mapping has the problem that if a histogram is slightly different and slightly shifted then we'll not get the desired result.  Any suggestions?
117802
Given positive and negative values in column A of an Excel sheet, I want column B to list the positive values from column A, and column C to show the negative values, in the order in which they appear in column A.   However, I don't want any empty cells in columns B and C.   So, I do NOT want:     A     B     C ----------------  All   &gt;=0    &lt;0  100   100 -300        -300 -800        -800  900   900  700   700 -200        -200  900   900   But instead, I want:     A     B     C ----------------  All   &gt;=0    &lt;0  100   100  -300 -300   900  -800 -800   700  -200  900   900  700 -200  900
56516
I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A.   What's the quickest way to do this?
20200
I need a formula to use cell address and return the cell defined name, i.e.  =INDIRECT(ADDRESS(ROW(),COLUMN(),1,,"SHEET 001"))   I need this ADDRESS(ROW(),COLUMN() to refer to the current cell defined name i.e. "sales" and not $A$1
972
Is it possible to reference a cell in Google Sheets so that cell where it gets displayed also displays it using the same text and cell colour formatting?  =A1   Will only reference cell's value. But if that particular cell has red background and white text I'd like that to be copied as well.  I'm leaning toward existing formula solutions rather than scripts. If applicable of course.
59470
I am trying to remove the duplicates items from a big Excel sheet. I would like to remove all rows that have a duplicate code values (sample below)  Before:      Name     Code item_01  xxxx01 item_02  xxxx02 item_03  xxxx01 item_01  xxxx03 item_04  xxxx04   After:  Name     Code item_01  xxxx01 item_02  xxxx02 item_01  xxxx03 item_04  xxxx04   I have played with the "Remove Duplicates" features, but I can't get the result that I want.   Any help? Thanks
59428
How can I get the sheet name in a cell? (I have more than one sheet, I want to get the current on each sheet)
108008
I have several spreadsheets with information I need to consolidate, each with different (and sometimes overlapping) portions of the final data set I'm hoping to create. Typically, combining spreadsheets with similar data is easy to do by dumping all the data into one sheet and using Remove Duplicates. However, I want to make sure that the line items which are left represent the latest version of the duplicates.  I will be importing the following data from each spreadsheet:   A unique identifier field, (UID) which identifies the subject of the line item and will be used to spot duplicates between the input sheets. A status field, (STATUS) which will have information about the item called out in the unique identifier field. A date field, (DATE) which will contain the date the imported data was originally written.   What I need is for my output to contain only one line item for each UID, and have data from the STATUS field which matches the most recent DATE for that UID from the input sheets.  What is the easiest way to do this in Excel?
89240
How can I add another 2 values after matching the values from 2 columns in another file just like VLOOKUP?  Sample below. Value in column 6 &amp; 7 from file1, when matched with column 1 &amp; 2 from file2, will add column 9 &amp; 10 in file1 with the value of column 3 &amp; 4 from file2.  file1.txt  1 1 1 1 1 5 9 1  2 2 2 2 2 7 8 2  3 3 3 3 3 7 7 3  4 4 4 4 4 8 6 4   file2.txt  5 9 A B  8 6 E F  7 7 G H  7 8 C D   output.txt  1 1 1 1 1 5 9 1 A B  2 2 2 2 2 7 8 2 C D  3 3 3 3 3 7 7 3 G H  4 4 4 4 4 8 6 4 E F   Thanks,
10765
I'm currently entering authors an a paper and I came across this problem:    As you can see there are multiple names on one line, though outside the page. I would like to get them on two lines. At the moment I'm using the \name tag. I tried separating the lines the sentence by adding two backslashes, but it did not help. (I get "! Missing } inserted." error.) I tried replacing the \name tag by \author, but it did not work.   Example:  \documentclass{article}  \usepackage{spconf,amsmath,graphicx} \usepackage{amsmath}  \usepackage{algorithm}  \usepackage{algpseudocode}  \usepackage{color} \usepackage{cite}   \title{Title}    \name{Name1$^{1}$, Name2$^{3}$, name3$^{3}$ name4 $^{1,2}$, name5,$^{2}$ name6 $^{2}$, name7$^{3}$}   %  \maketitle  %   \begin{abstract}   I tried:   \name{Name1$^{1}$, Name2$^{3}$, name3$^{3}$ name4\\ $^{1,2}$, name5,$^{2}$ name6 $^{2}$, name7$^{3}$}   But I get an error.
86662
I read and tested quite a lot, but I still not able to come up with a solution for my problem.  The close solution I found is the second one proposed in article below:   I'm essentially after finding out how many values are unique in Column A while Column B correspond to a certain value.  Let's imagine the following spreadsheet  COL A      COL B abc        TRUE abc        TRUE bef        TRUE bef        FALSE hgf        TRUE swd        FALSE rth        FALSE kjh        TRUE   I'd like to come up with a formula to calculate (not showing) the # of unique values in A which contains TRUE in COL B. So given the example above, I should get 4.  Now, I was expecting the formula below to be in some way helpful  =SUMPRODUCT((A2:A100&lt;&gt;"")/COUNTIF(A2:A100,A2:A100))   once amended with a COUNTIFS, but it clearly doesn't work, and I don't understand why. Also I don't really understand the reason of the initial bit: A2:A100&lt;&gt;""