I have filtered a large list and am just trying to count my filtered
results.  When I put the function "count" in, it counts the hidden rows or
filtered out rows along with my filtered results.  How do I just get the
total number of my filtered results?  If anyone can help please ...

I am trying to determine why my data import into excel 2002 is not
working correctly.  I have multiple Excel sheets that I am going to
have feeding into one primary one.  One sheet I have imported
correctly; although its formatting got shot to hell in the process, it

Hello --
I am wondering if there is a way to format a cell so that multiple
colors can be assigned to different text within the cell.
I am trying to construct a simple in-cell bar chart representing the

hello again,
i have a question on finding a formula for 2 items.
i have an amount column and a totals column. if i insert both information
what formula would be appropriate to find the percent of those two numbers.

I have a range of cells with different background color and values. I need to count orange cells (colorindex=40) AND value=A. Can anyone help?
MS

I'm using Win'XP and Office 2003.  Pressing the print button in Excel brings
up a "Saved As" dialog box.  Rebooting doesn't change a thing.  Following
through on the "Save As" dialog box doesn't lead anywhere.  Been using Excel
for months and never saw anything like it.  What am ...

Following on somewhat from a previous post, I have a column that contains
the text TRUE or FALSE.  I need to count the number cells containing TRUE.
Suggestions?
Jeff

I am going to start a program that will be used on multiple computers.  Some
have EXCEL 2003 and some have 2000.  My development machine has 2003.
If I supply the interop DLL from my computer to the machines running 2000
will my program be compatible?  if not what is the best way ...

I'm trying to find all the 0's in a certain column and replace them
with a blank.  However, when I hit the "find next" it finds a number
that's not 0.  For example, it'll find the number 126.423 which
doesn't even have a 0 in it at all.  I don't what the problem is.

In A1, I type in 0001 and in A2, I type in 0700 (both cell in Text format)
In A3, I like it to display the hours in between 0001hrs to 07000hrs in
Hours rounding it up to 7 hours instead of 699. How to I make it happen?
Thank you.

I am not able to combine all sheet's contents in a single sheet.
Please provide me any macro to run this type of issue.
And, Is there any need that any cell not be blank?
We have 10 - 15 sheets with start same fields So I want that the Macro

I have a little problem to resolve. I have worked on an Excel 2007
sheet and am trying to export it to a tab delimited text file (Save
As...) but when the file is exported, and when I open it with a text
editor such as Notepad then I view a lot of doublequotes added to some

We want to color groups of cells (an employee shift schedule) according to a
color legend.  As such, we want certain cell ranges to match the color of a
cell in a key or legend.  When the legend color is changed we want the color
of that group of cells to dynamically change also. ...

I've got Excel 2002. I've got an address file that I need to save as a .csv
file. In the file are ZIP codes that begin with 0. These leading 0's are
being dropped when I save as a .csv file. Here's what I've tried so far to
keep the leading 0's in .csv:

I'm creating a spreadsheet for a client and I'm not sure what
formula/function I need to do this:
I created a table with over 500 available values. I then created (on a
separate sheet) a form to input the customers information. 4 pieces of the