Answers.Body: <p>Use search builder to search for all contacts with the activity field: activity date of "not null" and add them to new group "has activities". Use the include/exclude custom search to find any contact not in the "has activities group and add them to a new group "no activities".</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T17:01:57.103Z
Answers.Text: That's pretty good.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T16:20:38.193Z
Answers.LastActivityDate: 2020-03-04T16:20:38.193Z
Answers.UserDisplayName: Mick Kahn
Answers.Body: <p>You could export a list of contacts, export a list of activities, and then using vlookup() in excel find the rows in the contact list that do not appear in the list of activities.</p>
  
  <p>See e.g. <a href="https://www.extendoffice.com/documents/excel/3124-excel-compare-two-columns-for-missing-values.html#formula" rel="nofollow noreferrer">https://www.extendoffice.com/documents/excel/3124-excel-compare-two-columns-for-missing-values.html#formula</a> where it says "Compare two columns for (highlighting) missing values with formulas"</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T15:43:25.920Z
Answers.LastActivityDate: 2020-03-04T15:43:25.920Z
Answers.UserDisplayName: Demerit
Body: <p>I'm struggling to find a list of conatcts with no activity records, could someone help me on how to achieve this?</p>
  
Tags: <activity>
Title: How can I search contacts and run a report of contacts with no activity
ThreadText: # How can I search contacts and run a report of contacts with no activity
  
  (Asked by: username_0 on 2020-03-04)
  
  I'm struggling to find a list of conatcts with no activity records, could someone help me on how to achieve this?
  
  **Tags:** activity
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2020-03-04. Score: 4
  
  Use search builder to search for all contacts with the activity field: activity date of "not null" and add them to new group "has activities". Use the include/exclude custom search to find any contact not in the "has activities group and add them to a new group "no activities".
  
  > **Comments:**
  > **username_2**: That's pretty good.  
  
  ---
  
  ### Answer by username_2 on 2020-03-04. Score: 0
  
  You could export a list of contacts, export a list of activities, and then using vlookup() in excel find the rows in the contact list that do not appear in the list of activities.
  
  See e.g. <https://www.extendoffice.com/documents/excel/3124-excel-compare-two-columns-for-missing-values.html#formula> where it says "Compare two columns for (highlighting) missing values with formulas"
  
  
  ---
  
  