I hid collom A and now can't unhide it! Please help?

I have a Zip Code Table with only the first 5 digits and do not have the last 4 digit. How can I make them in 9 digit zip code with the last 4 digit as...

Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I...

I’m using this formula; =IF(OR(‘Source Sheet’!C10={“�,�C�, “B�}),’Source Sheet’!B10). This allows what I enter into the source sheet to...

I am interested in linking a formula to the colour of the cell. Ie. positive number would produce a green cell & negative cell would high light the cell in...

Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side...

I have a column listing numbers in worksheet B. I'm looking for a formula to place in worksheet A that will list the bottom number listed in that worksheet...

Hello, I made conditional formulas but with the numbers that result I am unable to calculate their average. I get the #DIV/0! error. They are formatted as...

Hi, Im trying to check that one row of data satifies a criteria, then if it does it counts an entry in another column adjescent to it. Example: - Column A...

I'm using Excel 2003 so I hope I'm not limited here. We are performing a space usage survey and I need to compile the data results. Each location has 70...

I input my formula, but would like to fill in the data later. How do I save the Formula without there being data. I am trying to create time sheet that will...

Hi try using data validation ('Data - Validation).: - Select the cells in column A (assumption you start in A1) - enter the following formula in the data...

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...

I have columns numbered for payments. A PO can have any number of payments. A PO can be shown on any number of rows as the resource being billed against the...

I select the text of a cell name (A1, for example), hit F4, an nothing happens. I have to go in and type my $. How do I reset F4 to work?

Trying to count the times "YES" occurs in column C3:C5 for each time "Bill" indicated in column B3:B5? -- Thanks - liz

I am trying to figure out, if possible, to make certain blank cells in a row/column to be filled-in (blacked out) if a certain cell contains a particular...

I have a spreadsheet which across the top has the months Jan to Dec and Total. Under each month is 4 categories Days/oil/gas and would like to simplify a...

Hi All, I would like to find the LAST NonBlank TEXT Cell in a Row and subtract the Column number of the Cell from the total number of Columns in the Row. Or,...