hscott82

New Member
Joined
Oct 30, 2019
Messages
33
Hello, I am trying to look up the Max Value (Paid Rate) from one sheet and return it to another sheet.

I have employees that are paid at a Base Rate, but sometimes are paid at a different rate. On 'Orig' Tab there can be a lot of Rows for employees and I need to find the MAX Paid Rate in Column P. It would be Higher than their Base Rate.

Sheet 1 (Research Tab)
BCIK
Employee IDNameBasePaid rate
0238324Smith, John$ 20.00
0502199Toms, Alex$ 9.75
0445882Walters, Jean$15.00

Sheet 2 (Orig Tab) The Paid Rates in RED are the Values I am looking at Returning to the Research Tab, because they are different than the Base Rate in column H.
CDHNP
EMPLOYEE IDNameBase RateCodePaid Rate
0238324Smith, John
20​
REG2
20​
0238324Smith, John
20​
REG2
25
0238324Smith, John
20​
REG2
20​
0502199Toms, Alex
9.75​
REG2
9.75​
0502199Toms, Alex
9.75​
REG2
10.5
0502199Toms, Alex
9.75​
REG2
9.75​
0445882Walters, Jean
15​
REG2
15​
0445882Walters, Jean
15​
REG2
15​
 
GRIN...
So, for Smith, you want 005 and for Toms, you want 130?!

What happens when someone works non-home and the same number of hours at each of the non-home locations?
Did you think of that one?
That would be very hard to have happen. Our system doesn't "Round" their hours so the chances of them ever working the exact same amount of hours is extremely slim.
 
Upvote 0

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top