You can apply the Table Filter macro to your table containing financial data. With the number range and date range filters you can quickly filter entries matching the specific rnage or period of time.
Filtering the number ranges
Table Filter macro allows you to filter numbers in your tables. Just select the appropriate number range or minimal/maximal value and get the table data filtered.
yy-mm-ddMinimal Purchase‚ $,Maximal Purchase‚ $,Average Purchase‚ $1457694541137_-75021529
| Customer |
Minimal Purchase, $ |
Maximal Purchase, $ |
Average Purchase, $ |
| Remy Deomampo |
47.50 |
139.13 |
214.00 |
| Rahul Dickstein |
73.50 |
505.88 |
184.00 |
| Radu Donahue |
117.75 |
514.75 |
208.25 |
| Preston Doorey |
61.38 |
571.50 |
334.63 |
| Phill Doyle |
63.38 |
558.75 |
142.00 |
| Philip Druckman |
37.13 |
495.75 |
291.25 |
| Philip Duncan |
74.13 |
88.00 |
125.38 |
| Peter Elia |
121.25 |
573.00 |
338.38 |
| Peter Erickson |
81.00 |
453.38 |
73.75 |
| Peter Espinosa |
26.13 |
427.38 |
63.38 |
| Peter Ferrero |
98.25 |
347.75 |
99.25 |
| Perez Figueiredo |
26.13 |
315.38 |
148.13 |
| Patrick Fixler |
27.88 |
548.00 |
221.13 |
| Patrick Flegal |
119.13 |
185.63 |
250.25 |
| Patino Forsyth |
110.38 |
93.13 |
366.13 |
| Pallavi Fox |
124.50 |
552.50 |
150.13 |
| Owen Franzoni |
77.88 |
462.75 |
359.25 |
| Ophir Friedman |
98.88 |
170.25 |
155.50 |
| Obaid Friis |
25.63 |
331.88 |
277.63 |
| Noelle Fu |
47.38 |
569.63 |
273.75 |
| Noel Gambino |
102.13 |
134.88 |
332.38 |
| Nicole Gao |
34.50 |
608.25 |
141.00 |
| Nishant Gao |
117.13 |
622.25 |
326.50 |
| Nicole Garcia |
87.00 |
260.88 |
179.50 |
| Negrin Gee |
93.13 |
299.38 |
117.63 |
Click here to expand the table with other data for filtration...yy-mm-ddAverage Time per Call (min),Average Time per Ticket (min),Calls per Hour,Tickets per Hour,Earned Money for Support ($),Support Efficiency1457694541139_-75021529
| Customer |
Tickets per Hour |
Average Time per Ticket (min) |
Calls per Hour |
Average Time per Call (min) |
Earned Money for Support ($) |
Support Efficiency |
| Remy Deomampo |
2.8 |
5.9 |
2.6 |
7.2 |
5 185.00 |
47.00% |
| Rahul Dickstein |
7.8 |
2.5 |
2.0 |
3.7 |
2 366.00 |
62.00% |
| Radu Donahue |
6.5 |
3.8 |
1.9 |
3.2 |
1 449.00 |
20.00% |
| Preston Doorey |
6.7 |
6.8 |
3.7 |
6.7 |
3 096.00 |
42.00% |
| Phill Doyle |
4.7 |
4.0 |
2.3 |
6.7 |
4 957.00 |
23.00% |
| Philip Druckman |
3.9 |
3.0 |
2.0 |
4 |
3 544.00 |
37.00% |
| Philip Duncan |
7.3 |
5.9 |
1.3 |
5.8 |
4 007.00 |
16.00% |
| Peter Elia |
2.3 |
6.3 |
3.5 |
5.9 |
4 743.00 |
24.00% |
| Peter Erickson |
6.1 |
2.8 |
3.4 |
5.6 |
5 134.00 |
57.00% |
| Peter Espinosa |
5.4 |
2.7 |
4.8 |
4.1 |
2 257.00 |
44.00% |
| Peter Ferrero |
3.7 |
4.5 |
2.4 |
7.2 |
2 350.00 |
40.00% |
| Perez Figueiredo |
8.0 |
4.0 |
4.2 |
3.1 |
2 972.00 |
16.00% |
| Patrick Fixler |
6.4 |
1.4 |
1.5 |
5.9 |
4 490.00 |
11.00% |
| Patrick Flegal |
4.3 |
6.8 |
4.9 |
7.4 |
2 506.00 |
14.00% |
| Patino Forsyth |
5.5 |
7.0 |
3.5 |
4 |
1 489.00 |
73.00% |
| Pallavi Fox |
2.1 |
2.4 |
3.1 |
6.2 |
4 533.00 |
14.00% |
| Owen Franzoni |
6.7 |
5.2 |
4.9 |
4.3 |
1 361.00 |
77.00% |
| Ophir Friedman |
5.3 |
2.1 |
2.0 |
7.8 |
2 032.00 |
47.00% |
| Obaid Friis |
7.5 |
4.0 |
3.8 |
7.5 |
4 812.00 |
16.00% |
| Noelle Fu |
2.8 |
6.8 |
1.2 |
6.6 |
2 167.00 |
10.00% |
| Noel Gambino |
6.7 |
2.9 |
2.5 |
3.1 |
3 090.00 |
47.00% |
| Nicole Gao |
9.0 |
2.3 |
2.6 |
7.8 |
4 518.00 |
61.00% |
| Nishant Gao |
6.0 |
3.9 |
2.0 |
5.2 |
3 411.00 |
71.00% |
| Nicole Garcia |
3.8 |
5.9 |
4.6 |
6.3 |
3 139.00 |
28.00% |
| Negrin Gee |
2.8 |
2.3 |
2.2 |
5.4 |
4 072.00 |
54.00% |
Filtering the date ranges
Table Filter macro allows you to filter dates in your tables. The date format is defined automatically.
Registration Date,First Transaction,Last Transaction,,m/d/yy1457700515622_1692327838Point (.)
| Customer |
Registration Date |
First Transaction |
Last Transaction |
| Stephen Chan |
5/26/2020 |
7/29/2020 |
7/19/2020 |
| Steven Chan |
6/5/2020 |
7/29/2020 |
8/14/2020 |
| Sompop Chang |
6/16/2020 |
7/21/2020 |
7/25/2020 |
| Spencer Chang |
6/23/2020 |
7/13/2020 |
8/11/2020 |
| Stephanie Chang |
6/14/2020 |
7/23/2020 |
8/9/2020 |
| Simond Chat |
5/18/2020 |
6/20/2020 |
8/20/2020 |
| Simon Chau |
6/17/2020 |
7/19/2020 |
7/27/2020 |
| Shiv Chayet |
5/4/2020 |
7/17/2020 |
7/20/2020 |
| Shannon Cheesebro |
5/11/2020 |
7/4/2020 |
8/20/2020 |
| Scott Chen |
5/3/2020 |
7/27/2020 |
8/2/2020 |
| Se Chen |
6/21/2020 |
7/11/2020 |
7/26/2020 |
| Sean Chen |
6/9/2020 |
7/21/2020 |
7/20/2020 |
| Seth Chen |
5/30/2020 |
7/15/2020 |
8/12/2020 |
| Sevag Chen |
5/15/2020 |
6/24/2020 |
7/20/2020 |
| Scott Cheng |
6/5/2020 |
7/12/2020 |
7/29/2020 |
| Satiya Cheung |
6/5/2020 |
7/25/2020 |
8/27/2020 |
| Sarah Chin |
6/4/2020 |
6/29/2020 |
8/29/2020 |
| Sara Chomitz |
6/13/2020 |
6/27/2020 |
8/17/2020 |
| Samuel Chou |
6/30/2020 |
7/6/2020 |
8/4/2020 |
| Sang Chou |
6/18/2020 |
6/28/2020 |
8/1/2020 |
| Sangjo Chou |
5/14/2020 |
7/6/2020 |
8/2/2020 |
| Samantha Chu |
6/3/2020 |
7/7/2020 |
8/20/2020 |
| Samaneh Chua |
6/21/2020 |
6/20/2020 |
7/22/2020 |
| Salas Chung |
6/6/2020 |
7/25/2020 |
8/23/2020 |
| Saeed Cilento |
5/2/2020 |
7/24/2020 |
8/26/2020 |
Click here to expand the table with another date format...Registration Date,First Transaction,Last Transaction,,MM d, yy1457700529656_96873132Point (.)
| Customer |
Registration Date |
First Transaction |
Last Transaction |
| Stephen Chan |
May 26, 2020 |
July 29, 2020 |
July 19, 2020 |
| Steven Chan |
June 5, 2020 |
July 29, 2020 |
August 14, 2020 |
| Sompop Chang |
June 16, 2020 |
July 21, 2020 |
July 25, 2020 |
| Spencer Chang |
June 23, 2020 |
July 13, 2020 |
August 11, 2020 |
| Stephanie Chang |
June 14, 2020 |
July 23, 2020 |
August 9, 2020 |
| Simond Chat |
May 18, 2020 |
June 20, 2020 |
August 20, 2020 |
| Simon Chau |
June 17, 2020 |
July 19, 2020 |
July 27, 2020 |
| Shiv Chayet |
May 4, 2020 |
July 17, 2020 |
July 20, 2020 |
| Shannon Cheesebro |
May 11, 2020 |
July 4, 2020 |
August 20, 2020 |
| Scott Chen |
May 3, 2020 |
July 27, 2020 |
August 2, 2020 |
| Se Chen |
June 21, 2020 |
July 11, 2020 |
July 26, 2020 |
| Sean Chen |
June 9, 2020 |
July 21, 2020 |
July 20, 2020 |
| Seth Chen |
May 30, 2020 |
July 15, 2020 |
August 12, 2020 |
| Sevag Chen |
May 15, 2020 |
June 24, 2020 |
July 20, 2020 |
| Scott Cheng |
June 5, 2020 |
July 12, 2020 |
July 29, 2020 |
| Satiya Cheung |
June 5, 2020 |
July 25, 2020 |
August 27, 2020 |
| Sarah Chin |
June 4, 2020 |
June 29, 2020 |
August 29, 2020 |
| Sara Chomitz |
June 13, 2020 |
June 27, 2020 |
August 17, 2020 |
| Samuel Chou |
June 30, 2020 |
July 6, 2020 |
August 4, 2020 |
| Sang Chou |
June 18, 2020 |
June 28, 2020 |
August 1, 2020 |
| Sangjo Chou |
May 14, 2020 |
July 6, 2020 |
August 2, 2020 |
| Samantha Chu |
June 3, 2020 |
July 7, 2020 |
August 20, 2020 |
| Samaneh Chua |
June 21, 2020 |
June 20, 2020 |
July 22, 2020 |
| Salas Chung |
June 6, 2020 |
July 25, 2020 |
August 23, 2020 |
| Saeed Cilento |
May 2, 2020 |
July 24, 2020 |
August 26, 2020 |
Filtering Number and Date Ranges
false,false,false,falseDynamic AscendingTransaction DateCustomer TypeFiltration panelPoint (.)Customer Type‚Transaction Amount‚Transaction Date‚Status,500->800,1598918400000->1600128000000,150,150m/d/yyTransaction Amount1457700535201_-910710222Status0,1,2,3
| Transaction ID |
Transaction Amount |
Fee Amount |
Transaction Type |
Service Agent |
Transaction Date |
Customer Type |
Status |
| 508408554 |
827.25 |
6.62 |
Loan Settlement |
G.Sanchez |
9/1/2020 |
Personal |
|
| 534260583 |
574.38 |
10.34 |
Loan Settlement |
A.Stone |
9/4/2020 |
Personal |
|
| 520498528 |
53.13 |
0.21 |
Mortgage Loans |
G.Sanchez |
9/3/2020 |
Business |
|
| 530181712 |
1162.75 |
16.28 |
Mortgage Loans |
P.Jacobs |
9/28/2020 |
Mixed |
|
| 551886740 |
270.75 |
0.54 |
Mortgage Loans |
C.Palmer |
9/21/2020 |
Business |
|
| 516643388 |
167.13 |
2.34 |
Loan Settlement |
A.Stone |
9/11/2020 |
Personal |
|
| 513935349 |
617 |
9.87 |
Mortgage Loans |
P.Jacobs |
9/18/2020 |
Personal |
|
| 553528808 |
685.25 |
1.37 |
Check Cashing |
P.Jacobs |
9/22/2020 |
Personal |
|
| 574267928 |
1066.38 |
6.4 |
Loan Settlement |
A.Stone |
9/5/2020 |
Business |
|
| 583992263 |
1221.88 |
9.78 |
Check Cashing |
P.Jacobs |
9/13/2020 |
Business |
|
| 512297002 |
840.38 |
1.68 |
Check Cashing |
G.Sanchez |
9/15/2020 |
Business |
|
| 563910595 |
58.75 |
0.12 |
Loan Settlement |
P.Jacobs |
9/12/2020 |
Mixed |
|
| 524635346 |
1030.38 |
12.36 |
Mortgage Loans |
G.Sanchez |
9/28/2020 |
Mixed |
|
| 539707818 |
1134.25 |
9.07 |
Money Deposit |
P.Jacobs |
9/8/2020 |
Personal |
|
| 541299507 |
337 |
3.37 |
Check Cashing |
G.Sanchez |
9/26/2020 |
Personal |
|
| 514145873 |
1160.13 |
2.32 |
Check Cashing |
P.Jacobs |
9/5/2020 |
Business |
|
| 581221815 |
318.5 |
5.73 |
Mortgage Loans |
C.Palmer |
9/3/2020 |
Personal |
|
| 532053909 |
1109.25 |
4.44 |
Check Cashing |
P.Jacobs |
9/6/2020 |
Personal |
|
| 595986162 |
881.13 |
1.76 |
Money Deposit |
P.Jacobs |
9/21/2020 |
Mixed |
|
| 567139520 |
190.75 |
1.14 |
Money Deposit |
P.Jacobs |
9/28/2020 |
Business |
|
| 567077582 |
1053.38 |
4.21 |
Loan Settlement |
P.Jacobs |
9/7/2020 |
Mixed |
|
| 526897721 |
622.25 |
2.49 |
Check Cashing |
P.Jacobs |
9/6/2020 |
Business |
|
| 520309987 |
482.25 |
8.68 |
Loan Settlement |
A.Stone |
9/13/2020 |
Personal |
|
| 553400915 |
1100.38 |
13.2 |
Check Cashing |
A.Stone |
9/17/2020 |
Personal |
|
| 591367710 |
348.75 |
2.09 |
Mortgage Loans |
G.Sanchez |
9/28/2020 |
Business |
|
| 581866954 |
26 |
0.42 |
Money Deposit |
G.Sanchez |
9/12/2020 |
Personal |
|
| 510321813 |
85 |
1.19 |
Check Cashing |
G.Sanchez |
9/24/2020 |
Business |
|
| 532599942 |
13.25 |
0.21 |
Loan Settlement |
A.Stone |
9/11/2020 |
Mixed |
|
| 576785158 |
1181.88 |
18.91 |
Check Cashing |
A.Stone |
9/26/2020 |
Business |
|
| 591279818 |
558.25 |
3.35 |
Check Cashing |
G.Sanchez |
9/5/2020 |
Business |
|
| 565175201 |
1208.75 |
7.25 |
Check Cashing |
C.Palmer |
9/2/2020 |
Mixed |
|
| 579628337 |
742.25 |
8.91 |
Mortgage Loans |
C.Palmer |
9/15/2020 |
Personal |
|
| 562868874 |
811.5 |
4.87 |
Money Deposit |
A.Stone |
9/12/2020 |
Personal |
|
| 547044130 |
306.13 |
1.84 |
Loan Settlement |
G.Sanchez |
9/7/2020 |
Business |
|
| 563739855 |
126.5 |
0.25 |
Check Cashing |
G.Sanchez |
9/28/2020 |
Mixed |
|
| 530009120 |
972.38 |
5.83 |
Money Deposit |
G.Sanchez |
9/22/2020 |
Mixed |
|
| 577909854 |
318.25 |
1.91 |
Loan Settlement |
C.Palmer |
9/14/2020 |
Mixed |
|
| 580475812 |
220.88 |
1.77 |
Check Cashing |
P.Jacobs |
9/11/2020 |
Personal |
|
| 552303738 |
845.63 |
13.53 |
Money Deposit |
A.Stone |
9/23/2020 |
Business |
|
| 553217625 |
763.5 |
9.16 |
Check Cashing |
A.Stone |
9/26/2020 |
Business |
|
| 562886027 |
461.63 |
3.69 |
Mortgage Loans |
C.Palmer |
9/25/2020 |
Personal |
|
| 577128209 |
81.88 |
0.49 |
Mortgage Loans |
A.Stone |
9/9/2020 |
Mixed |
|
| 571897241 |
273.75 |
0.55 |
Mortgage Loans |
P.Jacobs |
9/8/2020 |
Mixed |
|
| 543946203 |
521.13 |
2.08 |
Money Deposit |
P.Jacobs |
9/4/2020 |
Mixed |
|
| 512625019 |
763.38 |
6.11 |
Check Cashing |
P.Jacobs |
9/25/2020 |
Business |
|
| 531366991 |
1070.38 |
17.13 |
Loan Settlement |
C.Palmer |
9/14/2020 |
Mixed |
|
| 528378248 |
135.13 |
2.16 |
Mortgage Loans |
C.Palmer |
9/9/2020 |
Mixed |
|
| 569125972 |
482.5 |
2.9 |
Loan Settlement |
G.Sanchez |
9/6/2020 |
Business |
|
| 544092123 |
186.63 |
2.61 |
Mortgage Loans |
G.Sanchez |
9/24/2020 |
Mixed |
|
| 535664888 |
849.88 |
15.3 |
Money Deposit |
P.Jacobs |
9/12/2020 |
Personal |
|
| 512597600 |
160.63 |
2.25 |
Check Cashing |
A.Stone |
9/7/2020 |
Mixed |
|
| 524747512 |
646.5 |
1.29 |
Loan Settlement |
G.Sanchez |
9/6/2020 |
Personal |
|
| 517188341 |
748.75 |
4.49 |
Money Deposit |
G.Sanchez |
9/3/2020 |
Business |
|
| 552579946 |
1090 |
17.44 |
Money Deposit |
P.Jacobs |
9/20/2020 |
Mixed |
|
| 553750716 |
185.75 |
2.97 |
Money Deposit |
P.Jacobs |
9/15/2020 |
Mixed |
|
| 553373674 |
1136.5 |
20.46 |
Check Cashing |
P.Jacobs |
9/18/2020 |
Mixed |
|
| 515533717 |
1188.5 |
7.13 |
Money Deposit |
C.Palmer |
9/23/2020 |
Mixed |
|
| 578660434 |
573.63 |
9.18 |
Loan Settlement |
C.Palmer |
9/4/2020 |
Personal |
|
| 547707459 |
59.5 |
0.36 |
Mortgage Loans |
G.Sanchez |
9/4/2020 |
Personal |
|
| 579476961 |
950.38 |
13.31 |
Mortgage Loans |
A.Stone |
9/17/2020 |
Business |
|
| 587670385 |
821.88 |
9.86 |
Check Cashing |
P.Jacobs |
9/16/2020 |
Business |
|
| 558417890 |
615.38 |
3.69 |
Loan Settlement |
P.Jacobs |
9/10/2020 |
Mixed |
|
| 578207183 |
595.63 |
9.53 |
Mortgage Loans |
A.Stone |
9/17/2020 |
Business |
|
| 564545053 |
48.13 |
0.29 |
Money Deposit |
G.Sanchez |
9/29/2020 |
Business |
|
| 582529157 |
711.63 |
12.81 |
Mortgage Loans |
C.Palmer |
9/27/2020 |
Personal |
|
| 578186894 |
517.25 |
3.1 |
Money Deposit |
P.Jacobs |
9/20/2020 |
Business |
|
| 597791001 |
375.25 |
5.25 |
Loan Settlement |
G.Sanchez |
9/22/2020 |
Business |
|
| 560812974 |
1082.88 |
12.99 |
Mortgage Loans |
G.Sanchez |
9/5/2020 |
Business |
|
| 587231094 |
695.75 |
1.39 |
Loan Settlement |
C.Palmer |
9/22/2020 |
Personal |
|
| 508335556 |
763.63 |
7.64 |
Loan Settlement |
A.Stone |
9/24/2020 |
Personal |
|
| 500765585 |
961.88 |
17.31 |
Mortgage Loans |
P.Jacobs |
9/8/2020 |
Business |
|
| 526360464 |
484.75 |
2.91 |
Mortgage Loans |
A.Stone |
9/11/2020 |
Personal |
|
| 514345897 |
389.5 |
3.12 |
Loan Settlement |
C.Palmer |
9/5/2020 |
Personal |
|
| 593253758 |
1175.75 |
18.81 |
Loan Settlement |
C.Palmer |
9/8/2020 |
Personal |
|
| 557314958 |
1142.63 |
4.57 |
Money Deposit |
A.Stone |
9/8/2020 |
Personal |
|
| 534334315 |
825.13 |
11.55 |
Money Deposit |
G.Sanchez |
9/29/2020 |
Business |
|
| 571884914 |
640.5 |
7.69 |
Mortgage Loans |
G.Sanchez |
9/22/2020 |
Business |
|
| 549295540 |
904.88 |
7.24 |
Loan Settlement |
G.Sanchez |
9/2/2020 |
Mixed |
|
| 544394436 |
607.88 |
1.22 |
Money Deposit |
P.Jacobs |
9/16/2020 |
Mixed |
|
| 534982083 |
896.63 |
1.79 |
Check Cashing |
A.Stone |
9/10/2020 |
Mixed |
|
| 505391036 |
931.88 |
3.73 |
Mortgage Loans |
G.Sanchez |
9/15/2020 |
Personal |
|
| 522446349 |
1243.13 |
7.46 |
Mortgage Loans |
P.Jacobs |
9/18/2020 |
Personal |
|
| 562409021 |
740.13 |
2.96 |
Check Cashing |
A.Stone |
9/11/2020 |
Mixed |
|
| 517694745 |
236.75 |
3.31 |
Money Deposit |
G.Sanchez |
9/18/2020 |
Mixed |
|
| 539435352 |
619.75 |
1.24 |
Mortgage Loans |
A.Stone |
9/17/2020 |
Personal |
|
| 507692317 |
501 |
8.02 |
Check Cashing |
C.Palmer |
9/17/2020 |
Business |
|
| 589209610 |
534.13 |
7.48 |
Check Cashing |
C.Palmer |
9/9/2020 |
Personal |
|
| 587368416 |
369 |
0.74 |
Check Cashing |
G.Sanchez |
9/30/2020 |
Personal |
|
| 521423405 |
101.25 |
1.01 |
Mortgage Loans |
A.Stone |
9/2/2020 |
Mixed |
|
| 504460550 |
364.38 |
5.83 |
Loan Settlement |
C.Palmer |
9/18/2020 |
Business |
|
| 570096562 |
363.5 |
2.91 |
Money Deposit |
C.Palmer |
9/30/2020 |
Mixed |
|
| 534671616 |
251.38 |
2.01 |
Mortgage Loans |
G.Sanchez |
9/2/2020 |
Mixed |
|
| 507687895 |
1148.13 |
16.07 |
Check Cashing |
G.Sanchez |
9/6/2020 |
Personal |
|
| 590326099 |
645.5 |
2.58 |
Money Deposit |
G.Sanchez |
9/6/2020 |
Business |
|
| 573827520 |
27.38 |
0.27 |
Loan Settlement |
C.Palmer |
9/22/2020 |
Mixed |
|
| 521919444 |
461.25 |
0.92 |
Loan Settlement |
P.Jacobs |
9/25/2020 |
Mixed |
|
| 539885482 |
386.25 |
1.55 |
Check Cashing |
P.Jacobs |
9/18/2020 |
Business |
|
| 504754478 |
822.25 |
9.87 |
Loan Settlement |
G.Sanchez |
9/13/2020 |
Personal |
|
| 571026788 |
1097.75 |
17.56 |
Check Cashing |
A.Stone |
9/5/2020 |
Mixed |
|
| 505443359 |
913.63 |
5.48 |
Check Cashing |
G.Sanchez |
9/18/2020 |
Mixed |
|