Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ckelly0172

    Excel Help

    Great stuff, Thanks C
  2. ckelly0172

    Excel Help

    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...
  3. ckelly0172

    Remote desktop

    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...
  4. ckelly0172

    Remote desktop

    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...
  5. ckelly0172

    Remote desktop

    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...
  6. ckelly0172

    Help... lost a macro

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

    Excel - protection

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

    Excel - protection

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

    separating data

    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
  10. ckelly0172

    separating data

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

    separating data

    Thanks Geoff, will give it a go.
  12. ckelly0172

    separating data

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

    separating data

    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.
  14. ckelly0172

    separating data

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

    separating data

    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...
  16. ckelly0172

    Excel:Counting data

    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
  17. ckelly0172

    Excel:Counting data

    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
  18. ckelly0172

    Excel:Counting data

    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...
  19. ckelly0172

    Excel:Counting data

    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
  20. ckelly0172

    Excel:Counting data

    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...

Part and Inventory Search

Back
Top