title: Please can I get some guidance on techniques using the Unique Function
body: <p>To clarify, I will attack the code myself, however, it's the order and techniques to do this I need some guidance with.</p>
  <p>I have a table with 4 columns. The table has 40000 rows. The columns are Date, Name, location, company.
  I want to see how many times someone in the name column, appears in the database. I then want to apply a date filter to that. This I have managed to do if somewhat clunky.</p>
  <p>My problem is that the unique function only returns the name, when i apply it to that column. and i need it to return the location and company so that i can sort on that too. How would you go about doing that?</p>
  <p>I have used unique on the name column. It returns a spilled over list of about 4000 names. I then
  use this code =COUNTIFS(MyName,$A2,MyDate,&quot;&gt;=&quot;&amp;DATE(List!$D$2,List!M$4,List!M$5),MyDate,&quot;&lt;=&quot;&amp;DATE(List!$D$2,List!M$4,List!M$3)) to return the number of entries per month. A2 is the unique return column.</p>
  <p>Any guidance would be appreciated.</p>
  <p>Allan</p>