How to get distinct column from source sheet into report.

Adnan Khan

I am creating a report. There is list of carriers in source sheet. I want to bring distinct carrier name into my report. I checked it is 126 in total. what I did I just copied and past distinct carrier but If someone add new it wont show I believe.

How can I bring in my report. If someone add a new carrier then it will add to my report in real time.

Thanks,

Heather Duff

Adnan,

Did you create a report or create a new sheet? It almost sounds like you created a new sheet. While there are ways to copy new rows to a new sheet, it may be easier to create a report instead.

Best,

Heather

Adnan Khan

I am creating new report based on source sheet.