Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    61

    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
  2. Replies
    3
    Views
    61

    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...
  3. Replies
    1
    Views
    87

    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)
  4. Replies
    4
    Views
    121

    Re: VLOOKUP vs INDEX-MATCH

    this is a sample of the data
    C84025681

    all beings with letter C and ends with 8 numbers
  5. Replies
    4
    Views
    121

    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...
  6. Replies
    27
    Views
    329

    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...
  7. Replies
    27
    Views
    329

    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...
  8. Replies
    27
    Views
    329

    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 ?
  9. Replies
    27
    Views
    329

    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
  10. Replies
    27
    Views
    329

    Re: Formula Not Returning Expected Value

    all 3 return false
  11. Replies
    27
    Views
    329

    Re: Formula Not Returning Expected Value

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

    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,">=" &...
  13. Replies
    27
    Views
    329

    Re: Formula Not Returning Expected Value

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

    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...
  15. Replies
    27
    Views
    329

    Re: Formula Not Returning Expected Value

    I was able to successfully convert the IP addresses to numbers
  16. Replies
    27
    Views
    329

    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...
  17. Replies
    27
    Views
    329

    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...
  18. Replies
    27
    Views
    329

    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
    ...
  19. 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...
  20. 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...
  21. Replies
    1
    Views
    201

    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?
  22. 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...
  23. Replies
    4
    Views
    106

    Re: How to Trim Once Open Parenthesis Appears

    Thanks a bunch Fluff
  24. Replies
    4
    Views
    106

    How to Trim Once Open Parenthesis Appears

    I have a bunch of cells that I need to trim off everything once and open parenthesis is found, including the open parenthesis
    Is there a formula that will do this?

    I have a few examples below...
  25. Re: Adding Data From Multiple Cells to One Cell

    If there is no value for the "Dock" (column C), is there a way to omit that line"

    All of my addresses do have number/street, city, state, zip
    But not all have a dock

    The formula in cell AE217...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4