General

V Look up
WHats wrong with this formula? -- Tony ... 23 Apr 2010 11:48

Construct staff pay timesheet
My Aunt runs a care package for her severly autistic son - this entails having various staff looking after him at various times of the day and night in (mostly) regular shift patterns. I would like to help her by making her a spreadsheet that will track and calculate the pay for each staff member and which (I ... 23 Apr 2010 09:43

how can i freeze first coloumn & first row of exel sheet
... 5 May 2010 20:31

Calculating Time Spans
I'm trying to figure out how to calculate the duration between the "date/time" in to the "date/time" out. I have four cells DATE IN, TIME IN, DATE OUT, TIME OUT. I have to somehow merge DATE IN/TIME IN and DATE OUT/TIME OUT and then subtract the difference. But I can't seem to figure how to merge the two cel... 23 Apr 2010 08:41

filtered values
Hello How can I export only the filtered values in one tab to a new tab? ... 23 Apr 2010 08:41

Impact of Fees on Growth Rate
I have been using the following formula to calculate growth but the answer looks incorrect where there is an inital fee for each regular payment or an initial fee as indicated below: Fee £250 Initial Inv £100000 Net Investment £99750 then £500 per month growth 1%, applied monthly, and income of 3%. The results ... 23 Apr 2010 10:46

Protecting workbook from Plagiarism
Hi there, I have develepod a workbook at work which I am now being asked to share with other departments. I would like to protect it from plagiarism before sharing it. How can i do that in excel 2007? Best Regards, Vanessa Simmonds ... 23 Apr 2010 04:31

Excel 2007 - How to protect my workbbok from people copying my des
Good morning, I have developed a spreadsheet at work and I have now been asked to share with the other departments. I would like to somehow protect from people copying my work and saying that it was their development by putting my name in place that noone would be able to delete. How can I do it? Bes... 23 Apr 2010 08:41

Rename Cell
How can I rename column A to read "bills" instead of the letter A? ... 23 Apr 2010 06:36

Inserting a space between characters in a cell
Hi I have a column of codes and some are written as below: A2ABC A2BBB A2CBC A2DBD I want them all to has a space after the A2 ie. A2 ABC, A2 BBB etc etc. What is the best/easiest way to do this? Thanks. ... 23 Apr 2010 00:16