I'm comparing prices of different companies and products.
If I have prices in different cells for each company I can
calculate the lowest price using:
=MIN(A1;B1;C1;D1)

Am new to Vb so bare with me..
i have a cell that contains a drop down text (Yes) or (Blank)
If that cell is (Yes), row 28 to 38 should get hidden.
can anyone figure out what am suppose to write in VB? or any other formula?

I've got Excel 2003  and my problem is  that the functions in the Sheets does
not update when  I  make  changes in the cells. For exsamle : I've got a
price in A2, a quantity in B2 and a formula =A2*B2 in C2 .And when I change
the quantity or the price I excpect the C2 to update ...

I have  this set of records where a few of those records have been given a
different shading based on some of their characteristics.Will it be possible
for me to filter out just those records using any of the built-in
features/functions?I am not keen on using modules or writing ...

I want to add a calender to my worksheet that when a user selects a specific
cell the calender will come up, the user can select a date, and it will fill
the cell with that date, then when the user goes to the next cell the
calender dissapears, but the date stays in the specific ...

Can anyone provide an example address for a hyperlink originating in an EXCEL
cell with a specific slide in a .ppt file as the destination. I can reach the
file but have been unable to figure out how to open directly to a chosen
slide. They say it can be done. Thanx

I am wanting to find out if the NOW() function can be updated automatically
every 30 minutes - i have a formula which changes a date to tomorrows if it
is after 5pm - but the now function obviously doesn't update automatically.
Can any bodyhelp?

Excel 2007- How can I get the font color to change automatically to red when
I am using the Percentage Format in Cells and the answer is a negative
number?  The dollar format works perfect but there is no option in the
percentage format to allow this to happen.  I assume I have ...

Is there anyway I can use information on an excel worksheet to create
multiple files? I have data on say 'Tab1'. I have subtotalled data by cost
centers. Can I get a new file created in excel for each cost center ? Can I
have a naming sequence assigned to this?

I received a worksheet with preset sorts for each column (each has a
ascending/descending arrow).  How do you do that?  I have looked everywhere
and can't find anything that even talks about this.  Then again, it may be I
don't know what this is called.

I have checkboxes on my worksheet that need to be grouped together. If there
are 2 or more checkboxes  I only want 1 of them to be checked, and the
other(s) to be unchecked.. In other words if 1 checkbox value is true, I want
the others in the group to be false.

When creating a link to a cell in another workbook, I want to make the query
dependent on the contents of a cell in the destination worksheet.  For
example, I want to specify the path, the tab and the workbook in cells and
create references to these cells in the external link.  ...

I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in a
second cell, but when inserted into the second formula, I want the 0.25 to be
"converted" to 0.9. I don't want to change the ...

I hope someone will be able to help me.  I have tried a number of things but
can't get this just right.  I want to be ale to make the text in a cell turn
red if todays date is between two dates.  Example:  in Cells A1 through A12
are the months of the year (January, February, ...

I have a workbook with multiple sheets, each sheet in column (A) has a three
digit number that is assigned for a piece of work. Column (B) will describe
the vehicle used for that piece of work. the purpose of these sheets is to
track the time of the piece of work, at a location. ...