Try this in C23:
=SUMPRODUCT(($C$2:$G$19="P")*($B$2:$B$19=B23))/SUMPRODUCT(($C$2:$G
$19<>"")*($B$2:$B$19=B23))
I wasn't too clear on what "non blank count of Team 1" should return,
so I took my best guess.
Angelo
On Jul 22, 6:49 am, "Saurabh" wrote:
> Hi All,
>
> I m having a trouble in attac
Thanks Ajit, but I've tried this. The define name dialog box accepts
it with the filepath, but once I close the other workbook and try to
update the range I get the error. Ive created two simple workbooks
that demonstrate the problem, if I can figure out how to post them
here.
Angelo
On Jul 21,
PM, Daniel wrote:
>
> > Can you mail back a sample file ?
>
> > Regards.
>
> > Daniel
>
> > > -Original Message-
> > > From: excel-macros@googlegroups.com [mailto:excel-
> > > mac...@googlegroups.com] On Behalf Of AngeloUCF
> >
I'd love to, but for whatever reason I can't see your email address
and can't attached a sample workbook in this post
On Jul 21, 8:33 am, "Daniel" wrote:
> Can you mail back a sample file ?
>
> Regards.
>
> Daniel
--~--~-~--~~~---~--~~
---
I've got a named range ("account") in a workbook named list.xls. I've
defined a name in another workbook as account=list.xls!account so I
can reference the range in the other workbook and the formula is
clean.
Now my problem occurs when I close the source workbook, the link to
the workbook doesn'
Right click the axis > format axis
Then select the Number tab and select the Custom category.
In the format code, type in "$###K"
Then select the axis options tab and select the display units as
"Thousands"
This should be what you are looking for.
Angelo
--~--~-~--~~~--
You could try something like this:
For Each x In Range(ActiveCell, ActiveCell.End(xlDown))
If Application.WorksheetFunction.RoundUp(x, 0) = 100 Then x.Offset
(0, 1).Copy
Next x
or rounddown or just round
--~--~-~--~~~---~--~~
Visit the blog to download Excel
Here's what I use. I've also included the macro to remove the outline,
which, oddly enough, works flawlessly.
Sub outline()
' Keyboard Shortcut: Ctrl+Shift+O
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
E
Hello, I'm just trying to set up a macro for a frequently used
command... adding an outline to a selected range of cells. I typically
need this for a range of merged cells. I'm having problems editing the
recorded macro because I'm using multiple cells and With
selection.borders doesn't seem to wo