I have an issues which should be solved in Excel, but I cannot seem to
find an answer, here's the problem.
In cel H2 is a percentage of target realisation.
In cel I2 is the formula which will give a numer of points based on

I am trying to get the average of a row of numbers with various numbers of
columns.  I have 50 rows of numbers and am looking for the formula to average
all of the rows, showing the average of each row.  I know how to do them
individually, but very time consuming.  Any help would ...

I want to use auto filter on columns, but I have cells that are blank and
when I use the drop down on the auto filter, its doesnt pick up anything
after the blank cells. Is there a way around this, as I do need to have blank
cells in my columns.

I am new to Excel2007 although I have been using Excel for many years.
The problem I am having exists with only one Excel workbook file and
only in Excel2007,  The problem exists if I save the file as a 'xlsx'
file or as a 'xls' file.

Please, I need help.
I am using a mainframe connectivity application (called Vista TN3270) to pull data (realtime) from mainframe screens and paste that data into Excel using copy function of TN3270 and the paste function from Excel.
I copy the info from mainframe into the ...

can any one please guide me regarding the  work-sheet format
and the number of tables it may contain?,
the XML tags and attributes for XLSX?
thanks

Folks:
I have 2 spreadsheets.   The first consists of 5 columns & 4000 rows of
information. The 2nd consists of 1 column and about 10 rows.
I am looking for an Excel command that would allow me to take each piece of

Does anybody have the order of running event processes when an Excel
Worksheet opens?
I have a data collecttion running when the workbook opens and I want to
review status of an database refresh after a WorkBook opens and gets the

Ok, so im not sure if i can explain this totally correct, but i have my bank
balance done with EXCEL... Now, at the moment, everytime i want to create a
new line with the balance code at the end in, i have to copy and paste
current line, then paste below, and just re-edit the ...

I need to check to see if the dates in two discrete cells are the same.
However, I only want to compare the month and the year, the day doesn't
matter.
For example:

I have a column of data where each cell contains a unique 8 digit number.
I want to be able to put all of these numbers into a single string, with
each number being separated by a ',', e.g.  xxxxxxxx,yyyyyyyy,zzzzzzzz
I know I could put a ',' in an empty cell, say C5 and use

Sorry about the previous post with Newsgroup - I forgot to check my
identity - I am reposting this again correctly.  Please, I need help.
I am using a mainframe connectivity application (called Vista TN3270) to
pull data (realtime) from mainframe screens and paste that data into ...

I'm looking to learn Pivot Tables.
Can anyone out there let me know any good texts on this?
Thank you in advance.

I have about 20 workbooks each containing a macro called "ClearBalances"
within a folder called "Schedules"  The macro from each workbook clears the
quarter ending balances activated by a command button.  What I want to do is
to use the "ClearBalances" macro and clear out the ...

Dim i As Integer
Dim myText As String, List, myTotal As Double
Dim cell As Range
Set cmt = ActiveSheet.Comments