I have 5 columns of data, the first column is time. In this column each row
is incremented in 5mins. So it goes 0,5,10,15,20,25 etc. I want to filter
the data to only show rows every 60 minutes i.e. 0,60,120,180 etc. Have can
i do this, ive had a play with filters but cant seem ...

I've got a sheet with 1410 row, but there may be only 100-150 unique entries
in column A (columns B-C have varying data, thus the repeating of the same
data in column A).  I want to distill the sheet down so that there is only
the same number of rows that there is unique entries ...

I'm using the following to create a text box and have added text
needed.
ActiveSheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 8#, 40#, _
       820#, 140#).Select

I have used some VBA from another posting which allows cell values to
be incorporated into a file name.  I have added  Now() onto my
worksheet and added an if statement that returns  Now() date if a
refrence number is not present.

I work with large spreadsheets and was recently referred to a free tool
called bpmTraverse from www.bpmglobal.com. I found this tool to be very
useful and was wondering if there are any other free audit tools that
could be recommended.

Coworker asking me to reveiw their work and when I try and open excel
it shows "ready" but there are no columns or rows it is all gray.  But
if I choose to look at full screen I can see everything except all the
additional tabs.  When opening this spreadsheet on another computer it

All,
I have a 200-row text file laid out as follows:

I would like to have a formula that would calculate the following.
Starting in year 2007 and ending in 2024 if each year the amount  went up by
3 % each year
My worksheet will have the years in column A and I would like the

one of the cells in my worksheet appears to be locked and whenever  i click
on a  adjacent or far away cell, the range of cells between the locked cell
and cell whee I clicked get selected.  I have 3 worksheets in the file and
when i click on 2nd or 3rd worksheet, the title bar ...

Hi There - hoping someone can help. I need to be able to count and sum
a set of data based on a persons name and an out come code. I have
tried using the following formula
=IF('[Leads Results Template.xls]Status'!$P$1:$P$1000=Q4,SUMIF('[Leads

Can anyone please teach me how to create option buttons (i need 4 buttons in
a group) from scratch?
Pls help as i am new to this and i cannot find the appropriate tutorials to
assist me,

To John Walkenbach
Merry Christmas, and thanks for all your EXCEL help.  
The Vancouver Island John Walkenbach Aprreciation Society

I wanted to know if someone would know if there is a downloadable
version of Excel add-ons of Data-Analysis and Data Analysis Plus for
Macintosh?

Is there a way to Password Protect a workbook so
that
someone else using the computer cannot open it ?
Thanks

Quick question I am hoping someone might be able to assist with,
Our users have a joint excel workbook that is linked to other .docs and
.xls's, so when they open their workbook it fills in the excel lines
automatically via a formula that obtains that info from the other