Search results for query: *

I realise that this is probabley not the right place to get this information but it is normally very good for my formula questions, Anyway here goes. I have just been handed the job of scheduling the transport vehicles and drivers for a local school. (Old chap that ran it has sadly passed away)...

Hi there, I am trying to get a period reference from a list of dates, should be easy but I am struggling could you help please. I have a list of dates going from 30/09/2009 going on through till 2011 they are dates entered when a trip is scheduled. I need to get them to referenced as a...

I now this is an old one but I am having problems with it again. I have a long list of time totals that are formatted in gemeral instead of time. I need to total these times can you help please. A 1 003:30:06 2 001:00:50 3 005:47:39 4 000:00:00 5 001:59:16 6 002:52:49 7...

I have been archiving data from my access data base by copying the data base and naming it database_date.mdb. I now need to gain acess to the archived data from the data base that is active and create queries from the archived data as well as the live data. Is there a simple way of importing the...

I need to take data from one sheet to another using to reference points to ensure the correct imput. I hope the example below explains. AREA PERIOD SCORE TOP PD1 72 MIDDLE PD1 60 TOP PD2 54 BOTTOM PD3 48 The data is exported from a data base for...

I have two sheets of data that I need to compare to make sure that the data is the same. Is there a function in Excel that will do this quickly for me. Thanks Lee

Hi. I want to connect to my colleagues PC to help him with a spreadhseet. How can this be done? We are both on the same network. I have windows 2000 he has XP if that makes any difference. I would prefer a way that does not rewuire any software downloads if possible. Best Regards. Lee

Hello. I am trying to separate the time from the end of a string including the date as follows: 08/11/05 08:25:26 I use =RIGHT(A10,LEN(A10)-FIND(" ",A10)) This does not work but if I change the time to 08.25 it does work. Changing the format of the cell does not work either. The only way...

I need to count only the coloured numbers in a list only for example below. 1 5 RED FONT 8 9 RED FONT 7 5 Total 14 Counting only the red numbers. There could be more than one colour to count...

Hi. I am trying to help an engineering colleague. He requires the power of seven symbol and I cannot find it.I can cheat to get it looking the part but it is not what he wants and takes more work than he wants to imput. any ideas?

I have placed this thread once and it was answered by MasterRacker but seems to have dissapeard for some reason so will try again. Is there a way of monitoring the monitoring on your PC, whether it be by big brother or any other remote source that may be by stealth monitoring the PC. Best...

Hello all. I import a spreadsheet from the states and the date format needs to be formatted to UK. Instead of being MM.DD.YY I need DD.MM.YY is there an easy formatting trick I can use to change the column. Thanks. Lee.

I have a spread sheet that has numder references to products that I produce such as 12550. there is another list that is generated which details the stock of this item. This list is not maintained by me and when a new part is added I am not imformed. How can I check the new list against my list...

Hi. I have what is probably a very simple challenge to some out there. I have a row of nubers. A1 is a lookup for a stock figure. B1 is the net req. C1 is the requirment. D1:H1 are shedule requirements by week. what I would like to do is set the cells so that if for example the stock is 3000kgs...

I have set three people up with sub folders in there "IN" box, each persons e-mail is directed by the subject line by there name. how can I password the access to each folder when opening?

When I clear my history from the settings area I go back to the browser bar and type a letter and there are still items showing as historical searches. how do I clear these items if a normal delete history does not clear this.

When I go to the menu bar select File. then scroll down. There is no file send option. can I get this added or restored some how? Lee.

I am keeping a sheet that records the history of improvements, what I want to do is store a sheet that was made up and paste it in the cell of an excel sheet as an example of what was done, is it possible, similar to the appearance of an e-mail with an attachment.

Is it possible to show more than one sheet from the same book at one time?

I am doing a sheet that will measure capacity on a production plan, I want to take the totals from selected cells and add them together in one cell on another sheet, can you help me with this, here is a sample line of the sheet.. TYPE MCN REQ TIME/MINS 20x121 300 150 6.00 12345...