Trying to pull data based on certain criteria

[Secrestbar1]

I am trying to create a document for the VP’s of my companyto be able to type in a Region number and date and have it display only thosestores that have items sold that are under 35.

I would also like to break it up buy hour. I have beentrying the formula “=IF(ISERROR(INDEX(Page1!$A$1:$J$66957,SMALL(IF(Page1!$A$1:$A$66957=$B$1,ROW(Page1!$A$1:$A$66957)),ROW(Page1!2:2)),2)),"",INDEX(Page1!$A$1:$J$66957,SMALL(IF(Page1!$A$1:$A$66957=$B$1,ROW(Page1!$J$1:$J$66957)),ROW(Page1!2:2)),2))”but it doesn’t seem to work properly.

I’m not sure how I can show you an example, but I am morethan willing to send the document to someone for help???

Thank you in advance,
Jillian

 

[Fluff]

Hi & welcome to MrExcel.
There are some tools available here https://www.mrexcel.com/forum/about-board/508133-attachments.html
that will allow you to post data to the site

 

[Secrestbar1]

Got it! Thank you!
I am waning to the VPs to be able to type in a Region and/or date in cells B1 & B2 and for it to populate results in the appropiate columns, that are less than 35. The second screen shot is the data tab.

Region	3
Date	10/29/2018
DPSA	35
Region	Store	less than 35

<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;"> <col width="64" style="width: 48pt;" span="3"> <tbody> </tbody>

Rest Region	Store	10/29/2018	10/30/2018	10/31/2018	11/1/2018	11/2/2018	11/3/2018	11/4/2018
1	4	22	29	53	51	76	88	87
1	6	58	52	47	61	85	74	95
1	8	50	63	53	59	82	76	74
1	9	28	29	28	50	70	75	70
1	10	38	38	34	35	38	34	67
1	12	48	41	48	46	47	91	105
1	16	46	49	42	59	47	56	63
1	18	44	36	45	45	97	115	83
1	19	38	23	26	51	49	45	71
1	21	58	50	61	58	75	88	53
1	48	66	31	52	81	73	63	60
1	53	36	21	34	28	32	52	44
1	55	50	63	51	59	95	98	72
1	60	38	40	48	30	63	88	96
1	61	42	38	31	65	64	86	86
1	65	25	47	38	32	69	67	90
1	66	29	30	32	58	77	88	70
1	71	42	32	41	49	71	99	137
1	75	41	38	22	57	42	46	65
1	77	30	65	39	0	0	56	41
1	79	69	63	73	60	78	0	88
1	83	29	53	48	64	67	80	109
1	96	45	49	36	69	59	71	88
1	113	32	43	44	70	58	85	90
1	126	37	15	19	25	27	31	45
1	128	29	30	18	15	30	71	63

<colgroup><col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;"> <col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="3"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" span="3"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <tbody> </tbody>