suitable formula for Repeated item or name

[faziljm]

Hai,
I want suitable formula for repeated item or name. Eg: I entering sales details for customer date wise continually column down.
I sorted it customer wise in another sheet and I want, If I'm enter new customer, how to take automatically to shorted customer list.

 

[Oeldere]

You could use a pivot table for that kind of work.

 

[faziljm]

Thank you Very much and I'm searching formula for that, Eg: Isnumber with Index or match formular