Re: Trying to find sales figures of certain products.



Nel post news:E7766013-637F-4F73-B07B-36D98DFD84BF@xxxxxxxxxxxxx
*Toto* ha scritto:

I need a formula to find how many productA(f.ex. apples) have I sold
at the same time as i have sold productB (f.ex bananas) (with
identical invoicenumber), f.ex.:
invoiceno. product kg
50 apples 1,00
50 bananas 2,00
51 apples 1,00
52 apples 1,00
53 apples 1,00
53 bananas 2,00
54 bananas 2,00
55 apples 1,00
55 bananas 2,00

You can use Autofilter, filtering on the column with invoice number


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


.



Relevant Pages

  • Re: Trying to find sales figures of certain products.
    ... same time as i have sold productB (f.ex bananas) (with identical ... invoicenumber), f.ex.: ... 50 apples 1,00 ...
    (microsoft.public.excel.worksheet.functions)
  • =?Utf-8?Q?RE:_Trying_to_find_sales_figures?= =?Utf-8?Q?_of_certain_products=E2=80=A6?=
    ... "Toto" wrote: ... of the bananas if there are more than one occurrence of the invoicenumber. ... same time as i have sold productB (with identical ...
    (microsoft.public.excel.worksheet.functions)
  • Re: quick foods
    ... fruit (berries of all kinds, melons & bananas - since I'm allergic to apples, plums and peaches) ... cottage cheese & yoghurt ... What kinds of foods do you like to keep around as quick and easy, ...
    (alt.med.fibromyalgia)
  • What is the best way to load this tree (c# & sql question)
    ... Say you have three tables apples, oranges and bananas and each table has a ... bananas) And second it won't work because I don't have a sql statement ... unions but due to the unequal amount of fields it's not working out for me. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: mysql update/replace syntax
    ... How much of each fruit do you sell each ... Fred Smith 1/1/04 Banana 3 ... You can tell how many apples and bananas have been sold, ...
    (comp.lang.php)