Re: counting and filtering
From: Stefan Hägglund [MSFT] (stefanha_at_online.microsoft.com)
Date: 08/26/04
- Next message: marksuza: "Re: Dragging by keeping the column the same"
- Previous message: Ragdyer: "Re: Dragging by keeping the column the same"
- In reply to: kevin carter: "counting and filtering"
- Next in thread: Frank Kabel: "Re: counting and filtering"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 10:38:06 +0200
Hi Kevin!
You can use an array formula in column D, like
=SUM(IF(A2:A11="Gripper",B2:B11))
For the next question, use this formula in column E
=SUM(IF(A2:A10="Gripper",C2:C10))
Press CTRL+SHIFT+ENTER (or COMMAND+RETURN on the Mac) to enter the formula
as an array formula.
See http://support.microsoft.com/?id=275165 for more information.
Best regards
Stefan Hägglund
Microsoft
"kevin carter" <kevin@carter5711.freeserve.co.uk> wrote in message
news:2f84ce8d.0408252220.53880a4e@posting.google.com...
> hi
> i have the following data
> A B C
> reason time occur
> Gripper 10 2
> Gripper 10 1
> slide 10 5
>
> the range is set to 10 rows 1e(a1:a11)
>
> what i want to do is search column A for duplicate entries adding the
> result of time , also if there is no duplicate return the values
> ie. Gripper 20
> slide 10
> i then need to select the top reason in time.
>
> i also want to do is search column A for duplicate entries adding the
> result of occur, also if there is no duplicate return the values
> ie. Gripper 3
> slide 5
>
> i then need to select the top occur in number of occurances
> this happens for the first hour.
>
> Can anyone hep me please
>
>
> thanks in advance
>
> kevin
- Next message: marksuza: "Re: Dragging by keeping the column the same"
- Previous message: Ragdyer: "Re: Dragging by keeping the column the same"
- In reply to: kevin carter: "counting and filtering"
- Next in thread: Frank Kabel: "Re: counting and filtering"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
