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)
