|
|
Finding lowest count in any column by
Sarah H.
Hi, group,
I'm interested in knowing the lowest count of non-zero numbers in any column
on my sheet.
Columns are from B through I.
Actually, I want to add 1...
|
|
7 |
210 |
|
|
Calculation Speed by
ColleenK
I post this before and implemented the suggestions, to no avail, so I am
asking for further ideas.
This is Excel 2003 and I have a workbook with 15 tabs,...
( 1 2)
|
|
14 |
383 |
|
|
Error problem by
Ayo
I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))
but it is showing as an error. Iknow...
( 1 2)
|
May 20th, 2009 04:52 PM
by Ayo
|
11 |
364 |
|
|
Erase same content in all cells in Excel by
S1L1Y1
I am sending a sample of contents I have in the cells. I am trying to erase
everything but the URL address. How can I do it? I have in one line when I
copied...
|
May 20th, 2009 04:18 PM
by S1L1Y1
|
0 |
194 |
|
|
Dates by
lightbulb
Is there a way to have a formula look at a cell and if the date in that cell
is between two certain dates to display it, otherwise leave blank...for...
|
|
3 |
165 |
|
|
comparing 2 sheets by
rodchar
hey all,
i have 2 sheets that contain a column of names on both
s1
john
amy
s2
john
|
|
2 |
164 |
|
|
SUMPRODUCT by
ColleenK
Hi There,
I am new to using the sumproduct formula, would someone be able to tell me
why the following is not working:
=SUMPRODUCT('Detail...
|
|
3 |
188 |
|
|
|
May 20th, 2009 03:14 PM
by Luke M
|
3 |
150 |
|
|
Rounding off by
ace
Guys,
I have a question.
Suppose I have a column which has values ;
300
315
330
390
Now i want these values rounded off to the nearest quarter,
|
May 20th, 2009 03:12 PM
by ace
|
3 |
153 |
|
|
Text to Columns help by
Martin ©¿©¬ @nohere.net
Hi
I have a column with name like below
McAllister Mr & Mrs E.
Hay Mrs E.
Farquhar Rev. G. & Mr M.
Russell Mrs M.
Cuthbert Mr & Mrs J.
Cuthbert Mr R.
Cuthbert...
|
|
4 |
206 |
|
|
Another Text to Columns question by
Martin ©¿©¬ @nohere.net
Hi
I have the name McAllister Mr & Mrs E.
When I use text to columns it becomes Mr & Mrs E.McAllister
However, I want it to be Mr & Mrs E. McAllister
(with a...
|
|
4 |
206 |
|
|
Excel 2002: Auto Filter Sub Total formula by
Mr. Low
Hi,
I wish to sum up the filtered data by using =Subtotal (109,E6:E125) but it
returns with #VALUE, may I know how to solve this problem ?
Is this formula...
|
|
2 |
189 |
|
|
|
May 20th, 2009 02:15 PM
by PJFry
|
2 |
205 |
|
|
|
May 20th, 2009 02:11 PM
by SPISO
|
0 |
185 |
|
|
|
|
1 |
161 |
|
|
|
|
1 |
204 |
|
|
Formulas by
Donna
I need a basic formula as soon as possible! I know that I have done this type
of work before however, it has been so long since that I cannot remember how
to...
|
|
2 |
144 |
|
|
Problem with Deserialization by
Gaurav Nanda
Hi,
I am creating a excel plugin, where i have to create a Tree on Excel
worksheet, so while saving i also want to save the tree in serialized form as
a...
|
|
0 |
164 |
|
|
Proteção com macro by
macros
Tenho um arquivo que tem varias macros, este arquivo é protegido com senha,
no excel 2003 ele funciona normalmente, ja no excel 2007 ele não funciona,...
|
May 20th, 2009 12:32 PM
by macros
|
0 |
175 |
|
|
IF then else VB code help by
Lost
Ok I dont know how to start with this or if its possible but here is my
delema & idea.
I have WorkbookA.xlsm that opens hidden when I open WorkbookB.xlsm...
|
|
1 |
168 |