have column of numbers. at bottom of column, want cell to display last number
in column. can't use max cause last number may be less than number above.
could use =if but can't next more than 7 formulas. possibility of 30 numbers
in column.

I have been searching for days on how I can get a macro to copy/cut a row
from one spreadsheet and paste it into another automatically or even when I
run a Macro. The information will come from a validation list with specific
names. This is what I have so far;

I have a spreadsheet that I need to change the information in column A and in
Column C based on Column F.  Normally I would write a simple IF statement,
but I have over 75 possibilities for column F.  Is there any way to do this?
Jase4now

How do I use freeze pane and split in the same excel spreadsheet using Office
2007.  I used to be able to do this using 2003 and can not do the same using
2007.

Is there a way that I can have Excel automatically export only certain rows
of data and then save this data as a new spreadsheet?  Here's an example:
Company_ID    Job_ID    Job_Title                                                   
    Job_Category

I'm new to using Excel and I just need to find a formula to use that will
calculate a percentage change from one cell to another.

I am trying to count unique value in a list under column E
E
436
600

Hi there.  Hoping an Excel guru out there can help me!
I have an excel spreadsheet with filters applied.  I have cells in
spreadsheet that are both merged and unmerged.  When I filter by column A
(merged cell), it only picks up one line of data.  I lose other data that is

After merging several worksheets and removing multiple duplicate records, I
have noticed that many rows jump in sequence (e.g. 1345-1348). For accurate
record counting, how do set my new worksheet so that the row number actually
represents the real record number?

Column C (C2:C101) in my Sheet1 contain different criteria (names or number)
and my Sheet2 is a large database.
Is there a quick way to delete all rows in Sheet2 except the ones in Column
C of Sheet2 that matched Column C of Sheet1?

I have lost the use of some of the keyboard shortcuts in Excel 2007.
ctrl-arrow left or right move 19 cells, regardless if the cells contain data
or not.
ctrl-arrow up and down works as always.  

please send me how to write that as a formular in ms excel

I'm new here, as far as asking and answering questions.  I've been using the
search for the last few weeks and have gotten solutions on several things
I've been trying to do.  I just switched from Excel 2003 to Excel 2007.  My
question is really about this Excel discussion group. ...

I have a major list  with duplicate email addresses.  I would like to be
able to put all the duplicates with the remove first and the duplicate
second.  I have a very long list and more to do.  How can I pull the
duplicates together and be able to delete all at one time.

We have a large spreadsheet with a lot of data in it.  We did a pivot table,
but we would like to set up a way for them to click on the cell in the big
spreadsheet and just see the data that matches, then they can select the data
that matches the next criteria.   An example is a ...