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 we went 2 years or more in-between the purchase of an item.
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!
