Can Excel find info between two numbers or dates?

[Dman25]

Example: 18-10 thru 18-25 can it find 18-20 or a date such as 11/25/15 thru 12/25/20 can it find dates between that?

 

[MARK858]

Can you explain more what you are actually trying to achieve, if you just want those dates shown in place you can just use the autofilter using the between option.

 

[sandy666]

like this?

with Power Query (Get&Transform)

start	end		Custom
18-10	18-25		10
			11
			12
			13
			14
			15
			16
			17
			18
			19
			20
			21
			22
			23
			24
			25

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Text = Table.TransformColumnTypes(Source,{{"start", type text}, {"end", type text}}),
    ETAD = Table.TransformColumns(Text, {{"start", each Text.AfterDelimiter(_, "-"), type text}}),
    ETAD2 = Table.TransformColumns(ETAD, {{"end", each Text.AfterDelimiter(_, "-"), type text}}),
    Number = Table.TransformColumnTypes(ETAD2,{{"start", Int64.Type}, {"end", Int64.Type}}),
    List = Table.AddColumn(Number, "Custom", each {[start]..[end]}),
    Serie = Table.ExpandListColumn(List, "Custom"),
    TSC = Table.SelectColumns(Serie,{"Custom"})
in
    TSC

or like this

for dates is a similar method

 

[Dman25]

I’ve got boxes with records that have the year with the file numbers on the outside of the box. Example year-file #. So it looks like this 18-200 thru 18-250. Also some just have the date ranges example 11/25/18 thru 11/30/19. I want to be able to type in 18-220 and it find it in that cell, or the date 4/10/19.

 

[sandy666]

post representative example of source and what you want to achieve (more than one row)

 

[sandy666]

something like that?

Number	Date		Value		Date
18-200			18-220		09/01/2019
18-201	25/11/2018
18-202	26/11/2018
18-203	27/11/2018
18-204	28/11/2018
18-205	29/11/2018
18-206	30/11/2018
18-207	01/12/2018
18-208	02/12/2018
18-209
18-210
18-211
18-212	01/01/2019
18-213	02/01/2019
18-214	03/01/2019
18-215	04/01/2019
18-216	05/01/2019
18-217	06/01/2019
18-218	07/01/2019
18-219	08/01/2019
18-220	09/01/2019
18-221	10/01/2019
18-222	11/01/2019
18-223	12/01/2019
18-224	13/01/2019
18-225	14/01/2019
18-226	15/01/2019
18-227	16/01/2019
18-228	17/01/2019
18-229
18-230
18-231
18-232
18-233
18-234
18-235
18-236
18-237
18-238
18-239
18-240
18-241
18-242	22/11/2019
18-243	23/11/2019
18-244	24/11/2019
18-245	25/11/2019
18-246	26/11/2019
18-247	27/11/2019
18-248	28/11/2019
18-249	29/11/2019
18-250	30/11/2019

let
    Src1 = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Src2 = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
    Join = Table.NestedJoin(Src2,{"Value"},Src1,{"Number"},"Src1",JoinKind.LeftOuter),
    Exp = Table.ExpandTableColumn(Join, "Src1", {"Date"}, {"Date"}),
    TDate = Table.TransformColumnTypes(Exp,{{"Date", type date}}),
    TSC = Table.SelectColumns(TDate,{"Date"})
in
    TSC

 

[Dman25]

Unit	Box #	Box content
HR	1326	files 18-90 thru 20-15
Payroll	1890	files 14-50 thru 16-100

 

[sandy666]

sorry but it doesn't make sense to me
I am not in your head and forgot my Crystal Ball so I don't know what you want to do with data from the post#7

btw. you can use XL2BB to post data here