I have a formula in F2 that returns value '1'. i want my formula in G2 to return a value if F2 returns '1'. the G2 formula doesnt seem to recognise...

HOW CAN I TELL WHICH ARE THE MERGED CELLS? HOW CAN I FIX THIS TO BEABLE TO SORT?

Hi, I am unable to get the correct count using the formula : =SUM(IF(A1:A999=" A",IF(D1:D999="Dd",IF(F1:F999="1",IF(E1:E999="1",1,0))))) I am trying to get...

How do you create a spreadsheet that only shows the fileds with data in them? -How do you get rid of all the empty rows/columns, to ease viewing for those who...

I would like to be able to print the print area from each worksheet onto one page. Specifically, I have 12 worksheets (one for each calendar month) and would...

can i make a formula to change the format of the cell if it is 2 or 1? i have tried IF FIND and less than greater than but have had no luck thus far thanks

In the watch window there is a column header called "name". I have not been able to find any reference on how to use this, not in Excel help and not on the...

This is a repost as my one this morning doesn't appear to have saved, so ap;ologies if I end up raising the same question twice. I have a macro called...

Hi I am not professional excel user. But I am wondering if anyone can help me write short formula for the following. I use MAX(A10:A1000) to get the maximum...

I would like to be able to track my employees running sales figures on a daily basis and have a form (or something) that indicates the difference of each...

I am using the countif formula and when I hard code the criteria it works but when I link the criteria to a cell it doesn't. Bellow is an example of what is...

I have a data file that is too large to import into excel. I would like to import only unique records that do not ALREADY exist in the workbook. My workbook...

Hi, I have a column of cells with telephone numbers in it and I wish to convert - or copy and paste these cells - into text format. For example, I have a...

Hi, I have multiple sheets for my spreadsheet, and some cells refer are self- referencial of cells on another sheet. I want to know whether it's possible to...

About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened...

When exporting large amounts of information into Excel (Office 2000) some of the date formats are changed but not all.Most are kept as DDMMYY but some...

Dear Sir, I am using Excel 2000. In the excel I want to conver my numeric total amount into words. Please help me.

Hello all, I am looking for a kind of Sumif function to sum the values in column A if the conditions in column B are OK. BUT the range should be limited....

I am trying to get it to add together using the TEXT function, and it will only do it if i select and add each individual cell into the formula, is there not...

Hi, I'm trying to map a single XML element to multiple columns in 2003 Pro Excel and I'm having a bit of trouble. I've mapped my XML schema to XML Source......