Compare Worksheet Cells And Return Value
Jun 4, 2007
I'm trying to compare cells in two spreadsheets and return a value to another cell in one of those spreadsheets.
SPREADSHEET_1
Column A - NAME (Contains Data)
Column B - AREA (Contains Data)
Column C - PLAN (Contains Data)
SPREADSHEET_2
Column A - AREA (Contains Data)
Column B - NAME (EMPTY)
Column C - PLAN (EMPTY)
I need to compare Spreadsheet_1 - Column B to Spreadsheet_2 - Column A and then fill in the cells in spreadsheet_2 with the values from spreadsheet_1 column A and column C.
View 9 Replies
ADVERTISEMENT
Jul 17, 2013
I have used the merge facility to incoporate all the worksheets into one excel files. As they all have same heading, I have sorted the data, first by their account expiry time (oldest to newest) and then by manager (A-Z)
For example, system report generated on 15/03/2013, 28/03/2013, 03/04/2013, 15/05/2013, 28/05/2013 and so on and these are sheet names too. What I want is one worksheet called report with the same heading as my merged worksheets and return values where Column C in 28/03/2013 is compared to 15/03/2013 and if the employee ID matches than return the whole row of data for the report.
the next query would then be for finding employee ID in 03/04/2013 and comparing it with 28/03/2013 worksheet and returning the matched ID in report worksheet.
This is the layout of the report worksheet.
Display NameEmployee IDAccount StatusE-mailDepartmentManagerComment
15/03/2013 to 28/03/2013
28/03/2013 to 03/04/2013
03/04/2013 to 15/05/2013
15/05/2013 to 28/05/2013
so for the above report worksheet, if employee id matches the two compared worksheet (15/03/2013 to 28/03/2013) return all value (Display name, employee id, account status, email, department, manager, comment) from the 28/03/2013 and so on.
View 2 Replies
View Related
Nov 27, 2012
I'll quote the example straight away.
Col A Col B
A,S,F A,S
A,R,S A,R,S,T and so on.
There is no fixed pattern for the values, but they are separated by commas only. All i need is to compare col A and col B and return me the value in Col C like this,
Col C (col C is to know the removed value from comparison)
F (for line 1)
Col D (to find the letters that are added from comparison)
T (for line 2)
View 7 Replies
View Related
Apr 8, 2008
I have two columns that have similar information. I want to copy the unique information from one cell to a third, blank cell. In my case cells d2 and cell e2 are almost identical except cell d2 has addition information. I want to copy that information into cell f2. I have a feeling I am making this harder than it needs to be.
View 2 Replies
View Related
Jul 10, 2014
I have three cells - A1, B1, C1 and each contains a value of yes or no.
If more than two of the cells say "yes", I want the fourth cell (D1) to display "yes."
If less than two columns say "yes", I want the fourth cell (D1) to display "no" .
View 3 Replies
View Related
Feb 22, 2008
I have a if function that i am creating in excel 2000, and it has 8 variables. I am trying to put it in a macro as it is not working as a nested if function. Here is the current if function...
=IF(B2=C2,"OK",IF(B2=D2,"OK",IF(B2=E2,"OK",IF(B2=F2,"OK",IF(C2=0,"OK",IF(D2=0,"OK",IF(E2=0, "OK", IF(F2=0, "OK", "INCORRECT"))))))
the excel file is attached for further clarity
View 3 Replies
View Related
Jan 2, 2013
I have a workbook with tons of programming I need to achieve. Here is my work book so it can be viewed.
Right now on "Protocol" Sheet I want the cells with the "Protocol 1" field to look at Admin_Panel Sheet and find the row with the same text. Then take the text in cell A of the same row and copy it to the cell below the "Protocol 1" listed on the protocol sheet.
View 3 Replies
View Related
May 12, 2012
I have a dataset of shifts and want to compare each shift that needs to be filled to a list of requests for time off (vacation, etc).
For one cell the code is: =IF(ISERROR(SEARCH(B1, A1), 0,1)
Where A1 is the column of requests in comma delimited forme (ie: "AB,CD,EF").
Where B1 is the column containing the person assigned to shift 1 (ie: "AB")
In this case, would return a "1" as no error was returned, as AB was found in the list. Here "1" would represent a schedule conflict.
Without creating many cells for each shift- there are 20 shifts- can I create an array or string together this type of "SEARCH" function?
View 1 Replies
View Related
Jul 1, 2008
I have two excel sheets. The first sheet has a column with codes and another column with dates. There are more than one date for the same code. The second sheet has just one unique code. I would like to match the code on the second sheet with the code on the first sheet and return ALL the dates associated with that code to the second sheet - horizontally.
View 5 Replies
View Related
Jun 25, 2009
Hi, I desperately need help with a pivot-table and can't find anyone else who's ever had this problem...I have a very large healthcare data table which for simplicity I will describe as follows. In essence the first two columns respectively are (A) location and (B) month. Let's say the third column (C) is the number of cases of the disease kidpox treated in each health centre during that month. The fourth column (D) is the total number of cases of everything treated during that month in each clinic. The fifth column (E) is the proportion of cases of this disease over all consultations for each health centre and month, and the formula in E2 is .....
View 9 Replies
View Related
Jun 17, 2014
I am looking formula for below condition
1.Check Column A1 should not contain "$"
2.if Column A1 don't have "$" means then look Column A2 contains "$", if True means return string as "PASS"
View 1 Replies
View Related
Aug 4, 2006
I have two columns with the same data type (text) and I want to compare one column to another and if they match, return the data from another column.
For example: I have 2 columns of names on separate Excel files. One file contains name and phone numbers, while the other doesn't. I want to compare the names from file one with file two and if the names match, return the corresponding phone number in a new column.
I've tried VLOOKUP and IF statements, but I can't get it to come out.
View 4 Replies
View Related
Jun 1, 2007
I have a sheet with 2 big columns (3000 each). I want to search each element from the first column in the second column and put a message "Yes" if it is and "No" if it isn't, at the same position in the third column. How can i do that? I want to use the sheet for more than 3000 lines (about 5000). I attached an example.
View 9 Replies
View Related
Dec 5, 2008
What formula do I need for the cells in column F to show the name of the cheapest supplier ... for example the cheapest (£17,820) in line 2 is supplier A ????
View 5 Replies
View Related
Jan 19, 2010
if there is a way to find duplicate items in a list and return a value, if a duplicate exists.
Basically I have 19 buildings each with a separate bill of quantities. I'm looking to compare and compile a comprehensive list. So that duplicate items in different buildings can be compared side by side.
I have attached a sample of what I am trying to do.
View 11 Replies
View Related
Jul 4, 2013
I have 2 columns of usernames A and B, A has approx 700 usernames and B has about 80. In column C I have a list of names 1 for each username in column A. I want to compare the B with A and if there is a match return the value in C and place it in D.
View 3 Replies
View Related
Sep 25, 2013
I have two columns of values and I want to compare them and return differing values. So I named the ranges "A" and "B" so if your in B but not in A I want that value in C.
I started with a vlookup but that doesn't seem appropriate to the way I was using it.
=VLOOKUP(B, A, A, FALSE)
Is there a function better for this.
View 1 Replies
View Related
Nov 22, 2006
I have a list of two rows of over 20,000 items. I would like to know what data has been added to the second row from the first row and what has been removed.
View 4 Replies
View Related
Mar 17, 2007
I have two spreadsheets that I have to compare three columns in each to each other and find the difference between them. And I'm not sure how to do this.
I have attached a sample file to show what I'm looking at.
Basicly I need to know the differences between each spreadsheet based on zips. Each zip is assigned to a store and group and the "data" spreadsheet is the master. I need to compare the "system" spreadsheet and have it show me what is different based on each zip.
View 9 Replies
View Related
Nov 25, 2007
i have a list in column "a" in sheet 1 and a list in sheet 2 column "b" range from row 1 to 50
i would kike to get the data from sheet1 that is not in sheet 2 and copy it in to sheet 3
View 6 Replies
View Related
Aug 12, 2008
I have two columns, one with the target text (D:D) and one with text I want to compare it too (A:A). If the text in column (D:D) matches the one in (A:A), I want to return the value in (B:B). I attached a sample of the problem i'm dealing with.
View 5 Replies
View Related
Dec 19, 2013
Basically I have a string of dates, I want to get the max of the values that are before a specific date and return the header. Look at the file I provide for better understanding.
View 2 Replies
View Related
Mar 5, 2014
I must match column A and column B to return the column C In colA there are all my countries In column B there are all my countries code and countries I want get the colC where all my colB match than colA.
View 14 Replies
View Related
Nov 11, 2008
I've a long list of value with indicator which I need to compare with an entry after which it need to return a text indicator. I'm using IF and MATCH function.
Following is the code I use:
=(IF(MATCH(C1,$D$5:$D$29,0)<=5,$E$9,IF(MATCH(C1,$D$5:$D$29,0)<=10,$E$14,IF(MATCH(C1,$D$5:$D$29,0)<=1 5,$E$19,IF(MATCH(C1,$D$5:$D$29,0)<=20,$E$24,IF(MATCH(C1,$D$5:$D$29,0)<=25,"Not Found"))))))
I've attached an excel file with an sample. Btw, Is there anyway I can omit the length of IF & MATCH function by using other function.
View 4 Replies
View Related
Jul 18, 2013
for example i have two work books where i need to compare the times, such as i need to see where does 10:26 am lies and after comparing it on workbook2 we need to return the data in a,b,c blocks infornt of 10:26am, i have tried IF(AND()) but i was not able to rationalise it for huge and random data.
Workbook1:
7/13/2013 10:26
7/13/2013 10:58
7/13/2013 12:06
7/13/2013 12:17
7/13/2013 12:29
7/13/2013 12:29
7/13/2013 12:37
7/13/2013 13:21
7/13/2013 14:24
Workbook2:
9:58:27abcassigned
11:45:09abcreleased
11:49:00ghiassigned
15:14:40ghireleased
15:25:57mnoassigned
Outout should be:
7/13/2013 10:26 a bc
7/13/2013 10:58 a bc
7/13/2013 12:06g hi
7/13/2013 12:17g hi
7/13/2013 12:29g hi
7/13/2013 12:29g h i
7/13/2013 12:37ghi
7/13/2013 13:21ghi
7/13/2013 14:24ghi
View 2 Replies
View Related
Oct 26, 2012
how to return the highest value of repeated controls in column A.
when comparing the numbers repeated in columns "A"
will return the highest value in column "D"
control
plug
block
value
Formula
115
20
1012
28,9
31,2
this is the highest value of repeated controls in column A
[Code] .......
View 3 Replies
View Related
Apr 28, 2013
I have 2 sheet
1-"Check Employee Hours"
2-"Check Hours"
Below is what Check Employee Hours looks like
Below is what Check Hours looks like
I want to the user to press ebutton i.e Sunday and macro does the comparison.
Process
I would like macro to look at sheet "Check Hours" column "E" (cell E4) and compare it against the sheet "Check Employee Hours" column "E" (cell E7). If the hours matches i would like to say OK on sheet "Check Hours" cell E4, if it doesn't match then say CHECK.
View 9 Replies
View Related
Jan 24, 2008
I am trying to create my own budgeting tool. I have most of the tracker set up but I hit a stumbling block. I downloaded transations from Bank of America as a CSV file into excel. I want to categorize these transactions.
I created a keyword list that has words like "Starbucks" "Exxon" etc. Each of these keywords is then listed next to a category like "food" and "gas". So I want a formula that will compare the transactions to my keyword list and return the category type. Here is an example transaction:
CHECKCARD 0256 STARBUCKS USA 00029801 GAINESVILLE VA
I have a keyword "Starbucks" in f2 and "food" in g2.
View 9 Replies
View Related
Aug 7, 2008
I have two separate workbooks, each with a great deal of information, such as name, ssn, dates, statuses, etc. I would like to compare the SSN column for both workbooks, and when it finds a match (which there would be many) to copy the MOS cell from the same row to the other workbook. Here is my breakdown with names:
Workbook 1: Macros.xls
Workbook 2: MASS 162.xls
The SSN column is column C in both workbooks
When there is a match found between the SSN column in Macros.xls and the SSN column in MASS 162.xls, I need to copy the MOS cell (column E) from the MACROS.xls workbook to the MASS 162.xls workbook into the same row, but in column M, which is currently empty.
View 7 Replies
View Related
Mar 17, 2009
I have a spreadsheet with three years worth of data for a property I manage. Each column has cost data for the year and the specific department/cost for that year as the row value.
I have a column between the years that calculates the percent of gross revenue for the specific department/cost.
I would like to find (or create) a formula that will compare the percentage (or specific cost) for the three years within the specific row and if the increase year over year over year exceeds a trigger value it returns something (check me out/true/false) whatever.
The cost items for the property are in the hundreds so I'm trying to come up with a way to quickly see what specific cost items are going up (or down) more rapidly then what would be considered normal.
View 7 Replies
View Related
