Forum Discussion

Copper Contributor

Nov 02, 2017

Counting words in one column based on dates in another column.

Hi Everyone, I am looking for help coming up with a formula to do the following... In the A column I have a clients status which is either "Completed", "AMA", or "Admin' In the B column I ha...

Formulas & Functions

Diamond Contributor

Nov 02, 2017

Hi Matt,

Did you try PivotTable?

kellymuzy
Copper Contributor
Mar 29, 2019
SergeiBaklan
I stumbled upon this discussion when trying to solve a similar issue and pivot tables completely changed everything for me. I had a little bit of time to understand the basics and I can't believe I hadn't been using them all along. Thank you for your input on this question!
- SergeiBaklan
  Diamond Contributor
  Mar 29, 2019
  kellymuzy , glad it helped
Matt Walje
Copper Contributor
Nov 02, 2017
Hi Sergei,

No I have not. I am rather new to excel and am not familiar with Pivot Tables or how they work. Can you provide any instructions on how to use one for the particular problem.

Thanks,
Matt
- SergeiBaklan
  Diamond Contributor
  Nov 02, 2017
  Matt,
  
  First two links I found with PivotTable basics
  https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-A9A84538-BFE9-40A9-A8E9-F99134456576
  
  http://www.excel-easy.com/data-analysis/pivot-tables.html,
  
  google will give much more.
  
  For your case
  Better if you work with Excel Tables, if not the range works as well. Select one which is with your data,
  in ribbon Insert->Pivot Table.
  PivotTable pane will appear, add Date to rows, Status to Columns and Values. Result looks like
  
  After that is adjusting - how to group dates, how to design the table.
  - Deleted
    Nov 03, 2017
    Hi Segey and Matt
    why not use countifs?
    
    Yossi

Resources