One invoice, Multiple products, how do I show it on Excel?

[asar_k]

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

[Special-K]

You need to count the unique occurrences of the invoice number.
Search this forum for count unique or do a google, you should find some useful info, its a fairly common request.

[Kyle123]

Use a database. 1 to many Relational data like you describe is best placed in a database, it's what they're designed for