Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    29

    Hi RG ..an effective solution from the Master.

    Hi RG

    ..an effective solution from the Master.
  2. Replies
    6
    Views
    96

    Hi Howard aside from RG's method, you could...

    Hi Howard

    aside from RG's method, you could use a 'helper column' to check the first lookup, then check the returned value against an entry in a named range.

    see attached file.

    I used a...
  3. Replies
    13
    Views
    267

    Hi joela44 Thank you for your kind words! ...

    Hi joela44

    Thank you for your kind words!
    It's always nice to be appreciated, whatever you do.
    There are many others in this Lounge that I really look up to too.
    I've learned much from them,...
  4. Replies
    5
    Views
    93

    Hi aidan ..I like your formula! (but the two...

    Hi aidan

    ..I like your formula!
    (but the two formulas will give different results if there is an error e.g. if you put any text or negatve number in F5)

    zeddy
  5. Hi cosmlou I think you need to use column B as...

    Hi cosmlou

    I think you need to use column B as a 'helper' column for what you want.
    But you can always delete that after the sort has been done.

    In my attached file, I have added sample test...
  6. Thread: Combining code

    by zeddy
    Replies
    57
    Views
    1,623

    Hi Murgatroyd ..just catching up with this...

    Hi Murgatroyd

    ..just catching up with this again. Need to find my previous stuff.

    zeddy
  7. Replies
    13
    Views
    267

    Hi Murgatroyd Thanks for the follow up. Your...

    Hi Murgatroyd

    Thanks for the follow up.
    Your solution to use a single cell would do the job nicely.
    Note: You can always increase the row width (as well as column width) and use word-wrap...
  8. Replies
    17
    Views
    439

    Hi Excelnewbie ..to answer your question in...

    Hi Excelnewbie

    ..to answer your question in post#1:
    instead of..
    iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1

    ..you can use...
  9. Replies
    8
    Views
    116

    Further info: BEWARE! ..those new Excel 2016...

    Further info:

    BEWARE!
    ..those new Excel 2016 functions are only available if you have the subscription version of Excel 2016 e.g. as part of Office365 subscription.

    ..if you send an Excel2016...
  10. Replies
    4
    Views
    117

    Hi I have 5 versions of Excel running quite...

    Hi

    I have 5 versions of Excel running quite happily on one of my laptops.
    (Excel2003, 2007, 2010, 2013, 2016).
    (I like having that flexibility)

    I find the simplest way to load an excel file...
  11. Replies
    8
    Views
    116

    Hi Just for info: In Excel 2016 the new...

    Hi

    Just for info:
    In Excel 2016 the new =IFS(..) function allows up to 127 different conditions to be tested.
    The function returns a value that corresponds to the first TRUE condition.

    IFS...
  12. Replies
    13
    Views
    267

    Hi Murgatroyd My posted file in post#8 creates...

    Hi Murgatroyd

    My posted file in post#8 creates the pdf on my system.
    (it's in the same location as the excel file; you could try to search for it).
    (You need to save the posted file first of...
  13. Replies
    13
    Views
    267

    Hi Murgatroyd OK. So my post#2 and post#4...

    Hi Murgatroyd

    OK. So my post#2 and post#4 answered what you asked for in your post#1
    Your post#5 is asking a different question i.e. "after saving as a pdf with the pdf link working, keep the...
  14. Replies
    13
    Views
    267

    Hi Murgatroyd Yes, that can be done. I'll...

    Hi Murgatroyd



    Yes, that can be done.
    I'll post a solution when I get back after my checkup.

    zeddy
  15. Replies
    13
    Views
    267

    Hi Murgatroyd I tested this OK before I...

    Hi Murgatroyd

    I tested this OK before I posted.
    So let's try this again.

    In the attached files,
    1. starting with file [rz-test-0.xlsx]
    ..I put a hyperlink formula in cell [C12]

    2. I copy...
  16. Replies
    13
    Views
    267

    Hi Murgatroyd Copy the cell with ...

    Hi Murgatroyd

    Copy the cell with
    =HYPERLINK("http://www.example.com?"&"name="&A1&"&address="&B1, "Click here")
    formula into Word.
    Now copy back from Word into the cell.
    The hyperlink is no...
  17. Thread: solve for T

    by zeddy
    Replies
    7
    Views
    127

    ..that looks like water under the bridge to me. ...

    ..that looks like water under the bridge to me.

    zeddy
  18. Thread: solve for T

    by zeddy
    Replies
    7
    Views
    127

    ..so that means T=0 zeddy

    ..so that means T=0


    zeddy
  19. Thread: Counting Formula

    by zeddy
    Replies
    22
    Views
    479

    Hi dubdub ..the attached file is your original...

    Hi dubdub

    ..the attached file is your original posted file with rory's formula entered in [c9:f9].
    ..compare that with what you are using.

    zeddy
  20. Replies
    39
    Views
    26,985

    Print pdf files via Excel

    Hi

    I have attached my latest version of a tool to print pdf documents.
    This tool allows you to select a folder for pdf files, or to manually search and choose pdf files for printing.
    You can...
  21. Hi There was a bug in Excel 2007 that changed...

    Hi

    There was a bug in Excel 2007 that changed all general formats to a [$-409] type date format.
    (It sometimes happens in shared workbooks).

    To fix your issue:
    1. open the workbook
    2. select...
  22. Replies
    12
    Views
    219

    Hi You can create a custom format to give you...

    Hi

    You can create a custom format to give you exactly what you want.
    Excel custom formats are defined in four Sections, separated by semicolons:
    Positive numbers; Negative Numbers; Zero Values...
  23. Replies
    2
    Views
    108

    Hi The array formula you need for the passing...

    Hi

    The array formula you need for the passing score in cell [B3 is:
    =MIN(IF(A8:A208=$E$3,B8:B208))
    (use ctrl-shift-enter to put the array formula in the cell)

    ..see attached file.

    zeddy...
  24. Replies
    9
    Views
    207

    Hi Howard see attached file, based on your...

    Hi Howard

    see attached file, based on your file in post#6

    Your Account codes in column [A] have a prefix ' apostrophe character.
    The formula assumes the account number is 6 digits.

    zeddy...
  25. Replies
    9
    Views
    154

    [SOLVED] Hi rory You are correct. I assigned a dummy...

    Hi rory

    You are correct.

    I assigned a dummy to me and used my hand to slap myself on the head.
    I lost track when I was testing in Excel2016 and earlier versions.

    zeddy
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4