Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.35 seconds.

  1. Replies
    7
    Views
    45

    Re: Index Match Help

    is the first string part always without spaces?
  2. Re: SUM ignoring text fields in a non-string of cells

    AGGREGATE ignores errors, that might work ?
  3. Replies
    7
    Views
    45

    Re: Index Match Help

    what is your current formula
  4. Replies
    4
    Views
    89

    Re: Custom number formatting in Excel

    not sure it works 100% of the time but in custom format after the plan try "b" and that might add b to the end of your display

    "+/-" General "b"
  5. Replies
    1
    Views
    13

    Re: VBA Updae Cell References

    planning can reduce the issue, and relative referencing to static keywords might help other wise step through line by line and fix it :(
  6. Re: VBA to select filter criteria without deselecting current criteria

    three macro buttons, or a marker to direct how the macro records
  7. Re: VBA to select filter criteria without deselecting current criteria

    have you tried selecting on both in your macro recording ? its should produce and AND Criteria2:= _
    "Gaming"
  8. Replies
    3
    Views
    71

    Re: Change all cells to Absolute $?$

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

    Re: VLOOK TABLE Index doesn't work

    what would lookfor be in the cell, text or number or text number?
  10. 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...
  11. 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
  12. Replies
    1
    Views
    89

    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
  13. Replies
    2
    Views
    95

    Re: VBA Employee Time Punch

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

    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 ?
  15. 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
  16. 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
  17. Replies
    3
    Views
    87

    Re: Miscounting in column T

    will fudge with =COUNTIF(E3:Q3,">0")-1
  18. 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
  19. Thread: batch Geocode

    by mole999
    Replies
    5
    Views
    142

    Re: batch Geocode

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

    by mole999
    Replies
    5
    Views
    142

    Re: batch Geocode

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

    Re: Macro help - Tab name changes daily

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

    by mole999
    Replies
    0
    Views
    41

    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...
  23. 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 ?
  24. Re: Code works on my computer but not any other

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

    maybe Left(cell,1) <> "W" or something like that
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4