Highlight Charges

daza34

Board Regular
Joined
Feb 14, 2017
Messages
63
Hi,

I need help with a formula that tells me the date on new Pricebook on the "charge from date" column does not start before the old PriceBook, see below
CHARGE FROM DATECharge to DateCHANGE REF
07/07/2021​
30/09/2021​
Old PriceBook
07/07/2021​
30/09/2021​
Old PriceBook
07/07/2021​
30/09/2021​
Old PriceBook
07/07/2021​
30/09/2021​
Old PriceBook
08/07/2021​
31/10/2021​
New PriceBook
08/07/2021​
31/10/2021​
New PriceBook
08/07/2021​
31/10/2021​
New PriceBook
08/07/2021​
31/10/2021​
New PriceBook

These dont but a lot are incorrect and i have thousands of lines of data to go through :(
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Upvote 0
Thank you, but i dont think i explained it properly, i need to know if any of the Niel dates column C start before LAN likewise if any of the transport dates start before wan. The names are in column A.

NameA SITECHARGE FROM DATECharge to DateREF
LAN
2159​
07/07/2021​
30/09/2021​
ds554654
LAN
2159​
07/07/2021​
30/09/2021​
ds554654
LAN
2159​
07/07/2021​
30/09/2021​
ds554654
LAN
2159​
07/07/2021​
30/09/2021​
ds848756558
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Niel
2159​
08/07/2021​
31/10/2021​
New PriceBook
Transport01259_Transport Charges
08/07/2021​
31/10/2021​
New PriceBook
WAN
2159​
07/07/2021​
30/09/2021​
ds54545421

The once I have that sorted a suggestion on how to display this on a pivot etc for different sites?
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

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