|
|
|
|
3 |
111 |
|
|
|
|
1 |
85 |
|
|
Summing based on format by
jennerifw
OK, I have another one...
I have conditional formating turned on so once an item is marked as
completed, it's cell turns blue. Now I want to total the items...
|
|
7 |
108 |
|
|
Dialog & User Form by
bach
Hi Guys,
I am playing around in Excel, and would like to know what the
difference been the two forms. The Dialog sheet holds the elements and
fields, and the...
|
August 13th, 2005 09:35 PM
by bach
|
2 |
102 |
|
|
Length Calculation by
Lee
I have a column of 20 cells that have IF statements in them. The if
statement is such: =(IF('A-V Input'!C5=0,0,IF(('A-V Input'!C4-'A-V
Input'!C5)/120,('A-V...
|
|
1 |
152 |
|
|
There has to be any easier way!! by
Ken McLennan
G'day there AmEdee,
It's AmEdee with an E in the middle, not AmAdee ;-)
Sorry about that. It's the result of typing with my eyes closed =)
See ya
--
Ken...
|
|
0 |
99 |
|
|
SUMIF by
jeremy via OfficeKB.com
I'm trying to sum column two, if column one
meets condition....
weeks tons
2 6.8
6 23.7
7 28.6
4 36.2
8 24.2
8 24.2
|
August 13th, 2005 01:09 AM
by RagDyer
|
2 |
119 |
|
|
How do I get data for excel 2003 by
Bev
I am trying to learn Excel 2003 - want to make a speadsheet. Cannot find out
how to get the information from documents I have in Word into Excel. Is
there a...
|
August 13th, 2005 12:08 AM
by CLR
|
4 |
120 |
|
|
|
|
2 |
97 |
|
|
|
|
1 |
116 |
|
|
|
|
4 |
139 |
|
|
Text Formatting by
Suzanne Bond
I have text direct from a US system in a report, the text is a US date eg
01/30/2004. I would like to complete an aging report and need to find an
easy way to...
|
|
2 |
95 |
|
|
Locating variable range to copy by
Eric C
I am an ordinary accountant but not familiar with macro & VBA. I have a
file, I need to copy a source formula to a certain range of which
starting position...
|
August 12th, 2005 10:23 AM
by Kassie
|
2 |
235 |
|
|
Locating variable range to copy by
Eric C
I need a VBA solution and get idea after reading your web page.
Thank a lot.
Eric C
Tushar Mehta Wrote:
For a non-VBA solution, double-click the right-bottom...
|
August 12th, 2005 09:47 AM
by Eric C
|
0 |
229 |
|
|
Auto Adjusting Text Boxes? by
Jae
Is there a way to have text boxes expand, if necessary, to account for large
amounts of text? I'm thinking more length wise vs. width.
Thanks,
Jae
|
|
1 |
185 |
|
|
how to count populated rows? by
Ryan Cain
How do I find out how many rows have data in them starting with row 4 and
beyond? It's ok if I just know that column A has data in it.
I'm using VBA. I don't...
|
|
4 |
143 |
|
|
counting dates by
jeremy via OfficeKB.com
i have a column of dates (mm,dd,yyyy) how do i count how many are in each
month....
i tried...
|
August 12th, 2005 02:03 AM
by CLR
|
1 |
108 |
|
|
|
August 12th, 2005 01:56 AM
by CLR
|
1 |
144 |
|
|
Supress Scientific Numbers?? by
Sam
Hi ...
Is there any way to get Excel to not display numbers in scientific
format?? To force it to display 1.86E+08 as whatever the number really...
|
|
2 |
101 |
|
|
Social Security numbers by
Hernan
Hi Ruthki,
Ok, I'll try that. And the format the social security number is 000-00-0000
Thanks.
Hernan
"Ruthki" wrote:
|
August 11th, 2005 08:14 PM
by Hernan
|
3 |
162 |