Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    3
    Views
    202

    Re: Formula To Randomise Names

    That works well thanks. Would you mind explaining how that formula works please?
  2. Replies
    3
    Views
    202

    Re: Formula To Randomise Names

    I did try the Rand function and sorted by that column but I still had 3 names in successive rows etc..
  3. Replies
    3
    Views
    202

    Formula To Randomise Names

    I have a list of names layed out like below. I need a formula please to randomise them so no name is next to each other in the list. Thanks.


    <colgroup><col></colgroup><tbody>
    Louis Pearce

    ...
  4. Re: Remove Everything When Numbers End To Adjacent Column

    Just to recap my data starts in AE2 and would like the ends removed to column AF.
  5. Re: Remove Everything When Numbers End To Adjacent Column

    This doesn't appear to work either. It removes all my data in column AE and replaces it with numbers like 1.7, 0.4, 1.6 etc..? These happen to be in column A?!
  6. Re: Remove Everything When Numbers End To Adjacent Column

    Actually I need it for columns AE and AF please.
  7. Re: Remove Everything When Numbers End To Adjacent Column

    Nice one thanks
  8. Re: Remove Everything When Numbers End To Adjacent Column

    Sorry just noticed there are some numbers like this WA13381N-6G so the result is WA13381N-6. Where like the others it should be WA13381 and N-6G
  9. Re: Remove Everything When Numbers End To Adjacent Column

    Works good thanks
  10. Re: Remove Everything When Numbers End To Adjacent Column

    Sorry does not do anything.
  11. Remove Everything When Numbers End To Adjacent Column

    I have numbers as below. When the numbers end I want everything removed to the adjacent column. I cant use text to columns as there are varying lengths etc. So a code or formula please.

    P.S Some...
  12. Replies
    8
    Views
    211

    Re: Send Emails In Bulk From Spreadsheet

    Yes I did and just came up with errors
  13. Replies
    8
    Views
    211

    Re: Send Emails In Bulk From Spreadsheet

    Thanks for you help. I am going to have to forget it, outlook will just not install on Windows 10 correctly. If there was a way to use the preinstalled email on windows 10 it would be great.
  14. Replies
    8
    Views
    211

    Re: Send Emails In Bulk From Spreadsheet

    For some reason outlook will not install on my PC when I try to add my email, so there is no other email clients possible?
  15. Replies
    8
    Views
    211

    Re: Send Emails In Bulk From Spreadsheet

    Will this only work with outlook? I have windows 10 and use the email client that comes with that. Also will this send individual emails or one bulk one? I need individual ones as there will be...
  16. Replies
    8
    Views
    211

    Send Emails In Bulk From Spreadsheet

    I have a spreadsheet as below. Is there a macro that will open my email client and send an individual email in bulk to all in the sheet? Thanks


    <colgroup><col><col...
  17. Replies
    9
    Views
    196

    Re: Code To Remove Only 2 Rows

    Don't worry I used the formula and that done the job. Thanks.
  18. Replies
    9
    Views
    196

    Re: Code To Remove Only 2 Rows

    Thanks Joe I run the code and it completed but nothing moved to sheet 2? It looks like it removed them but didn't paste them onto sheet 2.
  19. Replies
    9
    Views
    196

    Re: Code To Remove Only 2 Rows

    Sorry the data starts in A to AV. I thought I would just include the important data to make it clearer.
  20. Replies
    9
    Views
    196

    Re: Code To Remove Only 2 Rows

    Is this a complicated code I am needing?
  21. Replies
    9
    Views
    196

    Re: Code To Remove Only 2 Rows

    Can anyone help with this please?
  22. Replies
    9
    Views
    196

    Re: Code To Remove Only 2 Rows

    I hope I explained this ok, please post should you need clarification.
  23. Replies
    9
    Views
    196

    Code To Remove Only 2 Rows

    I have a sheet as below. Whenever there are 2 rows only that match in K then I want them removed to another sheet. This must be when there is one heater blower and one heater in column AF. So in this...
  24. Replies
    3
    Views
    83

    Re: Easiest Way To Concatenate

    I was doing it wrong, seems to do what I need. Thanks.
  25. Replies
    3
    Views
    83

    Re: Easiest Way To Concatenate

    Thanks, probably doing it wrong but just get results of #VALUE !
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4