Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    72

    Hi RG The csv file is ~19MB in size. If I...

    Hi RG

    The csv file is ~19MB in size.
    If I saved it in .xlsb format, it reduces to ~15MB
    zipping the csv file makes it ~7.7MB
    These are all too large for posting here.
    But, by disguising the...
  2. Replies
    5
    Views
    72

    Hi Well, the test worked for me. NOTE: Max...

    Hi

    Well, the test worked for me.
    NOTE:
    Max size for posting a zip file here is 5.75MB
    Max size for a pdf file is 8.11MB

    So I saved the 7.53MB "pdf" file, renamed it as 125000.zip, then...
  3. Replies
    5
    Views
    72

    Sample data file with 125,000 records

    Hi

    This is a test for posting a large datafile to this forum.
    The sample file contains 125,000 records with these data columns:...
  4. Replies
    32
    Views
    2,580

    Hi Don Thanks for the alternative import...

    Hi Don

    Thanks for the alternative import method.
    Very nice.

    zeddy
  5. Replies
    32
    Views
    2,580

    Hi Maud Thanks for the compliment! Re post#17...

    Hi Maud

    Thanks for the compliment!
    Re post#17

    I enjoyed that challenge!

    zeddy
  6. ..are you talking about North Carolina? zeddy

    ..are you talking about North Carolina?

    zeddy
  7. Hi cmptrgy Thanks for explaining what dates...

    Hi cmptrgy

    Thanks for explaining what dates prior to 1900 are used for.
    Re: The result should be 58", << this is the result of [A2] - [A1] i.e. the age of the person if [A1] = birthdate and [A2]...
  8. Hi RG What's a YMMV situation?? (you got me...

    Hi RG

    What's a YMMV situation?? (you got me back there :huh: )

    42412

    As you can see, I don't get the mm/dd/yyyy as asked for.

    zeddy
  9. Replies
    13
    Views
    272

    Hi Howard ..in my vba method, the data is in...

    Hi Howard

    ..in my vba method, the data is in the same order as the Ref no appears in column [A].
    You could easily sort the returned data 'properly' if you wanted.

    zeddy
  10. Replies
    13
    Views
    272

    Hi Howard ..here's my vba method of getting...

    Hi Howard

    ..here's my vba method of getting your data:


    Sub getValuesFromInputSheet()

    [e2] = "=a2"
    [f2] = "=SUMIF(INPUT!A:A,e2,INPUT!F:F)"
    [g2] = "=SUMIF(INPUT!A:A,e2,INPUT!G:G)"
  11. Replies
    7
    Views
    332

    Hi oddy So, to put your example into ways I...

    Hi oddy

    So, to put your example into ways I can understand...

    You have a Master sheet which contains a list of targets, and a list of assassins.
    You want to create a tab sheet for each...
  12. Hi Maud: top-marks for a shorter method! RG:...

    Hi
    Maud: top-marks for a shorter method!

    RG: for even less typing:

    [d3] = Format(Format([d3], "####-##-##"), "mm/dd/yyyy")

    But, you should be aware that this will NOT actually display the...
  13. that sounds like the Depression. too cold for...

    that sounds like the Depression.
    too cold for me, rather be in La Jolly

    zeddy
  14. Hi RG Your post#15 :rolleyes::):cool: zeddy...

    Hi RG

    Your post#15 :rolleyes::):cool:

    zeddy
    (I can do smileys now!)
  15. Hi RG So I see this forum has moved to Los...

    Hi RG

    So I see this forum has moved to Los Angeles?
    Is it warmer than New York there?
    Haven't been to LA for a while.

    zeddy
  16. Hi As far as dates prior to 1900, are they...

    Hi

    As far as dates prior to 1900, are they still alive?
    Can't you put them onto another tab??

    or amend code to use
    .. Like "19######"
    which would skip these entries like 18991207 etc etc
    ...
  17. Hi ..you have four formulas in cell [O2], you...

    Hi

    ..you have four formulas in cell [O2], you should only have one!!

    RG wasn't missing anything at all!
    ..but using xxx Like "########" will trap for other invalid cell contents e.g 194712,...
  18. Replies
    13
    Views
    272

    Hi Howard I don't understand your example....

    Hi Howard

    I don't understand your example.
    Can you have another go at explaining what you are trying to do.

    zeddy
  19. Hi try this.. Sub convertDates() ...

    Hi

    try this..


    Sub convertDates()

    Application.ScreenUpdating = False

    For Each cell In [d2:d2001] '<< adjust range required
  20. Hi ..you could use code like this: Sub...

    Hi

    ..you could use code like this:


    Sub convertDates()

    Application.ScreenUpdating = False

    For Each cell In [d2:d2001] '<< adjust range required
  21. Hi Megan my apologies! I didn't see that file...

    Hi Megan

    my apologies! I didn't see that file link!
    I'm used to seeing attachments at the bottom of the post.

    Maud to the rescue!

    zeddy
  22. Hi Welcome to the Lounge! ..now attach your...

    Hi

    Welcome to the Lounge!
    ..now attach your file as promised.

    zeddy
  23. Replies
    2
    Views
    74

    [SOLVED] Hi ..you need to forget about years and leap...

    Hi

    ..you need to forget about years and leap years, and just remember there are 52 weeks x 7 days in a year for your purposes.
    So, a date in [B6] and for the same day last year, just use...
  24. Replies
    7
    Views
    332

    where's oddy? zeddy

    where's oddy?

    zeddy
  25. Replies
    4
    Views
    110

    Hi Suppose your data shown in post#1 starts in...

    Hi

    Suppose your data shown in post#1 starts in row 1, column [A].
    You could then use this vba code snippet to filter the column [D] data for those with values:


    [A1].CurrentRegion.AutoFilter...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4