Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Adding Blank Cell Logic to Existing Formula

    Thank you all for the assistance.........DanteAmor.........dd/mm/aaaa;;"";@ worked perfectly. It really "cleaned" things up.
  2. Adding Blank Cell Logic to Existing Formula

    The formula below that is in W247 works correctly. You will notice if the lookup finds a value (the secondary VLOOKUP logis), that the formula returns the value in column 9.
    But if the value for...
  3. Replies
    3
    Views
    78

    Re: Adding Logic to an Existing Formula

    wow.......thank you both. Now that I see it, I should have been able to figure it out. Thanks so much
  4. Replies
    3
    Views
    78

    Adding Logic to an Existing Formula

    I would appreciate some assistance.
    I cannot get the desired results when I try to add to an existing, working, formula

    The formula below works perfectly, but, I would like to add another...
  5. Replies
    1
    Views
    105

    Custom Format of Numbers

    I am trying to figure out how to create a custom format for numbers. Is it possible to do this?

    Positive Number Display (in color black)
    145.00
    Negative Number Display (in color red)
    (-145.00)
  6. Replies
    4
    Views
    136

    Re: VLOOKUP vs INDEX-MATCH

    this is a sample of the data
    C84025681

    all beings with letter C and ends with 8 numbers
  7. Replies
    4
    Views
    136

    VLOOKUP vs INDEX-MATCH

    I use vlookup all the time. For whatever reason it keeps returning #N/A on every cell.
    I can only suspect that the data that was provided is somehow messed up
    I want to try using INDEX MATCH...
  8. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    Joe4

    I decided to start from scratch with a brand new worksheet. And you have provided works as expected. Thank you so much for your willingness to share your knowledge. This tool will really...
  9. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    Hi Joe4.............I am going to put this effort on hold for a couple of days due to my work load. Needless to say I am not familiar with VBA functions so I will have to take the time to learn what...
  10. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    I tried again and used the defined function that you provided
    put =IPtoNum(A3) in a cell and it returned #NAME ?
  11. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    I made sure that the From, To and Search numbers are all valid numbers. I did a =VALUE(X) against all of them and used the resulting data
  12. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    all 3 return false
  13. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    replaced with =IF(COUNTIFS(Q:Q,"<=" & S3,R:R,">=" & S3)>0,"Yes","No")
    still get the same results
  14. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    Joe4

    Ran into a problem
    Q is my converted From range
    R is my converted To range
    S is the value I am looking up
    D is where the formula resides

    In cell D3 I have =IF(COUNTIFS(Q:Q,">=" &...
  15. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    Thanks so much Joe4
    This will save alot of time in future
  16. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    I am going to give this a try a bit later in the day.............but want to thank you for all of your time and willingness to assist me with this. If will come into great use for time to come with...
  17. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    I was able to successfully convert the IP addresses to numbers
  18. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    Thanks Joe4

    I have the following ranges of IP addresses that I will search against
    (For example purposes I am just going to provide the first 50 ranges)
    Note that these ranges are in columns A...
  19. Replies
    27
    Views
    383

    Re: Formula Not Returning Expected Value

    The formula that TriAxisZero sent =IF(OR(AND($F$2>=A4,$C$2<=B4),AND($F$2>=A5,$C$2<=B5)),"YES","NO")
    works properly
    Ultimately I am trying include conditions that not only include A4, B4 and A5, B5...
  20. Replies
    27
    Views
    383

    Formula Not Returning Expected Value

    Can someone tell me why this formula is returning "FALSE" opposed to "YES" or "NO" ?
    I have a feeling the brackets are incorrect
    ...
  21. Re: Search for an IP address Using a Set of Ranges as Search Criteria

    ScatmanKyle
    Thank you for the response
    I am not getting the results that I would expect to get
    By using your formula and using the value of 10.126.198.24 in C2
    The formula returns "no".
    It...
  22. Re: Search for an IP address Using a Set of Ranges as Search Criteria

    I am going to repost and try to make my original attempt less confusing

    Below is a table of seven IP address ranges
    The addresses are located from A2:B8

    From To...
  23. Replies
    1
    Views
    221

    How to Upload/Attach File to Post

    Is there a way to attach either an Excel file or a jpg a thread?
    What is the size limitations?
  24. Search for an IP address Using a Set of Ranges as Search Criteria

    I am trying to create a tool that will allow you to paste a column of IP addresses and have each address searched for in a range of IP addresses. For each address found in a range then Excel returns...
  25. Replies
    4
    Views
    117

    Re: How to Trim Once Open Parenthesis Appears

    Thanks a bunch Fluff
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4