Formula in Google Sheet

What kind of report you want to prepare ?

Sir i have prepared daywise billing, despatch & collection report of marketing executives in a MASTER FILE.

I need individual marketing executive pending collection report with details.

I can share the file also

Thanking you

Vinod

You need the help of pivot tables.

If you could share, send the file in messages.