Hi: I have a very bizarre problem. The division operator (the slash sign) has suddenly stopped working in my excel spreadsheet. When I enter something like...

Is there a way to assign one of 2 data series to the right scale, and keep the other data series in the left scale? I don't see any reference to right scale in...

Is there a simple way to make a function that sums cells of a particular color only in a specified region? For example, maybe something like a...

Hello, I would like to create a formulas that verify 2 cells and give me a result in the third cell. EX: in cell I3 I have a chance to have 1, 2, 3 or 4. If...

Does anyone know how to use AND within the criteria range of an advanced filter? eg. Filter for all values 500 AND 700. More complicated: How can I...

I have this bit of code that I recorded and then edited slightly: - Sub AleBak() ' ' AleBak Macro ' Macro recorded 30/09/2003 by Bhupinder Rayat ' '

I am trying to add a comment to a cell. I can do it alright but when i finish and try to move the cursor over the cell the comment appears but is all black...

I need help understanding this particular formula it appears it also has conditional...

I am creating an Excel spreadsheet that has three columns. The first column shows the persons name. The second column shows forecasted hours. The third...

Adding a comma in a cell? EX Nicole Anna Nicole, Anna

How do I get around the 7 if function limitation. ie. We use a spreadsheet to document a game we play. In this game there is 1st-10th place at the end. If a...

Is there a formula in Excel for Days Sales Outstanding? Thanks, Jason

I wish to create a simple spreadsheet with 2 columns. Column 1 will contain numerical data and in column 2, I wish to have a running total. i.e. cell B2...

How can I remove spaces in the middle of a cell? I tried trim and clean and it did not work. Can you help me?

I have a list of numbers in a column. I want to find all the numbers that are duplicates, and then eliminate the duplicates. Is there a formula or function...

I have a problem with determining if a unique serial number currently exists in a spreadsheet. I have set up a workbook where Sheet1 acts as a data entry...

What formula would we use to change the color of the font on a date that is equal to 5 days from "today's" date? Example: Today is 10/1/03 we want the color to...

=CONCATENATE("='Products'!",C30) is what is in Cell H23 and it produces output of ='Products'!F2 The problem is, I don't want it to display ='Products'!F2 I...

I'm trying to take info from two cells on a master sheet and enter both into a single cell onto a sub sheet seperated by a comma. Example: Master Sheet...

Is it possible to set up an argument which when fulfilled will return the date that it was fulfilled? I know it can return TODAY's date, but I want the...