I am using Version 2007. The following formula, when inserted manually on the sheet, does workout but when defined in a name like "Check" and inserted as...

Instead of "save as" I entered "save" and thus accidentally overwrote a file in Word this afternoon. Is there a way that I can retrieve an eariler version...

Is there a plugin to support date entry older than 1900 ? How do we support family trees ? thanks,

This is a follow up for a question i asked 1 month earlier and somehow I cant reply anymore...so here goes again : hey is there a way to simplify the formula...

Hi all, How do i remove data from the cells that have been pasted as value? The cells were originally formulas but i have copy-special-value pasted. some of...

Footwear (paypal payment)www.king-trade.cn ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)www.king-trade.cn ) D&G shoes Dior shoes ED...

Footwear (paypal payment)www.king-trade.cn ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)www.king-trade.cn ) D&G shoes Dior shoes ED...

I have a spreadsheet that calculates remaining battery time. What I am wanting is when battery run time has less than 1/3 remaining I want that cell to turn...

Hi I am trying to work out how to return a number of between 1 to 5 if a single cell is between specific numbers. So i would like a A2 to equal 1 if A1 is...

column a will be filled in with dates as needed; how do i get column b to automatically fill in the corresponding day of the week to match that date?

Hello, The folowing forumal is used in part of a CONCATENATE function, and everything works great, except the code below doesn't make the text red....

On a worksheet I have a date a person has passed a course say in cell a1 The course is valid for 5 years only before a person needs to requalify in cell a2 I...

How can i use the checkbox to use a different macro when it's checked or unchecked? In this example: i want to copy paste from one location if is unchecked...

Excel 2007 imcorporated some functions which used to be in a add in previous versions. This is the case, for example, for the workday() and networkdays()...

I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289") As far as I can see I have to enter the indirect command into each cell individually....

Hi, I am working with a spreadsheet and I'm trying to use the getpivot data function with dollar amounts. It has worked for all other figures on my...

I have a logistics workbook with a summary page that has print macro buttons. I'm looking at having two (2) print buttons for certain worksheets. I can...

I have the need to copy the content of a cell to another cell based on the value of a totally different cell. If A1 is =1 and =10, then I need to copy the...

When I apply conditonal formatting to a linked cell in my spreadsheet it does not work. Is there someway to get this to work? I am trying ot get eh vale to...

How can I Round up to the nearest .25. I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and 4.79. I would like them rounded up to the...