Many thanks Bosco
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]
COLUMN A S T U V
COMPETITOR NAME Wk1 2 3 4
[TABLE="width: 340"]
[td]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