|
|
Weighed Average by
0-0 Wai Wai ^-^
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...
|
|
3 |
110 |
|
|
A difficult conditonal calculation by
0-0 Wai Wai ^-^
A difficult conditonal calculation
Hi.
It's the look of my Excel file:
Item 1----Amount
Category---Details: ...
Item 2----Amount
Category---Details: ...
Item...
|
|
1 |
79 |
|
|
How to set condition: A1=A2=A3= ... =A10 by
0-0 Wai Wai ^-^
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...
|
|
9 |
150 |
|
|
Insert manual line break in formula by
0-0 Wai Wai ^-^
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...
|
|
3 |
108 |
|
|
Extract each item in the list by
0-0 Wai Wai ^-^
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...
|
|
1 |
96 |
|
|
|
|
4 |
298 |
|
|
Chop off parts of the statement by
0-0 Wai Wai ^-^
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" , ...
|
|
1 |
55 |
|
|
"000" + number + "." by
0-0 Wai Wai ^-^
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:
|
|
4 |
103 |
|
|
average if, multiple if, divide if by
0-0 Wai Wai ^-^
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
-...
|
|
6 |
109 |
|
|
|
|
0 |
74 |
|
|
formula question... by
000ani
Just wondering if this is a valid formula...
=(B5*C5)+(B6*C6)
--
curiouscash
|
|
2 |
140 |
|
|
|
|
5 |
141 |
|
|
Finding the first blank cell in a range by
0013
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...
|
July 30th, 2004 12:09 AM
by 0013
|
3 |
220 |
|
|
Find the First Blank Cell In a range by
0013
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
|
July 29th, 2004 09:43 PM
by hgrove
|
4 |
82 |
|
|
|
|
1 |
443 |
|
|
Conditional count in range w/#N?A's by
0013
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...
|
|
4 |
479 |
|
|
Performance & Optimization by
0013
Can anyone point me towards information on optimizing formula performance and even workbook performance in general?
Thanks,
|
|
2 |
159 |
|
|
Forluma Performance by
0013
Can anyone point me to information about optimizing formulas and workbook performance in general?
Thanks,
|
|
2 |
153 |
|
|
|
|
2 |
110 |
|
|
|
|
8 |
525 |