Productivity Tools

**Unique Count in Excel** ========================== There are several ways to get a unique count in Excel, and the best approach depends on your specific data and Excel version. Here are a few methods: ### **Method 1: Using `COUNTIF` and `SUMPRODUCT` (Excel 2010 and later)** Suppose you have a list of values in column A, and you want to count the unique values. ```excel =SUMPRODUCT(1/COUNTIF(A:A, A:A)) ``` **How it works:** 1. `COUNTIF(A:A, A:A)` counts the occurrences of each value in column A. 2. `1/COUNTIF(A:A, A:A)` converts the counts to reciprocals (1/count). This will give 1 for unique values and a fraction for duplicate values. 3. `SUMPRODUCT` sums up these reciprocals, effectively counting the unique values. ### **Method 2: Using `UNIQUE` and `COUNT` (Excel 2019 and later)** If you're using Excel 2019 or later, you can use the `UNIQUE` function. ```excel =COUNT(UNIQUE(A:A)) ``` **How it works:** 1. `UNIQUE(A:A)` returns an array of unique values from column A. 2. `COUNT` counts the number of values in this array. ### **Method 3: Using PivotTable (All Excel versions)** You can also use a PivotTable to get a unique count. 1. Select your data range (e.g., A1:A100). 2. Go to "Insert" > "PivotTable". 3. Drag the field you want to count (e.g., column A) to the "Values" area. 4. Right-click on the field in the "Values" area and select "Value Field Settings". 5. Choose "Count distinct records" or "Distinct Count" (depending on your Excel version). ### **Method 4: Using `FILTERXML` and `COUNT` (Excel 2010 and later)** This method is useful when you have a list of values with duplicates. ```excel =COUNT(FILTERXML("<a><b>" & SUBSTITUTE(A:A, ",", "</b><b>") & "</b></a>", "//b[not(preceding-sibling::b/ text()[.=current()/text()])])) ``` However **It assumes values are comma-separated** ### **Recommendation** * For most cases, **Method 1** (`SUMPRODUCT` and `COUNTIF`) is a good choice, as it's compatible with older Excel versions. * If you're using Excel 2019 or later, **Method 2** (`UNIQUE` and `COUNT`) is a more straightforward and efficient approach. =SUMPRODUCT(1/COUNTIF(A:A, A:A))

**Weekly Team Meetings** ====================== ### 1. Agenda * **Meeting Objectives:** + What do we want to achieve in this meeting? + What are the key discussion points? * **Proposed Agenda Items:** + [Insert topics for discussion] ### 2. Attendees * **List of Attendees:** + [Insert names and roles of team members] ### 3. Action Items * **Tasks Assigned:** + [Insert tasks with corresponding team members and due dates] * **Responsibilities:** + [Insert any additional responsibilities or follow-up tasks] ### 4. Notes * **Meeting Summary:** + [Insert brief summary of key points discussed] * **Discussion Highlights:** + [Insert notable quotes, decisions, or action items] ### 5. Next Steps * **Action Item Tracker:** + [Insert table to track progress of assigned tasks] * **Follow-up Questions:** + [Insert any questions or clarifications needed] **Additional Tips:** * Use this template as a starting point and customize it according to your team's specific needs. * Assign a meeting leader to facilitate the discussion and ensure all objectives are met. * Encourage active participation and open communication among team members. * Set reminders for follow-up tasks and deadlines to ensure timely completion. * Review and update the action item tracker regularly to track progress and identify areas for improvement. **Notion Template Suggestions:** * Use a Kanban board to visualize and track action items and their progress. * Create a table with columns for tasks, assignees, due dates, and status to easily track action items. * Add a ' Done' page to showcase completed tasks and celebrate team achievements. * Create a 'Meeting Archives' page to store and reference past meeting notes and action items.