Filter for two columns
 

I have two columns Purchased Date and Depreciation Start Date. Can anyone
help me to get the records with Depreciation Start Date greater than
Purchased Date.
Thanks

Filter for two columns
 

Hi,
sort with two conditions, highlight both columns, 1st condition Depreciation
in descending order and as a 2nd condition Purchased in ascending order
if this was helpful please say yes

"Vadivu" wrote:

I have two columns Purchased Date and Depreciation Start Date. Can anyone
help me to get the records with Depreciation Start Date greater than
Purchased Date.
Thanks

Filter for two columns
 

Use a helper col. Assuming purchase dates in col A, depreciation start dates
in col B, data in row2 down, then in C2: =IF(AND(COUNT(A2:B2)=2,B2A2),"x","")
Copy C2 down. Apply autofilter on col C, choose: x
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Vadivu" wrote:
I have two columns Purchased Date and Depreciation Start Date. Can anyone
help me to get the records with Depreciation Start Date greater than
Purchased Date.
Thanks