Search results for query: *

Great stuff, Thanks C

Hi, a little help with excel please..... How can I calculate the values of certain range of cells dependant 2 different criteria? eg ColA ColB ColC jan 1 a jan 2 b jan 3 c jan 2 a feb 3 b feb 4 c mar 1 a mar 2 b mar 3 c mar 5 a What's the total values in COLB when jan and 'a' are true...

thanks, makes sense if you have a flash wallpaper, however I just need a little ident. Anyhow, fixed.... Within Group Policy (type 'mmc' in RUN, FILE>add/remove Snap>add>group policy object editor>Finish>Ok>) and navigate to Terminal services (Comp Conf>Admin temp>Windows Compo>Term Serv...

Thanks for your response kjv. Not much help I'm afraid, it doesn't state anywhere that the desktop wallpaper is available when RDP'd in. However, I did notice on the options of RDP, under performance, that you can allow the 'desktop background'.... but it doesn't. Starting to think its a...

Hi all, I'd be very grateful for a little help.... I use rdp to connect to PCs we have a remote locations and I have found that certain properties in the Display settings are greyed out, such as desktop background and resolution. Is there a way of enable these settings so they're configurable...

Hi, I have stupidly deleted a macro by mistake... and its a big one!! Is there any way of getting it back. Cheers Craig

Superb.... works a treat. Cheers Gizmo Craig LUFC forever....

hi.... Is it possible to protect a range of cells rather than the whole book or sheet. Thanks Craig

Could you please elaborate on the "named range". this is the line straight out of the editor:- myColour = WorksheetFunction.VLookup(c.Text, [ColourLkup], 2, False) and Iam having the "error 1004 uanble to get the Vlookup propertyof the Worksheetfunction class. C

Geoff, Having probs with the 'myColour = worksheetfunction.vlookup(c.text,[ColourLkup),2,false)' code. Giving me a "run time error 1004" c

Thanks Geoff, will give it a go.

Takin the above example, I'd like to differentiate each combination with any colour. eg all 'd1 on' = green 'd2 on' = blue... etc c

Dont think i can use conditional format as the data i have is like:- D1 on D2 on D1 off D2 off D1 down D2 up... etc Also, this data is in one cell wiht other attributed to it. Geoff, I require only 5 or 6 colours. Thanks for help chaps.

oop, should've mentioned the data i have is text not numerical... (if thats makes any difference???) c

Hi there, I have a long list of data and would like to separate the different types so that they are colour coded, either the cell or the text. eg, if the data is simply 1,2 or 3 then each number to be a different colour. Could do it manually but i have approx 50000 bit of data of differing...

My apologies Geoff, yes it would the be the same number of characters. I have sorted it now, it finally clicked after a littel thought. Many thanks for your help Craig

Geoff, thanks for this, I'm nearly there now... What does 'right' do, because i now have a similar problem with column B. Col B has data like 'MCCA/D Enc 7 EDC 1 (Teletext)' and I'm only interested in the 'Enc7 EDC1' bit, where Enc can be 7 or 8 and EDC can be 1, 2 or 3. Much obliged for your help

I'm sorry, i'll try and make it a little clearer, don't seem to be explaining myself that well! If I have column A & B with this data:- A B 03/12/2003 17:49:36 Carl E1 03/12/2003 17:52:13 Carl E2 05/12/2003 17:17:45 Carl E1 07/12/2003 07:23:59 Bris E1...

Sure thing, 03/12/2003 17:49:36 Carl 03/12/2003 17:52:13 Carl 05/12/2003 17:17:45 Carl 07/12/2003 07:23:59 Bris 07/12/2003 08:04:49 Bris 07/12/2003 08:42:47 Uls 07/12/2003 17:28:14 Bris 08/12/2003 09:27:36 Bris 10/12/2003 15:37:33 Bord 12/12/2003 23:08:09 Bris 13/12/2003 06:36:34 Bord Thanks

Hi, I have 2 columns of data, column A with 10 different types of data and column B with 3 types of data. I wish to count how many of each combinations there are. However the problem lies at the fact that column A has a date and time associated with each of the 10 different type of data...