Search:

Type: Posts; User: leeroysilk; Keyword(s):

Search: Search took 0.01 seconds.

  1. Replies
    12
    Views
    178

    Thanks RolandJS, and RetiredGeek, you're a...

    Thanks RolandJS, and RetiredGeek, you're a legend! I'm a tad busy for most of the morning, but can I get something to you this afternoon (uk time here). its almost 9am, so I'll try to get something...
  2. Replies
    12
    Views
    178

    Hi, Yes, sorry, Win7. I found Powershell,...

    Hi,

    Yes, sorry, Win7.

    I found Powershell, clicked it, now I'm faced with a blue window that says PS C:\Users\[username]>

    Does this mean it will work without admin restrictions?

    Also, what...
  3. Replies
    12
    Views
    178

    Hi RetiredGeek, thanks for getting back to me....

    Hi RetiredGeek, thanks for getting back to me. Through using this site over the last few months, I get the impression a majority of users are from USA, and with the time difference, I wasn't...
  4. Replies
    12
    Views
    178

    Auto File Copying

    Hi all,

    Bit of a complex one here, but hopefully, someone can offer either "it's impossible", or "here's how to do it".

    My organisation is quite strict on some softwares, so I need to be able...
  5. Replies
    1
    Views
    75

    Doesn't matter guys, this is solved now. For...

    Doesn't matter guys, this is solved now.

    For information, the working script line is:
    CAST(DATEPART(yyyy, [Appt Date]) AS CHAR(4)) + ', ' + Case When DatePart(mm, [Appt Date]) < 10 THEN '0' +...
  6. Replies
    1
    Views
    75

    SQL Date Function

    Hi all,

    I have a DateTime field I would like to display as 'YYYY, MM', so '2015, 02' or '2014, 10'.

    I normally do this in excel with a formula, however, would like to include it in my source...
  7. Replies
    1
    Views
    198

    No problem, I figured it out. I was trying to...

    No problem, I figured it out.

    I was trying to copy it, and paste it on the graph area, which forced it to paste as an image.

    If I pasted it to a cell however, it pasted as an active slicer, and...
  8. Replies
    1
    Views
    198

    Excel 2010 Pivot Slicer

    Hi all,

    Hopefully, just a quick one.

    I have a dashboard on Sheet1, and one of the charts runs off 2 pivots on Sheet2. I have linked both tables to the slicer, and this is working fine.

    Is...
  9. Replies
    4
    Views
    492

    Doesn't matter guys, I saved the file and closed...

    Doesn't matter guys, I saved the file and closed it. When I re-opened it, it was working.

    Can this thread be deleted please? I don't want to waste anyones time
  10. Replies
    4
    Views
    492

    Round times to the NEAREST hour

    Hi all, me again.

    I have googled and tried various methods, however, I can only really find FLOOR() or CEILING() formulas.

    I need to avoid the MROUND() function as not all of our machines have...
  11. Replies
    5
    Views
    507

    Thanks guys - sorry I haven't got back to you -...

    Thanks guys - sorry I haven't got back to you - my email had failed to notify me of replies.

    I'll give those a try, thanks very much
  12. Replies
    5
    Views
    507

    I tried splitting the string across multiple...

    I tried splitting the string across multiple cells, then using a concatenate in my main cell of combining these up again, but I think it's what the formula results in that it doesn't like, ie,...
  13. Replies
    5
    Views
    507

    Excel 2007 HYPERLINK Character Limit

    Hi all,

    I did search for this post first, but there was only one, and it wasn't very helpful.

    I need to create a hyperlink in a formula, but am hitting the 256 character limit resulting in...
  14. Hope it works - one of the guys at work put...

    Hope it works - one of the guys at work put together a google map URL for me, but I think it might be stored on our servers here.

    If the link is broken, heres what it looks like:

    39300
  15. This is what I have so far - still needs work,...

    This is what I have so far - still needs work, but this is the essence of what I was trying to achieve39299
  16. I'll take a look, thanks Steve

    I'll take a look, thanks Steve
  17. By the way, might I add I am using...

    By the way, might I add I am using straight-forward UK postal codes, not long and lat.
  18. Thanks Steve, however, I think when my other...

    Thanks Steve, however, I think when my other markers are plotted, my Origin will be centred anyway.

    Let me explain my purpose, it may help.

    I work for a hospital in the UK, and what I want is...
  19. Excel Web Browser - Plotting Multiple Markers on Google Maps using UK Postal Code

    Hi all,

    This is my very first post, but until I was searching for help with my problem, I never knew this site existed, but I'll be having a good read through the forums!

    My issue. I have an...
Results 1 to 19 of 19