I have a sheet with Column heads
Name       Age          Class         Fees
I have above 2000 rows data is this posible to filter data by tpeing the
data rather I select one. for example in row 1 if I type *Sh & then enter all

Please help! I am using Office 2007 and I have problem with my excel,
everytime I enter numeric into the cell, it is automatically divide by 100,
for example: If I type 10,000 and when it's entered, the number entered in
the cell is 100.

I have a cell that I need to apply 4 different conditional formats to
and as you know excel only allow 3.
Within conditional formating you can choose cell or formula, I am
using Formula is =(Q7="Yes") which turns the cell red. This works

{=SMALL(IF(FREQUENCY(SMALL($E$6:$F$10,ROW(INDIRECT("1:6"))),SMALL($E$6:$F$10,ROW(INDIRECT("1:6"))))>0,SMALL($E$6:$F$10,ROW(INDIRECT("1:6"))),""),COLUMN()-COLUMN($AC$60)+1)}

Hi, I am using Excel 2003, I have a big matrix of data which basically has
colums called "ref", Hs, TS, Wave Dir, Windspd, Waterlvl, winddir, NS Wave
height, NS wave period, NS wave dir, ref check"
What I want to be able to do is lookup values for Hs, Ts, Wavedir, windspd,

in one of my workbooks I did something in VB editor after that particular
workbook is not geeting minimized maximized or restored. one problem is i
made one worksheet -xlVeryHidden now it not getting visible and property box
is showing error that class cannot be chaged. Please ...

For a custom dialogue box I was referred to the following excellent sample.
However, now that I have come across a situation in which a mistake took
place, upon pressing the "Cancel" button the rest of the code still seems to
be working!

Hello All ...
I am building a basic contract tracker spreadsheet.
In one cell I enter the start date and another the number of months of the
contract.

Hi
I have hundreds of contact numbers that I have imported into XL 07 from MS
BCM07.
The numbers come in with the area code in brackets followed by the number e.g.

Excel 2003
I have the following formula.
="Reference " & ADDRESS(1,1,4,TRUE)
When I try to drag the formula down to copy it to more cells, the formula

I am using the following code to import record from another sheet so the
record can be modified. The user has to look at the "Records" sheet, find the
row number of the record they want to modify, move to the AddRecord sheet and
input the row number in cell "A41" and click on the ...

I have been trying to use this site to run a sumproduct formula for the below:
A            B               C                           D                  
     E             F        G
projid   status  targetedstartdate    targetedcompldate   amountbilled          

Is there a way to "flip" my data so that the columns become rows and the rows
become columns?  In other words, I have a spreadsheet that has employee data
listed for each employee vertically down the column.  I can not sort vertical
data so I want to rotate it 45 degrees so that ...

I am trying to enter a formula into cell that included the VLOOKUP function
and I keep getting an N/A error as my result.  Why would it do this, and what
can I do to ensure I don't keep getting it?
I am in worksheet and I am basically trying to reference another worksheet

I am asking this question on behalf of my father.  He has a spreadsheet of
data which is about 2000 rows long and 9 columns wide.  My dad wants to
transpose the data in columns B - I in the following manner:
The data in B1 will move into cell A2 (and the data in A2 will move down ...