• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Weldon

  1. W

    Find function combined with "if not found then do this. .

    That absolutely worked. . .Thank you so very much!!
  2. W

    Find function combined with "if not found then do this. .

    My find function is =MID(G5,FIND("LI",G5),7), but what can be done if "LI" is not found and I want to return a value of =right(G5,7)?
  3. W

    Two cells in different workbooks have the exact number, why does the VLOOKUP not find in an array?

    Thank everyone for your great help. Oddly, the problem was resolved copying one of the cells and using "special paste" values and number formats
  4. W

    Two cells in different workbooks have the exact number, why does the VLOOKUP not find in an array?

    It is important to note: that one of the cells contents was generated by a formula, and in the other workbook the exact same number exists not generated by a formula. When I key-in the number in the workbook with the cell derived by a formula the VLOOKUP array does find the cell and produces...
  5. W

    Two cells in different workbooks have the exact number, why does the VLOOKUP not find in an array?

    11/5/2015 DNS JEH 8:00 8:30 1 BAL GRANDE-MERCADO, GLENDA XIOMARA @ 205-475-594 ARMV 25 Released ES TABE, KEVIN M., ESQ. SP I P 205475594
  6. W

    Move the contents of a cell X rows/columns

    I just managed to make your suggestion work. I have a number of cells that I have to cut the contents and move down 7 and right 7
  7. W

    Move the contents of a cell X rows/columns

    Where I am deeply grateful, this is above my head. I do not know how to use VBA. I have tried in the past. Again,
  8. W

    Move the contents of a cell X rows/columns

    How do I copy the contents of a cell and move that value down 7 rows and left/right 7 columns?
  9. W

    IF statements with multiple variables

    You are the best! I am grateful, thank you!!
  10. W

    IF statements with multiple variables

    How do I construct an IF statement with multiple variables: =IF(C2=D2,"",IF(C2="FB", Move, "Request")) This statement says if C2 = "FB" then "Move" otherwise "Request. And works for only the value "FB" but I need the statement to evaluate IF(C2="FB, MCL, AVB, WSR, and so on. . .in other words...
  11. W

    IF statement with multiple conditions

    =IF(C2=D2,"",IF(C2="FB","Move","Request"))
  12. W

    Why am I getting the same value all the way down a column?

    That was IT! Thank you very much! Weldon
  13. W

    Why am I getting the same value all the way down a column?

    I have been using the formula below for months with no problems; showing this formula to coworker, on a different computer, it worked for cell A4 only but returned the result from cell A4 in every cell below all the way down the column. ="A"&TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A4,"@...
  14. W

    Strip hidden characters in a cell?

    Luke, Debraj, Jai Again, thak you all for your good help. I remain deeply grateful Weldon
  15. W

    Strip hidden characters in a cell?

    Debraj, I haven't tried your approach to this problem, but I did copy the formula down a column to the right of data as suggested by Luke M, and this did the trick; however, as a last step I needed to add a capital A to the left of the data (numbers). Any ideas? I cannot thank everyone for...
See more
Back
Top