krisalis903
New Member
- Joined
- Feb 22, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello, I'm still fairly new to using Excel and Access and I have some data that I'm not quite sure how to transform. Essentially what I have here is a data dump of all active Salesforce cases including last modified dates. I need to be able to analyze the latest modified date for all our open cases. I think if I can somehow automatically copy the row with the newest last modified date for each case and paste that into a new sheet, I'd at least have something I can work with. However I am open to ideas. Any thoughts on how to clean this up? The sheet is thousands of lines long, but I've created a mini sheet with just a portion so you can see what I'm working with.
Sample Data.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Case Number | Age | Status | Date/Time Opened | IRL AGE | Case Last Modified Alias | Case Comment Last Modified Date | ||
2 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 8/7/2022 11:39 PM | ||
3 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 11/9/2022 2:43 PM | ||
4 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 11/10/2022 11:40 PM | ||
5 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 8/4/2022 5:40 PM | ||
6 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 11/4/2022 12:46 AM | ||
7 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 7/15/2022 3:14 AM | ||
8 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 1/19/2023 6:48 PM | ||
9 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 2/8/2023 11:48 PM | ||
10 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 12/13/2022 4:24 PM | ||
11 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 12/13/2022 4:32 PM | ||
12 | 02499762 | 5723 | Pending Agent/Seller Response | 6/29/2022 2:02 AM | 238.45 | vmeht | 12/26/2022 4:21 AM | ||
13 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 1/27/2023 3:57 PM | ||
14 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 1/28/2023 3:20 AM | ||
15 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 12/9/2022 10:02 PM | ||
16 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 12/9/2022 12:24 PM | ||
17 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 12/17/2022 5:42 PM | ||
18 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 12/20/2022 4:47 AM | ||
19 | 02805257 | 2069 | Pending Agent/Seller Response | 11/28/2022 6:25 AM | 86.22 | vmeht | 12/26/2022 12:52 AM | ||
20 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 2/16/2023 5:42 PM | ||
21 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 2/17/2023 3:22 AM | ||
22 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 2/20/2023 9:58 PM | ||
23 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 1/25/2023 2:57 PM | ||
24 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 1/12/2023 8:13 PM | ||
25 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 12/9/2022 10:08 PM | ||
26 | 02807448 | 2046 | Pending Agent/Seller Response | 11/29/2022 6:11 AM | 85.23 | vmeht | 12/9/2022 12:22 PM | ||
27 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 2/13/2023 12:12 PM | ||
28 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 8/10/2022 4:42 PM | ||
29 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 9/2/2022 1:07 PM | ||
30 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 9/8/2022 3:42 PM | ||
31 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 10/13/2022 12:13 PM | ||
32 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 11/10/2022 12:57 PM | ||
33 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 8/5/2022 11:15 AM | ||
34 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 1/10/2023 1:26 PM | ||
35 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 12/14/2022 1:39 PM | ||
36 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 12/16/2022 8:02 AM | ||
37 | 02555341 | 4923 | Pending Agent/Seller Response | 8/1/2022 9:35 AM | 205.14 | mwill | 12/16/2022 1:30 PM | ||
OPEN SEO Content Cases with Las |