Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,584
- Office Version
- 365
- 2013
- Platform
- Windows
Below is raw data
Criteria which meets ID number in column A of raw data, I want all below IDs data to a separate tab using Excel 2013
Dunkin New Import - Copy.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Profit Center | Invoice Number | Invoice Date | Vendor | Description | Vendor Invoice Number | Invoice Amount | Due Date | Invoice Balance | Payment Status | Payment Date | Recipient Email | Hold Status | ||
2 | 310296 | 1219834 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-310296 | $1.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
3 | 358317 | 1220335 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-358317 | $1.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | ms@goldendonut.net | No | ||
4 | 357913 | 1220635 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-357913 | $1.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
5 | 354525 | 1221587 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-354525 | $1.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
6 | 307881 | 1218019 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-307881 | $2.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
7 | 310277 | 1219827 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-310277 | $2.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
8 | 349930 | 1220835 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-349930 | $3.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
9 | 359244 | 1220999 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-359244 | $4.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
10 | 359242 | 1220998 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-359242 | $4.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
11 | 363054 | 1220348 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-363054 | $7.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Hk@goldendonut.net | No | ||
12 | 332011 | 1219298 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-332011 | $8.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
13 | 346880 | 1219911 | 2/14/2024 | DUNKIN' BRANDS BILLING | DD JICF PAPERICON | DDCHARITY-14FEB24-346880 | $12.00 | 2/24/2024 | $0.00 | Paid | 2/27/2024 | Ms@goldendonut.net | No | ||
14 | 359739 | 1217724 | 2/9/2024 | DUNKIN' BRANDS BILLING | DD Pint-Size Charitable Contribution | BRCHARITY-09FEB24-359739 | $17.00 | 2/19/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
15 | 359242 | 11887729 | 2/5/2024 | NCR CORPORATION | DD NCR Regular | 300409021 | $20.24 | 2/15/2024 | $0.00 | Paid | 2/15/2024 | Ms@goldendonut.net | No | ||
16 | 345213 | 11887803 | 2/5/2024 | NCR CORPORATION | DD NCR Regular | 300408624 | $48.02 | 2/15/2024 | $0.00 | Paid | 2/15/2024 | Ms@goldendonut.net | No | ||
17 | 307881 | 11884077 | 2/2/2024 | COATES US INC | DD COATES QTR | 24118451 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Ms@goldendonut.net | No | ||
18 | 358317 | 11886055 | 2/2/2024 | COATES US INC | DD COATES QTR | 24119554 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | ms@goldendonut.net | No | ||
19 | 359739 | 11884743 | 2/2/2024 | COATES US INC | DD COATES QTR | 24118661 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Ms@goldendonut.net | No | ||
20 | 357913 | 11885191 | 2/2/2024 | COATES US INC | DD COATES QTR | 24119329 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Ms@goldendonut.net | No | ||
21 | 359244 | 11885923 | 2/2/2024 | COATES US INC | DD COATES QTR | 24119544 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Ms@goldendonut.net | No | ||
22 | 359242 | 11885911 | 2/2/2024 | COATES US INC | DD COATES QTR | 24119519 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Ms@goldendonut.net | No | ||
23 | 363054 | 11885468 | 2/2/2024 | COATES US INC | DD COATES QTR | 24119376 | $78.00 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Hk@goldendonut.net | No | ||
24 | 349930 | 11883424 | 2/2/2024 | COATES US INC | DD COATES QTR | 24120834 | $82.68 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | Ms@goldendonut.net | No | ||
25 | 346880 | 11905680 | 2/26/2024 | NCR CORPORATION | DD NCR Regular | 100676335 | $118.52 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
26 | 358317 | 11888980 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-358317 | $159.00 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | ms@goldendonut.net | No | ||
27 | 331152 | 11892022 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-331152 | $207.46 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
28 | 335411 | 11892206 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-335411 | $207.46 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
29 | 345213 | 11892473 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-345213 | $207.46 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
30 | 349930 | 11893173 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-349930 | $207.46 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
31 | 354525 | 11888794 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-354525 | $207.46 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
32 | 346880 | 11892720 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-346880 | $208.18 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
33 | 306008 | 11888983 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-306008 | $208.28 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
34 | 330704 | 11893334 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-330704 | $208.65 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
35 | 310277 | 11893241 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-310277 | $208.65 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
36 | 310092 | 11889084 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-310092 | $208.65 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
37 | 363054 | 11888711 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-363054 | $223.46 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Hk@goldendonut.net | No | ||
38 | 330524 | 11893332 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-330524 | $232.57 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
39 | 310092 | 11908833 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201053568 | $233.08 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
40 | 363054 | 11909705 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201052759 | $248.89 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Hk@goldendonut.net | No | ||
41 | 310296 | 11893243 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-310296 | $251.24 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
42 | 332011 | 11892111 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-332011 | $251.24 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
43 | 307881 | 11893062 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-307881 | $254.74 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
44 | 359244 | 11889205 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-359244 | $255.52 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
45 | 359739 | 11888629 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-359739 | $256.86 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
46 | 359242 | 11889204 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-359242 | $256.86 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
47 | 330704 | 11904605 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201051805 | $269.61 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
48 | 363625 | 11885694 | 2/2/2024 | COATES US INC | DD COATES QTR | 24120977 | $276.06 | 2/12/2024 | $0.00 | Paid | 2/13/2024 | billing@goldendonut.net | No | ||
49 | 357913 | 11888937 | 2/6/2024 | COMCAST HOLDINGS CORPORATION | Store Network Comcast Monthly | 193415170-357913 | $281.87 | 2/16/2024 | $0.00 | Paid | 2/20/2024 | Ms@goldendonut.net | No | ||
50 | 310277 | 11908321 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201053975 | $381.80 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
51 | 331152 | 11906878 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201056980 | $396.93 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
52 | 358317 | 11908763 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201054441 | $401.70 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | ms@goldendonut.net | No | ||
53 | 359242 | 11912467 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201059679 | $404.34 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
54 | 345213 | 11906879 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201056981 | $421.00 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
55 | 357913 | 11910545 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201055773 | $430.42 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
56 | 346880 | 11905512 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201054101 | $446.86 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
57 | 349930 | 11904228 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201060827 | $447.98 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
58 | 306008 | 11911840 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201059035 | $466.06 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
59 | 354525 | 11910755 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201056425 | $475.26 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
60 | 335411 | 11905206 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201053216 | $487.51 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
61 | 332011 | 11905207 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201053217 | $493.51 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
62 | 359244 | 11909993 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201056288 | $500.62 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
63 | 310296 | 11905208 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201053218 | $518.26 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
64 | 359739 | 11912503 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201060847 | $547.61 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
65 | 330524 | 11905209 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201053219 | $562.68 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
66 | 307881 | 11906876 | 2/26/2024 | NCR CORPORATION | DD NCR Quarterly | 201056978 | $592.86 | 3/7/2024 | $0.00 | Paid | 3/7/2024 | Ms@goldendonut.net | No | ||
67 | 346880 | 11887987 | 2/5/2024 | NCR CORPORATION | DD NCR Regular | 100672607 | $7,160.96 | 2/15/2024 | $0.00 | Paid | 2/15/2024 | Ms@goldendonut.net | No | ||
68 | 331152 | 11902344 | 2/23/2024 | COATES US INC | DD COATES REG | 24123700 | $22,600.25 | 3/4/2024 | $0.00 | Paid | 3/5/2024 | Ms@goldendonut.net | No | ||
Raw Data |
Criteria which meets ID number in column A of raw data, I want all below IDs data to a separate tab using Excel 2013
Dunkin New Import - Copy.xlsx | |||
---|---|---|---|
O | |||
2 | 359739 | ||
3 | 359739 | ||
4 | 363054 | ||
5 | 357913 | ||
6 | 306008 | ||
7 | 354525 | ||
8 | 359242 | ||
9 | 310092 | ||
10 | 358317 | ||
11 | 359244 | ||
12 | 363625 | ||
Raw Data |