Formula Request

M

missesfrancis

New Member
Joined
Oct 2, 2017
Messages
2
Hi!
I have below a small portion of a file. I have sorted my file by 'PART_NUMBER'. But now I want to see if there is a formula to tell me if the part number in red has a different rate than the part number in black.
I am trying to see which ones are equal to, less than or more than the white rows.
I have about 12000 lines on this excel file and I'd like to find out which rates changed in price or stayed the same - by doing a formula rather than going down line by line.

[TABLE="width: 1783"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SERVICE_DESCRIPTION[/TD]
[TD]PART_NUMBER[/TD]
[TD]PURCHASE_CATEGORY_CODE[/TD]
[TD]ITEM_MASTER[/TD]
[TD]DATE_FROM[/TD]
[TD]DATE_TO[/TD]
[TD]DETAIL_COMMENTS[/TD]
[TD]QUALIFIER[/TD]
[TD]QUANTITY_THRESHOLD[/TD]
[TD]UNITS[/TD]
[TD]MIN_RATE[/TD]
[TD]MAX_RATE[/TD]
[/TR]
[TR]
[TD]10001352-ZFF - Field Specialist-Fishing[/TD]
[TD]10001352-ZFF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3850.00[/TD]
[TD="align: right"]3850.00[/TD]
[/TR]
[TR]
[TD]10001352-ZFL - Field Specialist-Fishing[/TD]
[TD]10001352-ZFL[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.00[/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]Fishing Tool Supervisor Technician-SERV-FS PER 24 HRS[/TD]
[TD]10001352-ZFL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]10001352-ZHF - Field Specialist-Fishing[/TD]
[TD]10001352-ZHF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3955.00[/TD]
[TD="align: right"]3955.00[/TD]
[/TR]
[TR]
[TD]Fishing Tool Supervisor Technician-SERV-TS HAZARDOUS[/TD]
[TD]10001352-ZHF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]3955.00[/TD]
[/TR]
[TR]
[TD]10001352-ZPES - Fishing Tool Supervisor Technician PERSONEL STDBYPERDAY[/TD]
[TD]10001352-ZPES[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.00[/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]10001352-ZPES - Fishing Tool Supervisor Technician PERSONEL STDBYPERDAY[/TD]
[TD]10001352-ZPES[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]10/27/2015[/TD]
[TD="align: right"]6/30/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.03[/TD]
[TD="align: right"]2795.03[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-RENT-STANDBY[/TD]
[TD]10005067-ZSB[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]75.00[/TD]
[TD="align: right"]75.00[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-MILEAGE-CAR/PICKUP[/TD]
[TD]10005067-ZWF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3.75[/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-MILEAGE-CAR/PICKUP[/TD]
[TD]10005067-ZWF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]10005067-ZWP - Miles/KM - Fishing Service[/TD]
[TD]10005067-ZWP[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]10005067-ZX8 - MILES/KM - FISHING SERVICE[/TD]
[TD]10005067-ZX8[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]6.00[/TD]
[TD="align: right"]6.00[/TD]
[/TR]
[TR]
[TD]3rd Party Svc - Fishing Service-REPAIR-DAMAGED ITEM[/TD]
[TD]10005080-ZZC[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-FLAT RT[/TD]
[TD]10005120-ZLJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-INITIAL[/TD]
[TD]10005120-ZMH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-ADD'L[/TD]
[TD]10005120-ZQF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-STANDBY[/TD]
[TD]10005120-ZQG[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Assistant Oper. - Fishing-SERVICE - 24 HR[/TD]
[TD]10068646-ZWS[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2853.00[/TD]
[TD="align: right"]2853.00[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - AMT - STANDBY[/TD]
[TD]10071484-ZAMS[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]647.80[/TD]
[TD="align: right"]647.80[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-AMT - STANDBY[/TD]
[TD]10071484-ZAMS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - Advanced MillingTech[/TD]
[TD]10071484-ZAMT[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1457.55[/TD]
[TD="align: right"]1457.55[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-Advanced MillingTech[/TD]
[TD]10071484-ZAMT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1457.55[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - RENT-PREM TOOL[/TD]
[TD]10071484-ZBR[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1082.25[/TD]
[TD="align: right"]1082.25[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-RENT-PREM TOOL[/TD]
[TD]10071484-ZBR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1082.25[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - RENT-O.D. INCH/JOB[/TD]
[TD]10071484-ZOD[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1266.30[/TD]
[TD="align: right"]1266.30[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-RENT-O.D. INCH/JOB[/TD]
[TD]10071484-ZOD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1266.30[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
ranman256 said:
so line 3 is red,
you want this record to compare to ALL black records?
Click to expand...

Yes, so some of the part numbers are duplicated, but have a different rate (all the way to the right of the page). I want to see which ones are the same and which rates changed.
I was trying to attach the whole document, but I don't think i can here.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

Share this page

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