I have two worksheets, A and B. I would like the contents on sheet A to be copied AS AND WHEN IT IS ENTERED into sheet B. I have done the '=SheetA!A1' formula to copy the cells, BUT it does not like...
Although Amazon has many DVD Box Sets from TV series,my brain seems to have gone quite blank when it comes to thinking of them. Has anyone got any suggestions please? I am thinking mainly of TV Drama...
Does anyone know how I can calculate a percentage in excel, calculating the frequency of letters? For example, I have a list of 20 questions, of which there can be 5 answers (A,B,C,D,E). I need to...
Hi all, I m planning a trip to LA in April and am just looking to get some ideas and advice from anyone that's been there. What I mainly want to know is how expensive is it there, i.e eating out? We...
I have a date when a project has to submit a final report by, which is trigegred byt he project end date plus one month (using EDATE). Anyone know a formula that can tell me, when I open the...
I have filtered some data on a spreadsheet and want to copy and paste data from another spreadsheet into these cells only. However, when I do, it takes into account the 'hidden' cells that are not...
Help! I have a party to go to on Saturday and I have been lumbered with dressing like the Indian one from the Village People. The look I am going for is: http://www.stachepede.com/celeb/felipe.jpg I...
Does anybody know how to do this? I currently have FALSE inevery sell where the formula is as source cell is blank...here is my formula (nested IF):
=IF(R39...
OK, I'm doing another spreadsheet! I have a cell with names in (A1) I need to next cell to that (A2) to copy the previous cell when the name is entered If cell A1 is empty, how do I make sure cell A2...
For a simple explanation, I have a list of data in column A. This consists of letters A,B,C,D,E. There are 25 entries. What I would like to do is calculate the percetage of their occurance in a totals...
We have a smallish office, and we need a new system to: Log people entering the office at the start of the day Log people leaving the office at the end of the day Log people going onto their lunch...
I have 2 lists of numbers in Excel (6 digits each number). Some of these numbers appear in both lists. Some numbers only appear in one list. I would like to cross-reference these lists and create...
I have a long list of data, each with a choice of 3 outcomes attached (e.g. Accepted, Rejected, Withdrawn) Does anybody know the foruma to make it count the data entries in the spreadsheet. I would...
I have a big list of unique reference numbers, some repeating, listed down column A. How do I count the number of single entries, i.e. not count duplicates?
Long winded but hopefully not too complex one this.... I am trying to create a timeline that will work out the processes and timeframes involved in creating something, using excel. The scenario, in...
I have a 15 pin VGA cable going from my laptop to the back of my Sony Bravia TV. The picture comes up fine. I then bought a 3,5mm Jack to Phono Lead (Red and White) which leads to my laptop's earplug...