Hi All,

I have one invoice, which records details of three different products. The invoice number is the unique identifier, which means 1 invoice=1 sale (irrespective of the number of products included).

I wanted to record this on Excel on three different rows, but then they would be shown as three different sales, not one.

At the end of the week, I need to find out how many sales I have made, and also how many items of each product has been sold.

I need advice on how I can achieve both my objectives.

Thanks,
Asar