We are creating a huge spreadsheet to integrate data into our Accounting System and need to know if there is an easy way to make changes to formulas to pull...

Hi, I have a column of cells which are in any of the following formats: x # x x # x x x # where x could be any number of characters (a-z or A-Z) either...

I have struggled with this problem for 2 days, i hope somebody can help. DESCRIPTION Data Scoring Sub Score Gearing...

I have a spreadsheet that requires certain abreviations to be placed in one column. I want to be able to show the user what choices that they have from a...

I have a spreadsheet with different information for several countries. I'd like to create a dropdown of all the countries, so when a country is selected only...

I have different dates that I need to classified with different codes. The codes are M-00, M-01, M-02, M-03, M-04, M-05, M-06, M-07, M-08, M-09, M-10, M-11,...

I'm trying to count the number of dates with a range of dates that are iether less than or greater than a give date (e.g. Today () function) E.g. 10/08/09,...

Below is the information I have cell G5 = $PAAY3 cell A7 = ABC cell B7 = 20090810058 cell G7= 0000000000 cell F7= 16833 cell F5= LG The top is the formula I...

I need to take the zeros from one cell and add them to a forumla in another cell eq take 0000000000 (10 zeros) and convert them in the formula to read...

Is it possible to open a form (created in excel) and make edits to the form and forward the form to another user to make edits without actually saving the...

I'm trying to copy a group of formulas from one sheet to another. The formulas being copied are a simple restating of data. example Cell 3AA = cell...

Is there any easy way to refer to sheets without knowing the name of the sheet? e.g. A summary sheet that collates details for the company from all other...

I have a large spreadsheet with a column of information that was set up as text even though the contents are numbers. I want to highlight the whole column and...

I am having a problem coming up with the correct formula. I need a formula that if any row in column C says "show" then I want colum B to sum the numbers in...

Friends, I want to evaulate 9 cells of different workbooks to check if they are empty and take value of the cell which is non empty(assuming only one cell...

I've encountered this problem both with Excel 2003 and 2007. Attempting the same thing in Access works fine. I'd sure appreciate it if someone could tell...

I'm looking for a way of inserting a formula based hyperlink that when selected would navigate to a cell in another tab (same workbook) which had the same...

Friends, I want to evaulate 9 cells of different workbooks to check if they are empty and take value of the cell which is non empty(assuming only one cell...

I need to find a value in a certain row and return a value from same row. I can't use vlookup because the lookup value can be with in any colunm within a...

Hi, I am trying to extract and remerge data with an additional character (comma). For example, I have the following list in a column with many...