Hi. Does anyone know which function can do the "Weighed Average"? Or do I need to combine several functions to do so? Thanks. -- Additional information: - I'm...

A difficult conditonal calculation Hi. It's the look of my Excel file: Item 1----Amount Category---Details: ... Item 2----Amount Category---Details: ... Item...

Hi. Is thre an easy way to set up the following testing conditions: - if A1=A2=A3= ... =A10, do something ?? Thanks! -- Additional information: - I'm using...

Hi I have a formula which combines texts from several sources. Eg: ="I am a "&A30&". You are a "&A31&". However we don't "&A32&", nor "&A33&". Except that, we...

Hi. The cell A1 contains: Here's the shopping list: pig, dog, hamburger, chocolate..., beef. Please purchase all of them. Thanks! I would like to extract each...

Hi. I have a series of formula which use the same condition. Eg: C1 contains the string of the testing condition, G1-Z1 make reference to condition in A1,...

Chop off parts of the statement Hi. I would like to do the following: 1) Chop the right part eg For cells containing "Hi. I'm John"; "Hi, I'm Peter" , ...

Hi. Here's the number list. 5 203 3450 4498 12358 This time, I need add extra "0" to the number until it has 6 digits & a dot at the end of the number, eg:

Hi. I would like to do some conditional math (which is similar to sumif) - average if: For numbers which are higher than 0 only, find their mode/average -...

0.3106552 Does This Look Good? ... 0.5603709 0.5883698 Now Visit Tobacco Is Drugs 0.7272271

Just wondering if this is a valid formula... =(B5*C5)+(B6*C6) -- curiouscash

HELLO everyone! I seriously need some excel help? I've been reading VB for Dummies and I still can't figure out how to do this with VB or use a function. I...

Can anyone come up with a formula to return the first blank cell in a range that has more than one blank cell in it? I tried MATCH("",range,0) but it returned...

Does anyone know of a formula to find the first blank cell in a range that has more than one blank cell in it? MATCH("",range,0) returns #NA Thanks

I'm linking to dynamic named ranges (i.e. the ranges resize to include all items in a column based on a formula in the name field) in another worksheet. It...

I have a range with two columns. The first contains the result of a formula that has text values, blanks, and #N/A's. The second has numbers in it. I want...

Can anyone point me towards information on optimizing formula performance and even workbook performance in general? Thanks,

Can anyone point me to information about optimizing formulas and workbook performance in general? Thanks,

I want to find the last non-blank row in a column. No problem, I just use: OFFSET($A$1,0,0,MATCH("*",$A:$A,-1)) However, this chokes on certain "Blank"...

I have a bunch of dynamically named ranges that I want to perform lookups from i.e. my named range contains a formula such as...