Posts by paulmcphillimy
-
-
Hi,
I am trying to merge / combine multiple row data (text) into one single row for each employee. Sample file here with in green the desired outcome in terms of format.Any help is much appreciated
Paul
-
Hi all,
Really struggling to on this any help will be much appreciated.
[tr][td]
COLUMN A S T U V
COMPETITOR NAME Wk1 2 3 4
[TABLE="width: 340"]COMP 1
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]COMP 1
[/td][td]X
[/td][td][/td][td]X
[/td][td]X
[/td][/tr][tr][td]COMP 2
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]COMP 2
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]COMP 3
[/td][td]X
[/td][td]x
[/td][td]x
[/td][td][/td][/tr][tr][td]COMP 3
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]COMP 4
[/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]COMP 4
[/td][td][/td][td]X
[/td][td]X
[/td][td]X
[/td][/tr][tr][td]COMP 4
[/td][td]X
[/td][td]X
[/td][td][/td][td][/td][/tr]
[/TABLE]So in column A I have a competitor name and then in columns S,T,U,V an X when that competitor has operations (weekly, hence 4 columns, representing one calendar month)
What I want to do is create a summary underneath to represent the number of jobs each competitor has running in that calendar month, so the summary based on above would look like this:
COMP 1 - 1
COMP 2 - 0
COMP 3 - 1
COMP 4 - 2 -
I want to add a "button" at the end of a report in excel that automatically attaches the work book to outlook, automatically has subject field, and saend to pre defined set of recepients. I am using Office 2007
I am thinking needs some VBA knowledge (which I have zero.....)
any idiot proof instructions will be greatly appreciated.
Regards,
Paul
-
Re: AVERAGE if below ZERO, but if above enter 0
Krishnakumar and AAE,
Many thanks it worked a treat. Sorry forgot to inform you the version of Excel I was using.
Paul
-
Hi, I have an issue. I want am needing to calculate the average of numbers below ZERO, so using
=AVERAGEIF(C17:F17,"<0") which works fine. But if there are no values below 0 returns a #DIV/0! so I need to extend formule to say if C17:F17 average is EQUAL TO OR ABOVE ZERO to enter "0"example of data in cells is 4 3 3 3 -1 -1 -2 -1
so average 1.25 (days in this case) delaybut if data is 4 3 3 3 1 1 1 1
there is no delay, so therefore I want only to note 0 - zero avaerage delayThanks for help guys