Functions

Create Formula for Weighted Average in non-consecutive cells
I have a spreadsheet which across the top has the months Jan to Dec and Total. Under each month is 4 categories Days/oil/gas and would like to simplify a formula for a weighted avg. eg. A B C D E F G H I JANUARY FEBRUARY MARCH etc. to December days ... 5 Jun 2010 00:39

Weibull function in Excel
I have a survival dataset (see below). I want to fit to Weibull function S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and gamma=2.32. If I use a method tranforming probability to Ln(Ln(1/S(t)) which will be a linear function of Ln (t). But I got a different alpha and gamma. When I compared ... 5 Jun 2010 20:14

Fill in Column with a series of repeating numbers
I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got 360 rows to fill. Any suggestions? ... 4 Jun 2010 21:24

Data Labels in Excel Pie Charts
How do I get the data labels to stay where I put them in pie charts. I have a series of pie charts set up and update the data they are based on monthly. I find that most of the time when I go to the pie chart, whether or not I have updated the source data, the labels will move and typically so that they are n... 4 Jun 2010 19:13

barecode command
customize toolbar , all commands, barecode cammand, after barecode command has been placed in toolbar, it has not funtion, i am unable to click on it , under help it states that one the stand alone version of excell or the excel version that came with professional package or higher has the barecode command . m... 4 Jun 2010 17:00

COUNTA or COUNTIF or COUNT
Trying to count the times "YES" occurs in column C3:C5 for each time "Bill" indicated in column B3:B5? -- Thanks - liz ... 4 Jun 2010 19:13

F4 no longer automatically creates absolute reference
I select the text of a cell name (A1, for example), hit F4, an nothing happens. I have to go in and type my $. How do I reset F4 to work? ... 4 Jun 2010 21:24

Exported data from Banner database to Excel
When I take a Banner database exported to excel and save it as .dbf file to use in mailing software, it drops certain fields in the name field. Does anyone know why this happens, is there some thing in those fields that is hiding the information? I causes great grief as the addressing software will shift all th... 4 Jun 2010 13:41

iserror and ifs nested formulas
Please help! I am trying to get the formula below to return a value to the cell ONLY if the answer to ((c30-$30)/g$30) is greater or less than 20%. I am using the below formula. =IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," ")) Thanks ... 4 Jun 2010 17:00

Formula to pull the lowest supplier name
I need assistance creating a formula to extract the supplier name associated with the lowest supplier bid. A sample of the data looks like this. I need to be careful as some quotes will be zero and I do not want to pull this as the minimum supplier. Sup A Sup B Sup C Minimum Sup Bid Minimum Sup Name $/lb. ... 4 Jun 2010 19:13