How can I select only those records with a "1" in col A and highlight only col C of the same record(s) for copying? I'd like to put this in a...

I am trying to figure out a formula to figure out the pre-tax amount. I have a final total and know the tax percent. How do I use these to figure out the price...

I enter 5562815 in a cell, then try to format it to currency. I've tried all the choices and it changes to $5,562,815.00 instead of $55,628.15 like I want it...

Hi, I have searched and read the search results for the problem I am having. The problem is the subtotals are not being staggered properly, appearing in their...

I am trying to build an IF statement that would apply and I could copy accross as a formula. I want to include in the cell C3 an IF query that would populate...

How do I use the "Find" function to search through an entire workbook instead of just one sheet in the Workbook?? Any advice would be greatly appreciated.

I am trying to write an excel macro that merges 4 cells in 4 columns, wraps the text, left justifies and adjusts the row height so that all of the text is...

I have a drop box that is getting number-letter part numbers for me and telling me if they have been superseeded by another part number. However I have one...

I have a workbook that has several worksheets linked. When the date fields are blank in the orginial worksheet the worksheet they are linked to shows the...

Does anyone know if there is any way to expland the limitations set to display the number of characters in a cell. I understand that the cell can contain over...

Hi, I have a code that by clicking on any cell on the spreadsheet passes the information to predefined cell. The problem is that when I protect the...

Hi, Is it possible to pass data from any cell on the spreadsheet by clicking on it, to a predetermined fix cell? Thanks, Amnon

Hi, Is it possible to make two cells "Twins"? What I mean is if I'll input in cell A1 the number 1 it will appear on cell B1, and vice versa? Using Excell...

Hi, I have a problem with the Vlookup formula. It`s only works right on the first time when I entered the formula but the results don`t change when I am...

Hi, I have to columns of data. The first is with the Months and the other is with Numbers, For example, in column A1:A12 there are the months (January,...

Hi, I have to columns, side by side full with 248 rows of data. How can I paint, using conditional formatting, the cells with equal data? Thanks, Amnon

Hi, How can I use Conditional format to paint all empty cells on a certain range (say A1:D24) with yellow color? Thanks, Amnon

Hi, how can I force excel 2003 to ignore in calculation empty cells but not cells with zero. For example: the formula =If(d4=0,e4*f4," ") brings 600000 in...

Hi, How can I stop Excel formula to consider a blank cell as a zero? I have a column with zeros and blank cells. I need the formula to consider the cells with...

Hi, I have a worksheet full with numbers. Every number represent a scanned page with a data. How can I retrieve the page when I am clicking on the number in...