I'm looking for hints on the following:
I have a list with a large number of values and I would like to sort
these into four groups by size.
Thanks in advance!

I want to run a function from say sheet1 that will be like a value in the
cell. "textme".  I want to find this string from another sheet, say sheet2.
When it finds it, return the row that it found this string.
How would I loop through the column of sheet 2 and find the text that was

How do you average a column of numbers conditional on another column
being true?
w  4
w  5

When I enter any value to a cell and hit the right arrow key, a 'b' is
placed at the end of the value and the excel window is minimized.
Does anyone know what could cause this?

I have a worksheet that will be used for simple data entry of name, address,
etc etc. - 1 column per field. One of the columns will be 'start time'
(column S) and the next column will be 'end time' (column T). I have used
Chip Pearson's code to help with the formatting of the ...

I would like to be able to enter a date in the following format:
10/19/07
and have it show up in the column as:
Friday, Oct 19 or Friday, Oct 19, 2007.  Important part is getting the

I am a newbie to Excel.  I have a workbook that I would like to format some
of the cells.  First of all I did not create the workbook, but I can't see
any protection set for the workbook.
There is a range of cells on one of the sheets that when I right-click in

I am looking to have all data on one sheet and have total amount of a group
on another sheet, how do i do this??
this may seem simple to expertslike you but today is an off day for me : )
thanks for your help

I have a column with threedigits  for telephone extensions. I want to insert
a digit before the three throughout the column as the extension has been
increased to 4 digits. Any easy way.../
Thanks.

In Excel 2003
I have two spreadsheets.  One with 1200 records, the second with 2600
records.
The sheet with 2600 records includes those records of the sheet with

I have an Excel sheet that has about 1650 company names and addresses.
Some of my company names have ++ next to them and some have ** next to them.
The number of ++ and ** changes.
Any name with a + represents accounts we don't want to mail catalogs to. Any

For some reason the keyboard shortcut (Ctrl+`) does not toggle show/hide
function.
Selecting Tools>Formula Auditing>Formula Auditing mode works fine.
I am wondering if it is because I have regional (keyboard) settings set

I have a column with threedigits  for telephone extensions. I want to insert
a digit before the three throughout the column as the extension has been
increased to 4 digits. Any easy way.../
Thanks.

Is there a way of getting VLOOKUP to skip the first value it finds and
returns a subsequent one?
I have a worksheet (#1) constructed something like:
Unique ID#  ID#        Data                  

When I sum the cells horozontally in a spreadsheet, the total becomes a
hyperlink - turns blue, launches my e-mail and has the blue underline.  I've
tried reformatting the cells as accounting number - but it doesn't change it.