Hi, trying to combine these two items, have the following that does not seem
to work, thanks.
=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

Alright. I'm trying to sum data entered into cells based on the drop down
selection of another cell.
Cells B6, B16, B26, and B36 have drop down lists.  Depending on the
selection in any one of these drop down cells, corresponding subprocesses are

I am going to try this question again.  I have a user with a spreadsheet that
is 65000 row long and goes out to column R.  The data in the spreadsheet is
created from a data connection to an Oracle database.   The users wants to
select all of the cells and format the cells to ...

I can find plenty of help on designing and tweaking a form, but how do you
actually create one?  I am using Excel 2003.
Thank you

Is there a way to check for numbers in a range of cells? Ie, to do a kind of
ISNUMBER(A1:A5)?
Thanks,

I have a sheet coming from another (stupid) program, with
- one line " client: name_of_the_client"
-on many lines, all the products ordered by the client
Of course, to sort this sheet, I would like a new column, with

I just bought a laptop w/ Vista on it and found out that MS Office
apps don't come with it.  I use XL 2003 extensively as a power user
and do a lot of VBA coding as well.  For those who have played with XL
2007, I haven't heard many good things about it.  Is it worth buying?

Hi I want a cell to return two different results depending on what is
entered. For example I want  a function in column C (Outstanding) that will
either return the value of Col A (PO value) or it will return the difference
when a value is entered in col B ( Inv Value)

I would like to enter a series of values in a horizontal range of cells. Then
I would like the numbers array (about 20rows x 40col) that match the input to
highlight themselves.
Thanks in advance

I would need to make formula in excel where from selecting the data from
different list (eg. object and period) will result with unique value
specified by user (me).
Is there possbility to make something like that.

Hi, I run the following macro to convert columns E,G,H,I into Euro's but it
keeps converting coulmn D, which I don't won't to convert. Can anyone help.
Thanks
If Range("D7") = "EURO" Then

In Microsoft Excel I have a row with a different value in each cell and I am
looking to show only the cell that has the greatest value in that row.  I
would like for all the other cells to be hidden in that row.  I would also
like the program to do this automatically.  Any ideas ...

I want to stop wrong entries (spellings, capitalised and so on) being input
into a column.
I have set up a data validation drop dpwn list, but this has limited
functionality. I have read (and tried) Debra's page on Combo Boxes, but is

any one can tell me how can i bring the visual basic display screen to
defualt mode

I have a Master Workbook that have linkes to various workbooks. Some time
when I update any of workbook it displayed #REF error in my Master Workbook.
I have to double click on every cell which then shows actual value. please
help me on this error. and tell me some short way to ...