Search:

Type: Posts; User: Jeffrey Green; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Highlight Row above an already highlighted row or...

    i have 100,000 with about 15,000 lines that highlighted because there is a TRUE in and AND formula in the row.
    I just filtered for TRUE< then highlighted in Yellow fill.

    Now they want me to...
  2. Replies
    3
    Views
    102

    Re: Conditional Formatting issue

    hi, thanks . . . not sure how that would work . . .
    if all rows were bad, let's start at row 1.

    I need AC1 to equal G1
    I need AC2 to equal G2
    etc.

    thanks
  3. Replies
    3
    Views
    102

    Conditional Formatting issue

    i have a list of 100,000 rows.
    the first 52229 rows or so are fine.

    i pulled in the Tariff code into column AC, starting in row 52330 (everything above is fine, now i want to check tariff...
  4. Re: Split sheet by Part number stops after second row.

    Resolved . . . my data had embedded control characters, such as LF and CRs. I think that fixed it (CLEAN). I found that because i dumped those parts in a SQL temp table and SQL blew up.
  5. Split sheet by Part number stops after second row.

    I use split sheet all the time.
    sheet is sort by Part number, no empty rows
    but when i split sheet by part number, it stops on row 3

    ive restarted, no joy, thoughts?

    thanks
  6. Split sheet by Group, but i dont have column headers

    i need to split a sheet by group, and it works as usual, but i dont have column headers and Easy-XL thinks my first row is the column header . . . . . and it appears on all split tabs.
    Do i really...
  7. Re: vlookup (or other function) to pull multiple matches in the look up table

    I knew this would happen . . . . . Although i would like to know the solution above, what i decided to do the old STACK 'Em up method. Add another column next to my Unique list, then STACK my two...
  8. vlookup (or other function) to pull multiple matches in the look up table

    In column A I have a distinct part number.
    In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd...
  9. vlookup (or other function) to pull multiple matches in the look up table

    In column A I have a distinct part number.
    In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd...
  10. Replies
    6
    Views
    734

    Re: New to DAX . . . simple RELATED

    yes, much easier . . . . Solved with a lot less pain. Thanks TheBard
  11. Replies
    6
    Views
    734

    Re: New to DAX . . . simple RELATED

    i will try that, thanks!
  12. Replies
    6
    Views
    734

    Re: New to DAX . . . simple RELATED

    I did at the beginning; I thought fixed that; but i re-did entire process from the start . . it is ok now . . . BUT
    I was able to do my RELATED in the Data Model, but how do i update the EXCEL...
  13. Replies
    6
    Views
    734

    Re: New to DAX . . . simple RELATED

    ah, it seems like my relationship isnt staying as i set it. i am setting TABLE1/Column1 = Table2/Column1. But when i look at it again in MANAGE RELATIONSHIPS, it reversed. and if i do the RELATED...
  14. Replies
    6
    Views
    734

    New to DAX . . . simple RELATED

    i did this years ago, but cant replicate what i did.

    I have Table1 and Table2 and with a relationship of Column1 = Column1.
    there is only one column in table1 and two columns in table 2.

    All...
  15. finding substring from a string with dashes

    I have parts in the following format:


    <tbody>
    ABVD-JtU5d-NR393. Where the prefix, base and suffix can be any length., but there are always two dashes.

    I need to add a column to show the...
  16. Find SKU price from a history of prices if i know the sales date

    i have a list of SKU's on Sheet 1.
    I have historical pricing on sheet 2 by SKU and price date.
    I am trying to "vlookup or Index/Match, etc to bring in the historical price into sheet 1 that is...
  17. Replies
    12
    Views
    787

    strip off leading zeros

    <tbody>
    00080236528-GP0KA

    I need the leading zeros to go away.
    leaving me with

    <tbody>
    80236528-GP0KA

    thanks
  18. Re: URGENT!!! remove everything after a second dash in a string (and the second dash)

    You are a life saver!!!!!!!!!!!!!!!!!!!!!! THANKS SO MUCH, perfect. Not sure how it works, but good for now!
  19. URGENT!!! remove everything after a second dash in a string (and the second dash)

    I have this

    <colgroup><col></colgroup><tbody>
    1174958190-B33TB-DAA


    1174988827-B33TB-RTR


    1175002840-B33TB-
  20. Replies
    4
    Views
    130

    Re: Getting #N/A on a sumif formula!

    SOLVED . . i had one #N/A in my DUTYifPAID column
    thanks
  21. Replies
    4
    Views
    130

    Re: Getting #N/A on a sumif formula!

    No, and i even deleted the named ranges, and recreated them with different names, same
  22. Replies
    4
    Views
    130

    Getting #N/A on a sumif formula!

    I do sumifs ALL the time. I used NAMED RANGES, all the time.

    Today, when i enter
    <tbody>
    =SUMIF(OnZats,"Y",DutyifPaid)

    </tbody>
    and

    <tbody>
  23. Replies
    1
    Views
    115

    Re: Odd vlookup behavior

    Solved, i am an idiot. :) There were 25 columns, i wanted 25, not 24. Column 24 had "#N/A" from a formula in that cell. duh
  24. Replies
    1
    Views
    115

    Odd vlookup behavior

    I have named range called REMOVE.
    REMOVE is 24 Columns wide
    When I enter
    <tbody>
    =VLOOKUP(A2,REMOVE,20,0), i get a valid response.
    When enter
    <tbody>
    =VLOOKUP(A2,REMOVE,24,0)
    I get #N/A...
  25. Replies
    7
    Views
    241

    Re: Networkdays odd behavior

    yes, joe, yours is better . . . sorry, i hadnt seen that reply when I replied, thanks for taking the time!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4