Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    475

    Hi Geof, Thanks very much, thanks have been...

    Hi Geof,

    Thanks very much, thanks have been added, however, I fixed my issue avoiding VBA by doing one simple thing.....removing the function HYPERLINK from the formula. I thought it was...
  2. Replies
    6
    Views
    475

    Hyperlink in VBA

    Hi all,

    I would like to ask another question, as even though I have the power of google at my fingertips, I always end up getting my answers from here instead.

    I would like to build a hyperlink...
  3. Select the drop down of the column to the...

    Select the drop down of the column to the immediate left of your Total column.
    Select Value Filters.
    Select Greater Than or Equal To.
    Make sure the first box is set to 'Count Of.....', then put...
  4. Replies
    17
    Views
    350

    Absolutely magic! Now, last question - how do I...

    Absolutely magic! Now, last question - how do I transfer that to the master sheet?

    Can I just copy and paste the code?
  5. Replies
    17
    Views
    350

    You're a legend. Aren't you at work or anything?...

    You're a legend. Aren't you at work or anything? You've spent a lot of time on this.
  6. Replies
    17
    Views
    350

    Hmmm......not really what I wanted, however, I am...

    Hmmm......not really what I wanted, however, I am extremely appreciative of your help.

    The 'slabs' are already in my worksheet, they dont need amending. I need to be able to build the summary.
    ...
  7. Replies
    17
    Views
    350

    Happily 43721

    Happily

    43721
  8. Replies
    17
    Views
    350

    I would be quite happy to move all the paths over...

    I would be quite happy to move all the paths over to row AA or somewhere to ensure plenty of room, I just need the summary.

    I do have in column A the paths separated by a comma, and the paths I'm...
  9. Replies
    17
    Views
    350

    Unfortunately not my good man, its type 2. I...

    Unfortunately not my good man, its type 2.

    I have the pathways, but I need to create the Count Summary
  10. Replies
    17
    Views
    350

    Thanks Zeddy - that is great, but I forgot to...

    Thanks Zeddy - that is great, but I forgot to mention a minor detail.

    The data you included on row 3, where there are 4 a's - I need them split out to show a 'pathway' kind of thing.

    I've...
  11. Replies
    17
    Views
    350

    Seemingly Complex Counting

    Hi all,

    Any COUNT formula guru's in?

    I have comma delimited data, with each cell containing one of 3 words, or blank. I have over 500 rows, and each row differs in data quantity, so row 1 may...
  12. Replies
    15
    Views
    2,067

    Well, as much as I would like to see this one...

    Well, as much as I would like to see this one through, my organisation has now decided they don't want to do this, so I wont take up any more of your guys times with this.

    I would however like to...
  13. Replies
    15
    Views
    2,067

    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...
  14. Replies
    15
    Views
    2,067

    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...
  15. Replies
    15
    Views
    2,067

    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...
  16. Replies
    15
    Views
    2,067

    Automatic 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...
  17. Replies
    2
    Views
    328

    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' +...
  18. Replies
    2
    Views
    328

    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...
  19. Replies
    1
    Views
    248

    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...
  20. Replies
    1
    Views
    248

    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...
  21. Replies
    4
    Views
    595

    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
  22. Replies
    4
    Views
    595

    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...
  23. Replies
    5
    Views
    688

    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
  24. Replies
    5
    Views
    688

    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,...
  25. Replies
    5
    Views
    688

    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...
Results 1 to 25 of 31
Page 1 of 2 1 2