Compare The Data From And Display The Asnwer
Oct 24, 2007
I've got a worksheet with 3 columns that I want to compare the data from and display the asnwer if theses conditions are not met.
Here is an example: (Row 1 are Column Headings)
If B2="No Match" then display "10k", If C2="No Match" then display "MC28U" if both B2 & C2 = "No Match", then "UBR Not Assigned"
A B C D
1 NODEMC28U 10K EXPECTED RESULTS
2 AA01 NO MATCH NO MATCH NOT ASSIGNED
3 AA02 NO MATCH DSD0 10K
4 AA03 DS0 NO MATCH MC28U
View 2 Replies
ADVERTISEMENT
May 1, 2009
I have a Workbook that contains 2 sheets. One of them has a list of customer codes in one column, product codes in the next and product description in the last. The second sheet has a list of customers with their respective codes next to the names. I have a buton that when pressed asks to select a customer code from the second spreadsheet. After the selection is made a new sheet is created and that code is displayed there. This is as far as i got.
What i would like to do next is loop through the 1st sheet looking for the customer code that has been selected and in the newly created sheet display the product code and description that is next to that particulare customer in the first sheet. I'm sorry if my description is a bit fuzzy im just very tired. I will atach the spreadsheed with the vba code tha i have so far. Thnak you in advance to anyone that would be willing to help.
View 3 Replies
View Related
Aug 9, 2007
I have a spreadsheet with three sheets („Data”, „20” and „30”). On the Data sheet I have only two rows, and I do not work on this sheet. I work with the sheets 20 and 30. On the sheet 20 I need to sum up the amount of column H. But my problem is that the count of this column (the rows or cells) allways change. Sometimes there are 554 the next day 663 and so on. So I need the macro to sum up the amount of column H two cells under the last cell. I need exactly the same in the sheet 30, but the only difference is that in the sheet 30 the amounts are in the G column (not in H). Finally I need to compare the two summed up amounts (sheet 20 and 30) and they must be equal. So what I would need as macro is that when I run it, it sums up the amounts in both sheets and then in the Data sheet (in the 5th row, cell A) displays the summed up amount and (in cell B) displays OK if the two summed up amounts are equal, or just dislpays ERROR if the summed up amounts are not equal.
View 13 Replies
View Related
Feb 14, 2008
1. Got 2 lists in 2 sheets, those I want to compare and all the diffrences in all columns, I want to display in the third sheet.
2. The lists are the same structure.
3.Blad1 or Sheet1 is the list that is the latest.
4.Blad2 or Sheet2 is the list from yesterday.
So i want to compare newest with yesterday and all the diffs come up in the third.
So if there is a change in column A to W new planning date or planning status, or a new added row I want these to turn up in blad3 / sheet3. Can´t get my excelfiles to fit the maxupload criteria. Anyone got any idea on how to do this easy? Would like to do it macro wise due to I do couple of macros before this step.
View 2 Replies
View Related
May 7, 2008
I have two sheets in excel,Sheet1(worksheet) and Sheet2(worksheet).In Sheet1 I have certain numbers. In sheet2 I have some numbers which also include the numbers in sheet1.
Now I need to generate in sheet3 which has numbers which are in Sheet2 but not in Sheet1 with delimiters ( ; ) in between in one line. (EG: In Sheet1 I have say nos 1 to 10. In Sheet2 I have nos say 3,5,8 . In sheet3 there should be 1,2,4,6,7,9) Can you pls help me by providing code for this.
View 4 Replies
View Related
Jan 7, 2009
I would like to have a dialog box "popup" if the value of two cells do NOT equal.
cell C11 has net sales values for the day, including cash, checks, and credit cards. After sub total of these values, I subtract any charges(voids) and get a total(c11). I enter a sales(c12), tax(c13), no tax(C14), misc. amounts(C15 & C16) ,reductions(c21) and put the total in Cell C22 with the formula =Sum(c12:c16)-c21). Because I do not want the formula overwritten, I protect the sheet including the amounts in cell c11 and c22. If they do "Not" match I would like a dialog box to appear so the error can be corrected.
View 5 Replies
View Related
Jul 24, 2009
I have searched some of the other forums but have not found anything specifically related to what I'm trying to do.. An example is attached. Basically just want to compare data between two different lists and then in two additional columns (Differences & Similarities) display that corresponding data.
View 3 Replies
View Related
Sep 10, 2012
I need a formula that will look at cell A1 and compare it against column B, if it finds it, show that value, if not, show "not found".
View 6 Replies
View Related
Apr 29, 2007
I would like to create a formula that compares a number in one cell to the dates I have displayed in two different cells. If true, then I want it to display the Currency value from another cell.
______A________B________C________D_____
|1| Due Date | Amount | 1/01/2007 | 1/15/2007
|2|___4________$98_______________________
A2 is the DAY it's due
B2 is the AMT that is due
I can create an IF...THEN statement where if A2 is >= C1 BUT less than D1 then the value is B2, BUT it only works if I change A2 to an actual date which means i have to change it every month...which would not help with forecasting future transactions. So in the example above, the value would be in C2 and not D2.
View 9 Replies
View Related
Nov 23, 2013
I have to compare data in first sheet of two excel files and have to create a log file to display the logs of comparisons.
First workbook is placed in folder C:/Input/ with name as Input.xlsx and second workbook is placed in folder C:/Output/ with name as Output.xlsx.
I have to compare below cells between input.xlsx and output.xlsx.
Cell "B1" in input.xlsx , has to match with Cell "C4" in output.xlsxCell "B2" in input.xlsx , has to match with Cell "C5" in output.xlsx.
Cell "B3" in input.xlsx , has to match with Cell "C6" in output.xlsxCell "B4" in input.xlsx , has to match with Cell "C7" in output.xlsx.
Cell "B5" in input.xlsx , has to match with Cell "C10" in output.xlsxCell "B6" in input.xlsx , has to match with Cell "C9" in output.xlsx.
[Code] .......
After Comparing, I would like to log all the comparision in a log.csv, if cell "B1" in input file is matching "C4" in output file , say matching and color it green. If not matching, provide mismatch values from both cells and color it in red.
How we can compare 100's of excel files placed in Input and output folder and create one log file as stated above.
View 1 Replies
View Related
Oct 2, 2013
I have one excel 2010 workbook with 5 work sheets, each work sheet contains a list with first/last name(one column) and the company name, some have a 3rd column with their email address in each sheet represents each year starting at 2008 thru to 2013 i have to find out if the people that attended an event in 2008 also attended it in 2009/10/11/12/13 and if they didnt, put their name and company name onto a blank worksheet within the same workbook without using a macro, how can i do this?
View 2 Replies
View Related
Jun 18, 2014
vba in excel 2013 pivot table that updates from an online CRM rows are a to h and it can be any number of rows. What I am trying to do is track progress. In column f values indicate probability for success 10 25 45 90, which can go up or down. The pivot table is refreshed to get the latest values from CRM. the update is handled by a connection to the crm not in the vba.
So far I been researching methods to conditionally format values that went up, down or remained the same since the last refresh with up down and across arrows. I have managed to piece together what I think should work but alas it is not. So I have come to you internet.
My code first clears any formatting and goes down the column avoiding null or empty cells, comparing the values in column f to values in column j.
I have 3 conditions greater than, less than or equal to, and would like add an icon for each based on the result of the comparison.
Finally when it finishes the column the code copies the current values in the pivot table column f to column j outside the pivot table which i hope to be able to hide once the cf works. The code is below
[Code] .....
View 1 Replies
View Related
Oct 5, 2009
I have tried nested ifs and vlookup to compare two sets of data and change the first set of data if it is than the first. But leave it alone if it either is the same or does not exist in the new set of data. It sometimes seems to work but i find it is not consistant. It looks simple but i think i am missing something.
if column A has identifiers and column B has results then it should work if the identifiers in column C are found in column A and it looks to see if column B and D are the same, then change B if different but leave it if either it is the same or not there.
A
code1
B
36
C
code1
D 33
View 9 Replies
View Related
Mar 13, 2007
I have data in 2 workbooks. Book1 - Sheet1 - Col A and Book2 - Sheet2 - Col A. I want to compare Book2 with Book1 and list all values in Book2 that do not find a match in Book1. I want to run a macro for this
View 7 Replies
View Related
Jun 9, 2007
I want to import data with a web-querie. The data consists of numbers in a column (14 cells).
I want to poll the info in the table in the webquerie every 15 minutes to see if the info in the table is changed. Therefore I refresh the info every 15 minutes, and when the info is changed, than the data must be put in a new sheet in a column and the columntitle must be the date and time that the info is put into the column. Can this be done in vba? I suppose that to compare the info of the new poll with the info of the previous polling the previous info must be put in a "compare" table.
View 4 Replies
View Related
Apr 22, 2014
Pivot Chart. I would like to set up something to where a user can click on an individual value on a pivot chart (currently a line chart set up with 4 data series) and somehow display some underlying data. I have a lot of information stored in a data worksheet that I can't display all at once, but if a user sees a questionable data point, he/she can click and learn more about it from source data, or even a new query of the data worksheet.
I am using Excel 2010
View 2 Replies
View Related
Mar 16, 2007
I would need Excel to compare rows between two worksheets (A & B), and if there are any:
(1) new rows in A, to copy across the new rows onto B.
(2) updated rows in A, to copy the updated data onto B replacing existing B values.
This in itself would be simple. Only thing is, worksheet B would be subtotaled and sorted by the subtotal and this is something I wonder if Excel can cope with. BTW I wouldnt mind it if subtotals in B has to be undone before the data gets updated, so long if Macro automates it for me. Is this possible or am I asking for too much? A representative excel file is as attached.
View 5 Replies
View Related
May 12, 2012
I have two separate worksheets:
I'm trying to find a formula that looks at Column A on both sheets (each client is allocated a unique number) and if they match enter in column D of the referral sheet the month they were seen but only if it is a 1st contact (appt type on column D of contact sheet)
Referral
A
B
C
[Code]....
way to do the calculation using Excel 2003
View 9 Replies
View Related
Mar 10, 2009
Need in displaying data by user input criteria, mulitple rows of display also need to display to blank out when no criteria is input. In example spreadsheet the criteria cell is B6 in "Results" page and needs to pull in data from the "Database" page.
View 3 Replies
View Related
Jun 9, 2013
There are 2 scenarios which need to be achieve as below:
1) I have bunch of raw data (consists of backup data results, normally 300K++ rows) every months. So now i want to compare between each rows(that the column with backup status failed), whereby it will search in 300k++ rows if there is any rerun of the failed backup (based on some condition i.e. same client server nameackup policy & most important the date must between backup windows (which need also some logic checking here i.e compare what will be the next day backup schedule time ). Once its meet this criteria, it will update the last or on 1 of the column of the source same row (i.e. =='Backup Success')
2)Once the above achieve, need also to run another checking (almost similar like above), but difference is the date checking, need to be more specific, i.e. i will add another columns (on each rows) to specify the specific date ime which the backup should Not be exceeds, and the the values also will be the to to update [it will update the last or on 1 of the column of the source same row (i.e. =='Backup Success')]
View 4 Replies
View Related
Feb 21, 2014
Basically I have two sets of data. One will be new each week. I'd like to use the non-changing data as a base to compare new data to. The formula would need to match multiple values, including a 'time between', and then return whether a minimum rate has been met.
SampleRateExamine.xlsx‎
View 3 Replies
View Related
Jun 13, 2014
Please refer to attached sheet. i have 2 sets of data. I need to compare the data and highlight.
First compare each cell in column W with each cell column L.
If match is found then compare the corresponding cell in column U with the value in column N.
Example:
W1 matches with L1 and U1 matches with N1 so do not highlight.
W2 matches with L7 and U2 does not match with N7 and hence highlight.
If value is different then highlight the cell in column U.
View 4 Replies
View Related
Jul 23, 2011
I'm doing an audit where I need to compare data between two spreadsheets that are housed on the same worksheet. The data I'm trying to compare is the ssn#. I'm expecting duplicates, I'm trying to find ssn#'s that do not match up with another. In other words, if one spreadsheet has 92ssn#s, the other has 79, I want to be able to identify those that do not have a matching ssn# from one spreadsheet to the other.
Both spreadsheets have the following columns:
Column A Column B Column C
SSN Last Name First Name
The tab on the bottom of sheet 1 is titled "CX Data", the tab on the bottom of sheet two is titled, "BCBS of AL Data"
in creating a VLOOKUP formula that will meet my needs?
View 7 Replies
View Related
Dec 7, 2013
I'm looking for a formula which compare total sales or customer count by date and It should automatically get updated daily.
For an example In my historic Data I have details of the sales from 1st to 31st of December 2012. Also I'm updating the present details day by day. Is it possible to compare the total sales from 1st to 7th of december 2012 to the total sales from 1st to 7th of 2013 automatically and then tomorrow it will compare from 1st to 8th 2012 to 1st to 8th in 2013 and will go on until the end of the month?
View 8 Replies
View Related
Jan 26, 2009
I have column A with 228 rows and column D with 314 rows. Both columns have the same data except that D has different data. I would like to line up everything that is the same in A and D and everything else in column D that is not the same move to G. Is there a quick way to do this?
View 5 Replies
View Related
Jan 27, 2014
I attached an example.
I am trying to figure out how I can write formulas that look for trends in the data. I will be entering more data every day. I need to look at the 5, 10, 20 most recent results for each number.
For example, I need to see how many times yes was answered for #3 in the most recent 5,10, 20 entries.
I am sure there is some simple way to do this with a control + f formula, but I don't know how to do it.
View 14 Replies
View Related
Oct 1, 2013
i need to compare the data in two different excel files and ask if the data in column A that contains a registration number is the same in both and if not to flag up any that are missing
Is there a macro or command I could use that will do this
View 2 Replies
View Related
Oct 11, 2008
i had received a new project. i want to compare the data among 2 different workbooks. there are book1 and book2 which i attach at here. if there are 1 cells is different with both workbooks, then the whole row will copy and paste to a new workbook "output.xls".
i also attach the "output.xls" at here.
the background color i highlighted which data is different, just for easy to view. so can ignore the color.
View 14 Replies
View Related
Sep 29, 2009
Each day I have workbooks saved that contain data of alarm files – saved format “PAR Process Alarm Report_MMDDYYYY”.
Within each workbook there is a sheet named “E&H” for each day. The goal is to figure out which Tag is causing the most problems. 1 Tag may hit 100 times in a day and then again 40 times a week later. Another tag may hit 2 times a day every day - This is the tag we would want to tackle. I’ve attached 1 of the E&H sheets so you can see what they look like. Comments are in row 1 explaining what they are.
I have code provided here that will go into each workbook. I’ve commented out the part that I think needs to be edited to make this all work but I could be wrong. This will be extremely helpful if I can get this all to work.
View 12 Replies
View Related
Apr 21, 2009
The data in each worksheet is from different programs that I need to combine. The first worksheet contains student mailing address information and the second details of payments for a specific purpose. Both worksheets has common data that is the student number. We have around 960 students and I can have anywhere between 400 and 20 students paying within any given month.
Below is an example of what I need, Sheet3 being the end result. I don't care if it is easier to combine both sheet1 and sheet2 completely and need to delete columns or move anything around (that takes no time).
I have tried to research how to do this but as I have no programming experience I have been unable to get my head around it.
View 4 Replies
View Related
