Query from an excel data base

Hi Dave,
You mention 'extracted' , could you be a little more specific?
You could use a Pivot table to group the customers and their visits and values and just filter the ones with values < 200

I used Advanced Filter and array-formulas and a small macro (VBA code)
1 click on button [Run1] gives the results.
Because of the VBA I saved the file as *.xlsm

Another way.

In columns F:G apply 'Remove Duplicates' as below.

Then enter array formula in H2, copy down and across 6 columns. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.


=IFERROR(INDEX($D$2:$E$12,SMALL(IF((LARGE(IF(($F2=$A$2:$A$12)*($G2=$B$2:$B$12),$D$2:$D$12),{1,2,3})=IF(($F2=$A$2:$A$12)*($G2=$B$2:$B$12),$D$2:$D$12))*($E$2:$E$12<200),ROW($A$2:$A$12)-MIN(ROW($A$2:$A$12))+1),CEILING(COLUMNS($H:H)/2,1)),MOD(COLUMNS($H:H)-1,2)+1),"")

Row\Col	F	G	H	I	J	K	L	M
1	Last Name	First Name	DoVisit	Value	DoVisit	Value	DoVisit	Value
2	Agen	Jack	2/5/2017	41	1/5/2017	180
3	Bob	Jill	1/8/2017	50	2/28/2017	100	3/1/2017	40
4	Dave	Liz	2/14/2017	150	1/15/2017	180	1/1/2017	190