I have a very large file. In column "G" are company names sorted alpha. But
they can be repeated row after row.
I need to know which companies are listed 3 or more times.
Adam

Hi.  Certain fields within my data do not repeat, but I'm trying to
find a way to populate the blank cells from the preceding row.  Here's
an example:
Employee_Number        Last_Name         First_Name

I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the

If I want to obtain the average of values in a column, using only those
cells which have a value in them, which function do I use please?
thanks
A

How can I copy an entire sheet from one XLS file to another?
I have tried Select All>Copy>Paste operation, but it does not resize
cells in the destination file.
The sheet I am copying is very big, so it's difficult to format all

I created a form in Word, cut and pasted it into Excel on three different
spreadsheets.
How can I format the spreadsheet to copy text to the other two spreadsheets
without having

i need to add text into cells that have pre-exisiting data already in i
and every time i click on the cell to add something in at the end i
automatically deletes the pre-exisiting data. so i have to type all th
data over again and then add in what i wanted to at the end...how can

I would like to be able to set up a template for my vat returns each month,
using the correct formulas for total, standard and vat. Can you please help

Hi, I've been using SUBTOTAL(9, C3:C396) to sum a column. This works when I
filter the column - it sums only the rows that are displayed. However, it
doesn't allow me to easily add more rows as I have to keep changing the
range in each column that uses SUBTOTAL (there are 12). Is ...

Well I have this list of names in a excel sheet, and I want to arrange them
alphabetically. Is it possible? If so how??

I create a schedule each month.  There is a column heading for each day of the
month formatted like this.  It is a General format:
Sunday 10-1     Monday 10-2     Tuesday 10-3    ... and so on.
Each month, I manually retype the day and date of each column to correspond

This may sound idiotic to some, but I've already been wasting too much
time with this option, and am looking for some guru insight. I am
trying to input text into the Data Validation Text Box that looks
something like this:

How do I change the Tab range from "next page" to "next cel"l? Just started
new job and format is set to go to next page  instead of next cell and cannot
find "how" to change in HELP.

I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2.  The captured day will be moved intact at
the end of the day
Is there a command that will let me do that?

in some excel sheat i can't write "a" in cell. can only write the other
letters.
pls help
thnx