Hi , I am using the sheet reference in a formula. the sheets are named on the basis of dates of a month... So i have to change the formula in every month...

I have a spread sheet built that currently has 382 sheets of data. The sheets are 12 columns x 61 rows. There are conditional formats applied. I can copy a...

HI I'm trying to show a selected cell reference in a popup , rather than the cell content. This is the code : Dim lrow As Long With ActiveSheet ...

I’m using the formula below, in a worksheet to count cells containing the letter S. My problem is in the total cell, it displays a 0 until I enter an S in...

Hi A1 September 1, 2010 Years of Services Age A2 B2 C2 ...

I am trying to 'make one' a number of columns... Essentially I have several thousand rows of data that I need to clean up... What I would like to accomplish is...

Hi, I am trying to get the content of a cell and then put it in (4-(x-8)^(2/3))^3/2)+8, where x is the content of the cell. Thank you in advance

Hi, I am interested if there is a way to have a message become visible when the mouse is hovered over a cell. I am currently using 2007. In this problem I...

I am trying to write a formula that will first look at the value in C3 which is identified by either 1 or 99. Then depending on either of these two numbers,...

Yesterday I was given a solution to a problem I had when copying text from cells in the source sheet to the destination sheet. The formula: =IF(OR('Hskp...

Morning all I am stuck with a forumula that I hope someone will be able to help with. It's quite long winded the way I am doing it but am hoping that it may...

Hi, Cell A1 has 21-04-10 07:00 PM Cell A2 has 06-06-10 07:52 AM (the dates are in the dd-mm-yy format) Cell A3 has the formula =A2-A1 for showing the...

Hi all again I need the address to be 18 characters long i.e. if the address is over 18 characters then chop it, if its under, then add spaces Is this...

In my workbook I have multiple sheets. I have a summary sheet, called: Graphs, consisting of (only) graphs, build from the data from the various sheets. These...

Within an IF function, I would like to have the cell left blank given a certain logical result. The purpose is to have a result, that does not show up as a...

Hello, Can a conditional formula be written to convert a cell with text and a number to a cellw ith just a number? I have a cell with the number 10 and the...

What fx to use for the following scenario: Month-End Dates (for many years) in column A A dollar Amount for each Quarter End in Column B (correlating to the...

Hi, I am having an issue with comparing columns of values. Basically I have a table similar to the below except with a couple of thousand lines. Either the...

I need to permanently save a header and it will never save once I open up a new file. Any suggestions?

I have a sheet that is comparing vendor's pricing. I am using the MIN to find the cheapest cost, but now I want to find out which vendor it is based on the...