Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.42 seconds.

  1. Replies
    3
    Views
    55

    Re: Change all cells to Absolute $?$

    not sure about Mac, F4 cycles it, or maybe ASAP utilities is available for Mac
  2. Replies
    3
    Views
    78

    Re: VLOOK TABLE Index doesn't work

    what would lookfor be in the cell, text or number or text number?
  3. Re: Is this process doable or am I in clock cuckoo land?

    a pivot for showing data isn't actually that bad, it produces a table that comes from you data in grouped values. I get lost when I know I can add sums and totals in a structured way so I don't use...
  4. Re: Is this process doable or am I in clock cuckoo land?

    you could add the steps you want in here as you have on line, and the file would serve as the visual, if each was number then people could comment on what might not be doable
  5. Replies
    1
    Views
    85

    Re: Width of several columns alignment

    if you set the page print width to 1 then the print out should scale, also set narrow margins
  6. Replies
    2
    Views
    90

    Re: VBA Employee Time Punch

    if you have the button, right click on it and edit macro and then navigate
  7. Replies
    1
    Views
    65

    Re: Help with existing code

    not sure but can you hide that row in the code when run and then unhide after. It happens often to me manually when I select filtered data ?
  8. Re: Windows/User Authentication for Excel Workbook

    you might encode all the books with specific user ENVIRON strings that you have worked out > https://www.techonthenet.com/excel/formulas/environ.php plus other references on the web
  9. Re: VBA: COmparing two word documents if similar

    There is a commercial product called File Compare Ultra, I can imagine a world of pain if your two files don't match tested with VBA
  10. Replies
    3
    Views
    87

    Re: Miscounting in column T

    will fudge with =COUNTIF(E3:Q3,">0")-1
  11. Re: Show 2nd, 3rd, etc. Result in a Query only

    I would be tempted to pull your data into a temp table then apply > http://www.advancesharp.com/questions/18687/select-nth-row-from-a-table-in-sql-server
  12. Thread: batch Geocode

    by mole999
    Replies
    5
    Views
    140

    Re: batch Geocode

    i would have thought ordnance survey would have the best data being that a postcode is a big beast
  13. Thread: batch Geocode

    by mole999
    Replies
    5
    Views
    140

    Re: batch Geocode

    doogal has limits of the amount of data it will process for you
  14. Replies
    9
    Views
    152

    Re: Macro help - Tab name changes daily

    would have thought activesheet would be the way to focus that
  15. Thread: Referencing

    by mole999
    Replies
    0
    Views
    39

    Referencing

    I have a table were I have a couple of static references, and I need to be able to copy paste across the sheet maintaining the same reference points. The Monday (and other days) value is derived from...
  16. Re: Code works on my computer but not any other

    and are you sure it is table 14 and not something that has been recreated with a different number ?
  17. Re: Code works on my computer but not any other

    if you step through your code with F8 where does it fail
  18. Re: Symbol for "DOES NOT CONTAIN" in a formula

    maybe Left(cell,1) <> "W" or something like that
  19. Re: how to extract a website address(not hyperlink) from within a text using a formula

    have you got a selection of strings to work againgst
  20. Re: how to extract a website address(not hyperlink) from within a text using a formula

    do all web addresses have www
  21. Re: Code works on my computer but not any other

    have you looked at yours and the others references
  22. Re: Section Number Search from Horizontal Cabin Numbers

    using an html tool can you show a small example of what you have
  23. Re: Section Number Search from Horizontal Cabin Numbers

    did you look at HLOOKUP?

    graphics don't show when linked to your own PC
  24. Thread: Probability

    by mole999
    Replies
    2
    Views
    136

    Re: Probability

    Thread closed as repeated here > https://www.mrexcel.com/forum/excel-questions/1103182-probability.html
  25. Replies
    4
    Views
    186

    Re: Conversion to Mac issue with VBA

    beyond the file paths, parts of the system aren't implemented, there are guides on the web
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4