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..

[TABLE="width: 261"]
<tbody>[TR]
[TD]Login ID[/TD]
[TD]DOJ[/TD]
[TD]BU[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]25-Apr-19[/TD]
[TD]HR[/TD]
[/TR]
[TR]
[TD]Nathan[/TD]
[TD]25-Apr-19[/TD]
[TD]IT[/TD]
[/TR]
[TR]
[TD]Adeel[/TD]
[TD]26-Apr-19[/TD]
[TD]Finance[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]25-Apr-19[/TD]
[TD]IT[/TD]
[/TR]
[TR]
[TD]Jacob[/TD]
[TD]26-Apr-19[/TD]
[TD]Finance[/TD]
[/TR]
[TR]
[TD]Adeel[/TD]
[TD]22-Apr-19[/TD]
[TD]Finance[/TD]
[/TR]
[TR]
[TD]Nathan[/TD]
[TD]26-Apr-19[/TD]
[TD]IT[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]26-Apr-19[/TD]
[TD]HR[/TD]
[/TR]
</tbody>[/TABLE]

----

User count

 

[alansidman]

A pivot table like below?

Data Range
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][td]

I​

[/td][td]

J​

[/td][/tr]
[tr][td]

1​

[/td][td]

Login ID​

[/td][td]

DOJ​

[/td][td]

BU​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr][td]

2​

[/td][td]

David​

[/td][td]

4/25/2019​

[/td][td]

HR​

[/td][td]

​

[/td][td]

Count of BU​

[/td][td]

Login ID​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr][td]

3​

[/td][td]

Nathan​

[/td][td]

4/25/2019​

[/td][td]

IT​

[/td][td]

​

[/td][td]

DOJ​

[/td][td]

Adeel​

[/td][td]

David​

[/td][td]

Jacob​

[/td][td]

John​

[/td][td]

Nathan​

[/td][/tr]


[tr][td]

4​

[/td][td]

Adeel​

[/td][td]

4/26/2019​

[/td][td]

Finance​

[/td][td]

​

[/td][td]

4/22/2019​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr][td]

5​

[/td][td]

John​

[/td][td]

4/25/2019​

[/td][td]

IT​

[/td][td]

​

[/td][td]

4/25/2019​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

1​

[/td][td]

1​

[/td][/tr]


[tr][td]

6​

[/td][td]

Jacob​

[/td][td]

4/26/2019​

[/td][td]

Finance​

[/td][td]

​

[/td][td]

4/26/2019​

[/td][td]

1​

[/td][td]

1​

[/td][td]

1​

[/td][td]

​

[/td][td]

1​

[/td][/tr]


[tr][td]

7​

[/td][td]

Adeel​

[/td][td]

4/22/2019​

[/td][td]

Finance​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr][td]

8​

[/td][td]

Nathan​

[/td][td]

4/26/2019​

[/td][td]

IT​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr][td]

9​

[/td][td]

David​

[/td][td]

4/26/2019​

[/td][td]

HR​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr][td]

10​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table]

 

[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.