Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Export Excel CSV to MS word with specific table format

    GENIUS! Thanks originalsauce & John_w! I had to tweak the code a bit, only have 10 columns, & kept bombing out on the last c = 7 To Unbound part, but modified to reflect splitting rows above from...
  2. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Yup, can't use Fuzzy Join. But pinarello, I've copied all your info down when my co. updates. Great to know, & thanks for all your help & hard work! @ sandy666, much obliged. I'm not sure if she...
  3. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    https://1drv.ms/x/s!AopTvf3RGAN5kkAOdQcbf54PUjcr is sandy's file
    https://1drv.ms/x/s!AkzPnN34efhMsSqbTEzSMzl0Gut1 is German's link
  4. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    ok, thanks to you both. For you sandy666, the worksheet is protected so I can't see the query. What's the password please? I think we're really close. However, I can't view the queries due to...
  5. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Hi Sandy666,

    Started over by renaming Table1, Table2, insert blank query, replacing their source code w/ yours, & get this error:

    =Table.RenameColumns(ROC3,{{"Custom", "Last"}, {{"Custom.1",...
  6. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Let me start all over again. Think that's the best idea. I find this thread hard to follow sometimes & missed a few things. Failing this, do you have an email account? Thanks so much.
  7. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Hi sandy666,

    I've tried & am blind now parsing through code. Am not getting it, so sorry. Can you please look at file & lmk where I went wrong. I was very careful to re-type your code with...
  8. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Hey Sandy666, brilliant! Can you help me a tad, I don't know this part of Power Query but yes I have it & use it. How do I get this code in? What I did: created two queries called Table1 and...
  9. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Pls. let me know if this link didn't work. Thanks~
  10. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    https://netorg834590-my.sharepoint.com/:x:/g/personal/pmontgomeryfernald_atekinc_com/EXQ8vjJmxcNIpsq3XjO4nqYB5OmtbAEx585Sdjqc2ubwUw?e=qbWQkx
  11. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    https://netorg834590-my.sharepoint.com/:x:/r/personal/pmontgomeryfernald_atekinc_com/Documents/Copy%20of%20Dummy%20Data.xlsx?d=w32be3c74c56648c3a6cab75e33b89ea6&csf=1&e=b1hOls
  12. Replies
    29
    Views
    3,974

    Re: Merging UnEven Names in Power Query

    Dear sandy666, will do. Asked client for requisite file; please stay tuned. Do you want me to email you or use DropBox? Thanks!
  13. Replies
    29
    Views
    3,974

    Merging UnEven Names in Power Query

    Greetings!

    Would anyone out there be so kind as to tell me how to merge uneven names?
    For example:
    File1 has 3000 rows or names.
    File2 has 4000 rows of names. Customer wants the last name and...
  14. Re: Using Concatenate in DAX in PowerPivot as a Measure

    Thanks very much! I knew it was fairly simple, & that it only accepted two text strings, but just couldn't get there. Thx. again!
  15. Using Concatenate in DAX in PowerPivot as a Measure

    Good Day,

    Thank you in advance for answering this question. I can't combine two fields with an "x" value. For example, I'm combining lumber height & width so I write a calculated column...
  16. Re: Counting Individual characters in ONE cell, which each cell changes the character to count

    Again, thanks Mumps! Have a terrific day...
  17. Re: Counting Individual characters in ONE cell, which each cell changes the character to count

    Hi Mumps, thanks! I tested it and it works superbly. I guess there isn't a way in Excel to specify a particular character or text string from ONE cell short of using macros. Thanks so much for your...
  18. Counting Individual characters in ONE cell, which each cell changes the character to count

    Hi Everyone,

    I've scoured previous posts in the hopes of not creating a new thread, and found some great stuff, but it's not 100% accurate and also I'm not getting it. Here's what I'm trying to...
  19. Provide the intersection of two results with date formulas

    Good Morning,

    Thanks in advance for your help.

    I have a complex sumproduct that totals unique values in a date range. It adds the request that are obligated and the requests that are...
  20. Re: Best way to create and use constants in Power Pivot?

    I note that you're not using ALL? Try the general idea below:
    <code style="background-color: rgb(239, 240, 241); border-bottom-color: rgb(36, 39, 41); border-bottom-style: none;...
  21. SLOPE formula for study results with non-continguous cells

    Hi You Excel Geeks! I'm flummoxed...how to use SLOPE formula for non-contiguous columns? We can click on each ending date for a study participant, but TOO MUCH data entry. Plus we forget where we...
  22. Re: Countif or Sumif or Match? Counting exponents that are labels but weird results

    I must be doing something wrong, as the No1's are 5 points and the U19's are 3. I played around, transposing your 5's & 3's. When I add a ^ it adds a point. Can I send you the file to a DropBox...
  23. Re: Countif or Sumif or Match? Counting exponents that are labels but weird results

    I'm thinking a macro with sumbycolor? Seems too complex to count various carats in various cells, some together. However,
    1. Thanks for your quick answer. Yes, to F30 (F30, F31, F32, F33, F34,...
  24. Re: Countif or Sumif or Match? Counting exponents that are labels but weird results

    He added new criteria where the formula doesn't work: REVIEW MECHANISM LIST



    <tbody>
    Mechanism

    Reviewable Unit #s
  25. Re: Countif or Sumif or Match? Counting exponents that are labels but weird results

    Perfecto thisoldman! I've never used IFERROR & it's years since RIGHT, LEN & SEARCH. *Wow.* ^ ;) Read my Mr. Excel book (Power Excel) and the question starts with: "Using Left, Mid, Right, Find,...
Results 1 to 25 of 33
Page 1 of 2 1 2