Hi guys, I've searched and tried to reuse some of the code to fit my needs but, so far I've not been successful. So, my last resort is to ask for your...

I have an Excel spreadsheet which records monthly meetings with clients. The clients' names are listed in column A and each column in a certain range (say G...

Sorry for the confusion and repost, i'll try to explain better this time. here's a copy of the actual sheet http://www.savefile.com/files/2073433 and...

Hi, I have a spreadsheet of contacts, over 2000. The telephone numbers are in the format 09999 999999 or 09999999999 I would like them to be updated to ...

I have a bit of a problem calculating a financial formula that gets the outstanding principal amount as at the end of month. My understanding of the formula...

I have dates in Col B, and quantity in Col C. I want to enter a date in cell K1, and have the quantities added in Col C that occurred on or before the date...

Someone (I think) mentioned to me that there was a way in Excel 2003 to have line formatting alternate to make a ledger-style effect (every other line is...

I want to create a list of numbers and continuously add up the previous four numbers. For example if column A has the numbers 1-52, then in column B,...

I have a very simple formula in one sheet in a workbook setting a cell equal to the value of a cell in another sheet. But when I say "equal" I want the...

Can anyone explain how to conditionally change the text colour in a spreadsheet - for example show negative numbers in red and positive numbers black ? Many...

I have a list of data written in col. say 105 no data in A1:A105 Now I wart to write those 105 data in rows, Each row can have maximun 10 data.The next data...

How to declare the number of arguments to be unlimited and optional, as if selection of a number of range / cells or insert numbers as if in the function of...

I tried to make an schedule on my spreadsheets but when I tried to save it.it doesn't work and so I tried to print but it hangs instead.so I have to closed...

I have a work sheet containing a list of players and their rankings. I need to have multiple other sheets unique to each ranking. Therefore, in the sheet...

I have a table as follows: Name: 1 Name: 2 Name: 3 Name: 4 Tel.: 1 Tel.: 2 Address: 3 Tel.: 4 Address: 1 Fax: 2 Fax: 3 ...

I need a function/formula to extract a list of values from a list basing on two conditions. I have date wise sales data sales person,date,amount in sheet...

I need to increase my spreadsheet by 5% for 3 years and also some of my colums I need to show a decrease of 5%. Help please!

This letter was sent to you because of concern about your professional association with Mr. Dominique Richard / Richard Gleeson, an unlicensed and ...

I've formatted a cell as a percentage column with a precision of 3 d.p. However, when I work out the average, the answer is inaccurately. So, cell D80...

I need to forecast numbers in a spreadsheet....increasing for 3 years and also decreasing numbers for 3 years, for example a 3% increase for the next 3...