What function do I use to pull data prior to a certain date?
Closed
NSamm
-
17 Nov 2016 à 11:07
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 20 Nov 2016 à 19:32
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 20 Nov 2016 à 19:32
Related:
- What function do I use to pull data prior to a certain date?
- How to pull data from one excel sheet to another - Guide
- What is the function of a hard drive - Guide
- Tmobile data check - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Network card function - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Nov 2016 à 11:14
17 Nov 2016 à 11:14
NSamm, Good afternoon.
In your case, a simple formula or function won't work.
You need a VBA EXCEL programming to do your task.
In your case, a simple formula or function won't work.
You need a VBA EXCEL programming to do your task.
fdibbins
Posts
33
Registration date
Sunday 19 June 2016
Status
Contributor
Last seen
20 November 2016
1
20 Nov 2016 à 19:32
20 Nov 2016 à 19:32
This can be done with an index/small ARRAY function, but depending on the volume of data you are dealing with, it may slow your file down. Something like...
=iferror(index(A:A,small(if($A$1:$A$500<=your-selected-date,row($A$1:$A$500)),rows($A$1:A1))),"")
entered using CTRL SHIFT ENTER, not just enter, then copy down and across as needed
This is based on column A containing your dates - adjust as needed
=iferror(index(A:A,small(if($A$1:$A$500<=your-selected-date,row($A$1:$A$500)),rows($A$1:A1))),"")
entered using CTRL SHIFT ENTER, not just enter, then copy down and across as needed
This is based on column A containing your dates - adjust as needed
