comparisons

Is it possible to compare two columns for a match and if there is a match compare two other columns? For example, I want to compare two workbooks with similar data. The FIRST thing I want to check is that there is a match for employee numbers. If there isn't a match, I would want it to be...

I have a long spreadsheet that does comparisons, if the comparisons are true column K is highlighted yellow. what im trying to do is then change the highlighted cell to a test that reads "Already Monitored" using VBA. the rest of the cells should stay blank. Any ideas on this? thanks

Hi all, I have travel household surveys and am sorting it for an assignment. The idea is sort out the data based on how many vehicles households own dependent on their income. An example of the data is shown in the first table: <tbody> INCOME NO. OF CARS NO. OF TRUCKS 1000 0 0 5320 1 0...

Hi everyone I need some help with comparing 2 sets of data in Excel (see screenshot below). As you can see i have data from 2 sources. Source 1 is the correct data. Source 2 may have been correct at some point but its not up-to-date. I want to be able to look at the Account number and...

Hi there. i am looking for a formula to allocate a percentage out of 100%, to a range of values. I am evaluating 6 options (Column A) and they have different costs (Column B). I wish to write a formula in Column C that displays the cost as a %, where 0% is the least cost and 100% is the most...

Hello everyone, This is my first post here, and I just joined the forum after searching around and learning a few things about setting up my data entry table for later analysis of survey responses. I'm pretty excited about learning how to do calculations with Excel I've never even considered...

Hi Experts , I dont know excel, but want to learn it asap specially for the current requirement i have . Requirement description (Excel 2007) : Code comaparison 1 workbook contains 3 sheets Comp , Jack , Jill named repectively , Jack has more code when compaired to Jill always :- Step 1 - we...

I have a line of VBA code that should be returning TRUE but doesn't... does anybody have any thoughts as to why this could be? If Left(Range("Y" & a).Value,1) = roll_day Then ... I have added a watch to "Left(Range("Y" & a).Value,1) and roll_day. At the time the comparison is supposed to be...

Hello There, I've searched the forum to get assistance on this issue but I don't think any post directly applies to my question. I am not trying to specify a string in the formula, as although the sample below would indicate that there are only 12 possible variables that can be entered into...

I work in a clinical laboratory and part of my job is to do instrument comparisons. I have two urinalysis instruments which give similar but different results. Example: Glucose: Iris: reports as 0, 70,100,150,200,250,300,500,1000,>1000. Glucose: Clinitiek: reports as 0. trace, 250, 500...

I want to compare the text in two cells and with the result of the comparison manifesting as a percent that explains the accuracy between the text in the two cells. For example, cell A1 would have the words: "Mostly Cloudy/Breezy" Cell B1 would have the words: "Breezy"...

Hi there, I have a spreadsheet that has 2 different product description that have been matched and a single price. I would like a formula that enables a new order spreadshhet to look up the price on the master spreadsheet and bring it into the order spreadsheet. Is this possible please ...