I have to keep a record of numbers and it is so far 76 rows long; more than a
screen shows without scrolling.  I keep forgeting which column is which.  Is
there a way I can have the titles of my columns remain at top of the screen
as I scroll down the page?  I think someone told ...

I am trying to do the following:
I have entered a formula in which the results must be greater than or equal
to 5.  If it is less than 5 I want the cell to have a "5" and if it is
greater or equal to 5 I would like the actual result of the equation to be

I need help with a formula.  I have two columns - E (projected revenue) and M
(actual revenue).  If M has a total in it, I want to ignore the same row in
E, so that the actual revenue is added in to the total sum at the bottom
along with the projected (if there isn't an actual ...

I have successfullu run a Macro to hide certain rows that have zero sum
value, however I need guidance in being able to refresh my page once this has
been down. In order words, beside unhiding the rows that have been hidden to
start over, how can I reverse my Macro?

I made several changes to an excel document and saved it. Now I would like to
see my previous version of the document before the changes. Is there a way to
find this?

We are trying to create a spreadsheet to track hours worked on projects. We
will enter hours per person per day for one week to give a total for the
week. I've got this set up, no problem. We will also have a running
total--but we want to be able to replace the data entered in ...

Recently Excel has begun showing one giant sheet tab, and not all of it
either. I found a thread from a few years ago, tired everything that was
suggested (tool/options/show sheet tabs, and resizing the horizontal scroll
bar) and nothing works. Does anyone know what may have ...

can you use the vlookup function to return a value by looking at 2 diffirent
sheets?
I have a formula  
=IF(ISNA(VLOOKUP(C18,TABLE1A,2,FALSE)),"",VLOOKUP(C18,TABLE1A,2,FALSE))

I have a large amount of text in Coulmns. I would at the bottom of each
column I would like to get a total count of how many cells in the column
contain data. The column sum value would be something like A2:A250 ..  Thanks

i am trying to add a blank row after i compare 2 #s in a column.  i am using
the if statement to compare and if they are not = then i want to add a blank
row in between them.  any suggestions?  i am having a real time trying to get
this to work out.

I have a simple formula multiplying two cells and the ouput is incorrect. Why
is this happening?

have listing of stores and weekly sales, want to calculate the last four
weeks moving average, e.g, this week (wk4) would be weeks 1-4, next week
(wk5) would be weeks 2-5 and so forth.
second caluculation would be to rank the stores by weekly sales on same four

When I try to do a web query data connection into excel (which I do
normally with other web pages) to a page with flash I get the following
behavior:
-- the dialog box that shows me the web page for formatting into excel

I need to process tables containing somewhat ambiguous data.
Briefly, I want to replace specific positions in a cell
by a "wildcard" character if certain conditions apply.
Let me illustrate and I apologize for being verbose!

While attempting to convert text to columns one of the columns is dropping a
digit and adding a 0 to the number.
2008135701620201 after deliminating and sorting to columns this number
appears as 2008135701620200 even though it appears correct in the import text