Good Morning,
I am working with an extracted file from SalesForce.com which has been saved as an .xlsx file. In this file I have multiple columns with a variety of information related to customer data. As the customer, which has a unique identifier (Column A) repeats, I am looking for the latest activity associated with that customer (Column C) only. What formula is best to use to make this happen?
You could sort the data Z-A on the activity date column then a lookup against an individual list of customer numbers will give you the most recent date.
OR you could look up how to make a "MAXIF" array formula and use that approach.
Without sample data it's difficult to provide a more specific solution.
BSB
Here is a sampling of the data:
ID SFDC Last Modified Date Last Activity Date Account Name
00120000013v2sh 9/16/2014 9/15/2014 Customer A
00120000013v2sh 9/16/2014 9/15/2014 Customer A
00120000013v2sh 9/15/2014 9/15/2014 Customer A
00120000013v2sh 2/7/2014 2/6/2014 Customer A
00120000013v2sh 3/17/2014 4/9/2014 Customer A
00120000013v2sh 3/6/2014 3/13/2014 Customer A
I would only like to see the record(s) for 9/15/2014 while eliminating from view the other dates.
as already offered you in #2
=MAX(C2:C7)
but probably it will be differant, as I suppose you also want to use the costumer in your information.
In that case you have to add an excel file without confidential information.
Please also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello - Maybe this is helpful
ID SFDC Date Account Name City
00120000013v2sh 9/15/2014 Company A BELLEVILLE
00120000013v2sh 9/14/2014 Company A BELLEVILLE
00120000013v2sh 9/13/2014 Company A BELLEVILLE
00120000013v2sh 2/6/2014 Company A BELLEVILLE
00120000013v2sh 4/9/2014 Company A BELLEVILLE
00120000013v2sh 3/13/2014 Company A BELLEVILLE
00120000013v3iD 3/27/2014 Company B Albuquerque
00120000013v3iD 12/17/2014 Company B Albuquerque
00120000013v3iD 1/28/2015 Company B Albuquerque
Desired Result would show the following Show only the most recent (based on the date) activity for each unique ID in Column A
ID SFDC Date Account Name City
00120000013v2sh 9/15/2014 Company A BELLEVILLE
00120000013v3iD 1/28/2015 Company B Albuquerque[/CENTER][/CENTER]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks