| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| Filter on multiple columns | Excel Discussion (Misc queries) | |||
| Filter for value 1 in two columns | Excel Worksheet Functions | |||
| Filter entire columns | Excel Discussion (Misc queries) | |||
| how do i filter multiple columns | Excel Worksheet Functions | |||
Linear Mode
