|
|
Counting styles or formatting by
Paula
Is there a formula to count styles in a worksheet? I've
assigned cells individual styles based on formatting
options, and need to tally them. Thanks!
|
April 22nd, 2004 09:31 PM
by Paula
|
0 |
556 |
|
|
|
|
17 |
556 |
|
|
Remove border line of a few cells by
Raymond
how do I remove the border around a cell? I did it by right-click the cell,
then click Format Cells.
click the Border tab and I remove the borders by...
|
|
1 |
556 |
|
|
Format cell containing complex number by
David
I'm using Excel 97 SR-2. I have a cell (actually lot of
them) containing a complex number, for example, "=complex
(sqrt(3),pi())". The cell will show "a+bi"...
|
|
1 |
556 |
|
|
|
April 30th, 2004 04:02 PM
by Cam
|
6 |
555 |
|
|
|
October 2nd, 2003 08:24 PM
by eijaz
|
6 |
555 |
|
|
Displayed Rows and Columns Excel 2000 by
Roy
I import data to a worksheet and want to show only the
necessary number of rows and columns - not all 65,536 rows
and all 256 columns. Then when I scroll down...
|
April 14th, 2004 05:11 PM
by Andy B
|
2 |
555 |
|
|
Pivot Tables compatibility - 97 and 2000 ? by
Clarence Crow
Hello
One our clever Clients has sent us a very complex Excel 2000 workbook
including Pivot Tables. He also has locked it except in a few areas to
enable us to...
|
|
5 |
555 |
|
|
data query problem by
aaron
Thanks in advance for your help.
I am querying a website for some tabular data. This
website contains several pages of tabular data in the
following...
|
December 22nd, 2003 01:24 AM
by
|
3 |
555 |
|
|
|
|
3 |
555 |
|
|
"and" "or" in formulas by
donman1950
I'm trying to write a formula to calculate the price of an item as
follows:
=if(+b17=0) and or (+c17=0)," ",+c17/b17)
thanks for your help
---
Message...
|
|
1 |
554 |
|
|
Auto Date Conversion Not Requested by
Bad Date Mark
When opening a .csv file or pasting in a column of number with the format of "01-5308", Excel autoformats to "Jan-08"...then when converting the format of the...
|
June 14th, 2004 05:24 PM
by RagDyeR
|
7 |
554 |
|
|
Display rows based on criteria by
Holly
Hello,
I have 2 fields that are populated based on user entry:
1- Age
2- Trip length
Based on the answer to these questions, I would like for
excel to...
|
|
3 |
554 |
|
|
Adding numbers based on Range by
Carla
In the C column I have categories and in the J column I have Hours
Is there a formula to where I can look up the category "Library" in C and
add only those...
|
|
2 |
554 |
|
|
|
|
5 |
554 |
|
|
|
|
1 |
554 |
|
|
|
|
4 |
553 |
|
|
multiple arrays in single statement by
Alan Beban
I think you've overcomplicated the example, which makes it hard to
reproduce; can't you articulate your problem using simply, e.g.,
=MATCH(JP,iRange,0) and...
|
November 21st, 2003 01:34 PM
by rudekid
|
2 |
553 |
|
|
Number days between 2 dates by
Kreiss
I'm looking to find a way to tell how many days are
between two dates. I found function, "Days 360", but that
doesn't give me a true number since it's based...
|
October 3rd, 2003 01:48 AM
by GB
|
6 |
553 |
|
|
|
May 26th, 2004 08:10 PM
by DJONES
|
1 |
553 |