Looking at rows 2:4888, I want to find the first row number "x" in which OR(HxKx,IxKx,JxKx) is true. How can I write that formula in Excel 2003? I...

Accounting is giving me a Excel spreadsheet file of the issuance of part #'s. But the file is so big I can not get the data I am looking for out of it. I can...

Hi, i want the cell A1 equal to File name + Worksheet name.. is it possible? Lawrence

Hi, i need this two macros in the same sheet. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 6 Then Cells(Target.Row + 1,...

I have a spreadsheet in which I have formulae in some cells in one single row. I want to apply those formulae to all the subsequent rows in the worsheet, so...

Hi, First post. I have 2009 sales data in column O and 2008 sales data column P and the the following formula in column Q = O1/P1 as have formatted it as a %...

How do you get speech in an Excel document so that it reads the figures in the colums?

I have a formula for a cell, where the result will be numerical (123.5678). I want to be able to split the results from that cell into 2 cells so that 123 is...

I'm using Excel 2003 -- or, rather, it's using me. Somehow there is now a page break inserted *after every row,* turning my 3-page document into a 74-page...

How do I get a formula to decide on the # of cells to add up base on the value in another cell. For example, column A to L contains the $saving for each...

We are using external links to files residing in the same folder as the file requesting the link. Occassionally, these links decide to look in...

I have been using teh following which has worked really well =IF('Overview Procedures'!A38="Construction",'Overview Procedures'!J38%*100,"-") But now I want...

Black Incense Bottle Burner with Dragon Design Price:$25.00 Image: http://bestdeallocator.info/image.php?id=B000OPAHKO Best deal:...

I hope I explain this right! I need to create a master worksheet in a workbook that has several columns related to different descriptors of projects. Each...

Dyson DC17 Animal Cyclone Upright Vacuum Cleaner Price:Too low to display Image: http://bestdeallocator.info/image.php?id=B000I5REVA Best deal:...

I write a lookup formula in a cell but it doesn't show the result (only #N/A instead) but it shows the result in the function arguments box! Why? Did I miss...

I have a column of dates, formatted as dd/mm/yyyy. I need these cells to be formatted as text as I need to export and upload this information to another...

This should be easy - but I'm having trouble with it. I have columns A and B with data like this: A B X 5 X 2 Y 1 X ...

I have command buttons to execute macros. Is it possible to change the button color from grey to something else? This is Excel 2007. Thanks.

Member Name & Company James W. Bond Robert Wagner Mark Brown Carl. Boyle, Anthony Perkinks 5 I need a formula that will count a range of cells with names...