Count needed based on date

[VBABEGINER]

Hi team,

like below format, i do have lot number of records.

I want formula to calculate unique count, on every date from which department.. can anyone suggest on this..

Login ID	DOJ	BU
David	25-Apr-19	HR
Nathan	25-Apr-19	IT
Adeel	26-Apr-19	Finance
John	25-Apr-19	IT
Jacob	26-Apr-19	Finance
Adeel	22-Apr-19	Finance
Nathan	26-Apr-19	IT
David	26-Apr-19	HR

<tbody>
</tbody>

----

User count

 

[alansidman]

A pivot table like below?

Data Range

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
1​	Login ID​	DOJ​	BU​	​	​	​	​	​	​	​
2​	David​	4/25/2019​	HR​	​	Count of BU​	Login ID​	​	​	​	​
3​	Nathan​	4/25/2019​	IT​	​	DOJ​	Adeel​	David​	Jacob​	John​	Nathan​
4​	Adeel​	4/26/2019​	Finance​	​	4/22/2019​	1​	​	​	​	​
5​	John​	4/25/2019​	IT​	​	4/25/2019​	​	1​	​	1​	1​
6​	Jacob​	4/26/2019​	Finance​	​	4/26/2019​	1​	1​	1​	​	1​
7​	Adeel​	4/22/2019​	Finance​	​	​	​	​	​	​	​
8​	Nathan​	4/26/2019​	IT​	​	​	​	​	​	​	​
9​	David​	4/26/2019​	HR​	​	​	​	​	​	​	​
10​	​	​	​	​	​	​	​	​	​	​

 

[VBABEGINER]

Thats really nice.. so quick reply Sir..

But sir, can we have same using formula.. bcoz here is the board where we learned lot lot about formula's..

 

[alansidman]

Pivot tables are not generated with formulas. They are functions within Excel. Highlight the area in my example A1:C9. Click on insert-->Pivot Tables. Place the DOJ in rows. Login ID in columns. Count of BU in values. Fairly simple and easy to use. No formulas required.