Forum Discussion
Solved
Need Help sorting Data
I need help sorting data by order date. I have over 100K lines in two columns with one showing the part number and the other showing the order date. I want to know how many instances there were where...
This solution uses sorting and conditional formatting.
1. Sort by Part (A to Z) then by Order Date (Old to New).
2. Use conditional formatting w/formula to identify instances where the part ordered has been 2+ years since previous order:
=AND($A2=$A1,DATEDIF($B1,$B2,"y")>=2)
This solution uses sorting and conditional formatting.
1. Sort by Part (A to Z) then by Order Date (Old to New).
2. Use conditional formatting w/formula to identify instances where the part ordered has been 2+ years since previous order:
=AND($A2=$A1,DATEDIF($B1,$B2,"y")>=2)
Bless your heart, i've been trying to figure out how to do this for hours today. A million thank yous!!!!!!
- You're welcome!
Quick follow up. With that formula being used, it is highlighting the order from 2 years ago. How can i tweak the formula so it highlights the order that was placed after its been two years? Patrick2788
- The formula is concerned with orders greater than or equal to 2 years.