| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totally Lost - Dates in huge table, Range finder
Hi all I have a masive table of dates (the date is created via a if formula) what i need is so wheni enter 2 dates in 2 cells the system checks all the dates between the two specified and then returns the contents of them to a small area on the page. eg. Dates To Test 14/08/2026 19/08/2026 Results 14/08/2026 15/08/2026 16/08/2026 17/08/2026 18/08/2026 19/08/2026 Table 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 18/08/2026 18/08/2026 18/08/2026 18/08/2026 TAKEN 18/08/2026 18/08/2026 18/08/2026 18/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 i dont mind using script or anything like that, i dont have much knowlage of it but do have coniderable understanding of other langages and usually figure it out :D thanks -- kempy1000 ------------------------------------------------------------------------ kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549 View this thread: http://www.excelforum.com/showthread...hreadid=571812 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totally Lost - Dates in huge table, Range finder
Use Data / AutoFilter... and filter your date column based on two conditions:
Greater than or equal to.. First Date And Less than or equal to.... Second Date HTH, Bernie MS Excel MVP "kempy1000" wrote in message ... Hi all I have a masive table of dates (the date is created via a if formula) what i need is so wheni enter 2 dates in 2 cells the system checks all the dates between the two specified and then returns the contents of them to a small area on the page. eg. Dates To Test 14/08/2026 19/08/2026 Results 14/08/2026 15/08/2026 16/08/2026 17/08/2026 18/08/2026 19/08/2026 Table 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 14/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 15/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 16/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 17/08/2026 18/08/2026 18/08/2026 18/08/2026 18/08/2026 TAKEN 18/08/2026 18/08/2026 18/08/2026 18/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 19/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 20/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 21/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 22/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 23/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 24/08/2026 i dont mind using script or anything like that, i dont have much knowlage of it but do have coniderable understanding of other langages and usually figure it out :D thanks -- kempy1000 ------------------------------------------------------------------------ kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549 View this thread: http://www.excelforum.com/showthread...hreadid=571812 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totally Lost - Dates in huge table, Range finder
Thank you very much but is there a way so that the auto filter can filter using a cell value rather than having to write it in? -- kempy1000 ------------------------------------------------------------------------ kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549 View this thread: http://www.excelforum.com/showthread...hreadid=571812 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totally Lost - Dates in huge table, Range finder
No. You would need to use a macro, like
Sub Example() Range("C6:F1000").AutoFilter Field:=2, Criteria1:="=" & Range("D2").Value, Operator:=xlAnd, _ Criteria2:="<=" & Range("D3").Value End Sub D2 and D3 held the values on which you wanted to autofilter column D (the second column of the range) HTH, Bernie MS Excel MVP "kempy1000" wrote in message ... Thank you very much but is there a way so that the auto filter can filter using a cell value rather than having to write it in? -- kempy1000 ------------------------------------------------------------------------ kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549 View this thread: http://www.excelforum.com/showthread...hreadid=571812 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totally Lost - Dates in huge table, Range finder
Hi thanks for that its ok but reverses the last date so when i try to choose the outer boundry as 01/12/2006 it uses 12/01/2006 and also it hides the chosen values where i need it to show the chosen dates and hide the rest -- kempy1000 ------------------------------------------------------------------------ kempy1000's Profile: http://www.excelforum.com/member.php...o&userid=37549 View this thread: http://www.excelforum.com/showthread...hreadid=571812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup based on range of dates | Excel Worksheet Functions | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Linear Mode
