r t(k).
Although the above equation is for the probabilities for the lowest
value, I'm guessing substituting "max" for "min" and "<" for ">" will
get the right equation. The question then is, can you solve the
equation in excel? And how difficult is
When I do web queries and create pivot tables in Excel 2007, I really
dislike the automatic column width formattingthe columns are often
so narrow that my data is unreadable...is there a way to turn off the
auto column format function?
--
I just downloaded the Excel 2007 Web Data Add-in...I have two general
questions:
1. I cant seem to get a web page from a secure server (https) to
load...are there any issues here?
2. I have gotten data from a page like Yahoo finance, but once the
data is imported it is static...how do you keep the
Steve,
Lets assume that your columns are labeled A, B & C. meaning that cell
A2=2, B2=3, C2=5
put this formula in cell C2, =IF(B2="",A2+C1-A1,B2+A2)
Copy that formula down.
Michael
On Aug 28, 12:43 am, xsrossiter wrote:
> Hello,
>
> I am using Excel 2002 SP3 and hope to find a conditional s
T
CLOSED",AQ$1),AO$1),AM$1),AK$1),AI$1),AG$1),AE$1)
and in cell BB3 I put this formula
=IF(AT3="NA",IF(AV3="NA",IF(AX3="NA","NOT CLOSED",AW$1),AU$1),AS$1)
Copy those formulas down your sheet
Then in Cell P3 I put this formula
=IF(MIN(AZ3:BB3)=0,"N
Alex,
This a "Text to Columns" function. Select the column, use the Text to
Columns/ delimited function with "space" as an indicator.
In Excel 2007 "Text to Columns" can be found on the Data tab.
On Aug 18, 4:51 am, Alexander Cargill
wrote:
> Hi all I was wondering if you could help. I have a
Kalyan
I think Pivot table is your required solution using BP Group as your
Pivot Table Report Filter.
On Aug 18, 6:18 am, Kal xcel wrote:
> Dear Experts,
>
> I am attaching a file where I have raw data of Depot, Customer group, Month
> and Sales data. There are 16 types of customer group. I nee
This is a simple exercise with pivot table.
On Aug 12, 3:42 am, HARI NAIR wrote:
> In the attached file I want to know three results, how many persons given 4
> marks, out of which how many females , how many males.Please help me. Thanks
> in advance.
>
> Regards,
>
> Hari
>
> Book1.xls
> 59KVi
& B3) the formula in cell
C5 will return "N/A". If there is an intersection, then cell C5 will
not be blank.
Michael Hayes
On Aug 5, 10:35 pm, anandydr wrote:
> @ Michael Hayes
>
> Dear Michael,
>
> I went through the solution you sent for Mr Sudhir. Using his
> spr
ble)
Then in cell C6 enter this formula =IF(C5="N/A","N/A",+B2-((B2-C2)*(C5-
B4))) copy that formula over to cells D6 and E6
That formula will tell you your Y axis coordinate where the graphs
intersect (if applicable)
Email directly if you need a copy of the edited spreadshee
If you can copy everything to the new column, the rest of it can be
done easily with a pivot table.
On Jul 17, 12:31 am, Scott wrote:
> Hi,
> I'm trying to create a list of unique names from a list of names (some
> duplicates) that exist on 15 different sheets within a spreadsheet.
> So I want t
Hameet,
Try the concatenate function
=CONCATENATE("I have "&B1&" hands and "&C1&" Eyes")
Notice the spaces for the text inside the quotation marks...you need
those spaces to format your sentence properly.
On Jun 15, 6:37 pm, Harmeet Singh wrote:
> this should help. see attached file
>
> Warm
rogram to do so with
clear knowledge of the potential liability associated with such acts.
And hey if they do steal my work again, I'll be flattered and then let
the attorneys handle everything.
Thanks for your input.
Michael Hayes
On Jun 14, 9:06 am, Dave Bonallack wrote:
> Hi Mich
Kavita,
Thank you. I have been using this book as a coaster: "Excel 2007 VBA
for Dummies"...looks like I'm going to have to read it now. I think
I'm going to need more coffee.
Michael Hayes
On Jun 13, 11:50 pm, kavita ahuja wrote:
> Hi Michael,
>
> You can us userf
thms within the
spreadsheet?
Any way to create a "splash screen" or some legal notice that pops up
whenever the program is opened? And the user cant continue without
acknowledging the notice?
Thanks
Michael Hayes
--
15 matches
Mail list logo
