Data comparison

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lea (anonymous_at_discussions.microsoft.com)
Date: 05/05/04 

Date: Tue, 4 May 2004 19:34:46 -0700

Thanks John,

I tried a =IF(ISERROR(MATCH(A4,$C$1:$C$190,0)),"",B4) type
formula but it only worked on some cells!! where it
compared 2 rows of payroll numbers (A & C) and inserted
wages or salary from B but....it doesn't really work

I'll give it a go, thanks again for your help

>-----Original Message-----
>if you have the name in cell B4 of sheet 1, and the hours
>worked in cell C4, put this in cell D4
>
>=MATCH(B4,Sheet2!$B$4:$B$10,0)
>
>where the sheet 2 reference column B is the column where
>you have the names (starting in row 4) and presumably
have
>the salary vs wages in column C.
>
>The match function finds the position in a data set of
>what you are looking for, in this case the name.
>
>then put this in cell E4 of sheet 1, assuming the data in
>sheet 2 also starts in row 4
>
>=OFFSET(Sheet2!$B$3,D4,1,1,1)
>
>The offset function returns the value from a cell a
>specificed rows and columns form you reference. the
above
>match figures out the correct row, and the first "1" says
>look one column to the right.
>
>This is a simple way to do it within the spreadsheet, but
>someone better at VBA than I could probably write a slick
>routine stepping down thru your list of names, but that
>might be overkill.
>
>better?
>
>John
>
>>-----Original Message-----
>>Thanks John, but honestly, that was as clear as mud...
>I'm
>>not very good at these formulas!
>>
>>Let me explain a little better
>>
>>Workbook 1
>>sheet 1
>> A B
>>1 Employee number Total Hours
>>C will be where the type of pay is inserted from
workbook
>>2.
>>
>>
>>Workbook 2
>>sheet 2
>> A B
>>1 Employee number type of pay
>>
>>Thanks
>>Lea
>>>-----Original Message-----
>>>
>>>
>>>Hi - you can use match function to find row of each
name
>>>in the worksheet with the salary vs wages data. Then
>you
>>>can use offset function with this result to
>find "salary"
>>>or "wages". hope that helps.
>>>
>>>John
>>>>-----Original Message-----
>>>>Hi,
>>>>
>>>>I'm trying to compare data from two very large
>>>>spreadsheets.
>>>>Both contain payroll data, one with hours worked per
>>>>employee, the other showing employees as wages or
>salary
>>>>staff. I need to pinpoint which employees in the
hours
>>>>worked spreadsheet are wages staff, and which are
>>>salaried
>>>>as quickly and easily as possible.
>>>>
>>>>Please help
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>

Relevant Pages

  • Re: Watching Barrett-Jackson
    ... Buffett included this in his 40% figure I think, and if the money is being taken out of your gross pay and sent to the government, I would call it a tax, rather than a benefit, although I think they call it a "contribution". ... show me an employee that I am guaranteed to come out ahead on and I'll hire them on the spot. ... I'm not even guaranteed to make a profit on me, and I'm one of my better employees. ... I believe Mr Buffet was comparing the small percentage that the govt takes on dividends and capital gains from money he gets to the larger percentage that the govt takes of her wages. ...
    (rec.motorcycles.harley)
  • Re: Smoke one of your very best
    ... And some people are not permitted to exercise their drive because their peers or society won't permit it. ... if we artificially inflate wages, it encourages people to settle-in at the lowest possible job. ... If we didn't pay people NOT to work, maybe some of them would consider working. ... I'm telling you that it's PREFERABLE to allow an employer and a prospective employee to negotiate the correct wage for a job/skill-set pair than for you, me, the government or anyone else to step in and say "you there, you're not allowed to accept that job for so little pay" and/or "you there, you're not allowed to hire that person at the agreed-upon rate." ...
    (alt.smokers.cigars)
  • Re: Dinner at the Plaza in the Magic Kingdom, "my experience."
    ... >> The employee tax is approx 15.2% of which the employer pays ... > because the restaurant wages are so low) skip FICA and Social Security ... > much bigger burden on other workers who are taxed AND pay Soc. ... and the tipping system circumvents that. ...
    (rec.arts.disney.parks)
  • Re: Unstaffed stations and tickets: the Virgin approach (long, sorry)
    ... > the people who pay his wages. ... be suspicious of an employee who attracted lots of complaints. ... would also be suspicious of an employee who *never* attracted complaints ...
    (uk.railway)
  • Re: The stock market responsible for the decline in British industry?
    ... than capitalists. ... to enhance the productivity of paid labour to make profit. ... had to pay sufficient wages and provide the requisite conditions to ... wages down to starvation level and living conditions likewise and fed ...
    (uk.politics.misc)