|
|
Using IF in formula by
I am trying to build up a YTD value in a cell on a
worksheet named YTD. The YTD value is the sum of cell
ref "A17" on each worksheet named JAN, FEB, MAR...etc...
|
June 15th, 2004 10:30 AM
by
|
7 |
414 |
|
|
auto sum function by
I just realized my final sum changes if I use the "sort
ascending" function.....
How do I fix this ?
thank u
|
September 6th, 2004 02:51 PM
by
|
4 |
192 |
|
|
Getting the cursor to return to C1R1 by
I have an excel sheet with 6 columns and 75 rows. I need
to input data into the cells, Is there a quick way to go
from Row1 Column6 to Row2 Column1? At the...
|
|
2 |
258 |
|
|
LOTUS SPREADSHEET? by
HOW CAN I GET A LOTUS 123 SPREADSHEET TO AN EXCEL SS
WITHOUT HAVING A LOTUS PROGRAM. THE LOTUS SS IS ON A
FLOPPY.
|
|
2 |
166 |
|
|
|
September 14th, 2004 04:32 PM
by
|
2 |
174 |
|
|
flowcharting in excel by
I've just been given instructions to create a process
flowchart of one our business units. I see that I can do
this in Excel, but has anyone used Excel for...
|
|
3 |
152 |
|
|
NEED A LARGER SPREADSHEAT by
Does any version of Excel have collumns past collumn IV?
What is the last available collumn in Excel v.3?
|
September 23rd, 2004 10:06 PM
by On Film
|
7 |
256 |
|
|
|
September 23rd, 2004 05:15 PM
by
|
1 |
258 |
|
|
Need Help with a Formula by
I need to count the number of entries on sheet where=20
column D=3DROUND
and
column E=3D.01 AND less than .04=20
and
|
October 20th, 2004 07:13 PM
by RagDyer
|
1 |
129 |
|
|
find by
Hello,
Is there a formula I could use to tell me if a cell
contains the Letter "C" somewhere within the text. I am
familiar with...
|
|
2 |
162 |
|
|
|
August 11th, 2004 03:44 PM
by BrianB
|
1 |
330 |
|
|
Circular Reference with Data Validation by
I'm trying to get the following formula to work. I16 is a
data validation list (drop down list) and I keep getting
the circular reference error message, can...
|
June 17th, 2004 03:50 PM
by JulieD
|
2 |
195 |
|
|
format cell problem by
Hi,
I do not arrive to create this personalized format who is responding to
these 3 conditions
(number is displayed in percentage).
1) if 0 the colour...
|
|
2 |
318 |
|
|
How to merge databases by
I have multiple databases in Excel with similar data that
I need to pull into one large database.
The only way I know to combine the information is cut...
|
|
1 |
204 |
|
|
Font Limit error message in Excel XP by
I am currently using a spreadsheet and drawing a large
number of graphs. I keep getting an error message
"No more new fonts may be applied in this...
|
|
1 |
146 |
|
|
date formatting by
Format the cell for a date, and if it doesn't have that
particular style you can customize it to be your style.
-----Original Message-----
I want to enter...
|
|
2 |
160 |
|
|
SORT COLUMNS by
IS THERE A WAY THAT I CAN REARRANGE COLUMN ORDER BY SOME
SORT OF SORTING. IE: A, B, C, D, E, F BECOMES
A,F,C,B,D,E. NOT THAT THE ACTUAL COLUMN LETTERS...
|
July 21st, 2004 02:19 AM
by RagDyer
|
4 |
166 |
|
|
print the sheet tabs by
I want to have a way to print the sheet tabs only...
If one has a number of sheets .. and each sheet tab
a "label".. and you want to print them only or get...
|
|
1 |
411 |
|
|
Name Columns by
Is there any way to name a column in Excel? I mean where
the actual ABC's are. Just sort of rename it.
Does this make any sense?
|
|
1 |
87 |
|
|
Write a code by code by
How can I write a code from procedure to some Workbook's
ThisWorkbook? With procedure1 a make Workbook with a table.
I need to write Auto_Close procedure to...
|
|
1 |
188 |