How can i generate this report?

[sadrisalihu]

Who can help me, if i have this table:

How to count only last date with red rows and get this result:

Get and count only last Entry Date base on item.

[vishsaggi]

Can you share your excel sample sheet to work on?

[sadrisalihu]

Hello Vishwarath Nagaraju

Atteched you have simple data.

Thanks for you help.

[sadrisalihu]

I need to use

FirstSortedValue() function, but i don't now how to use it.

[vishsaggi]

Will look into this tomorrow.