• 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.

Search results

  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...
  16. W

    Strip hidden characters in a cell?

    Jai, it did work perfectly! Is there a way to insert a capital A before each of the nine digits?
  17. W

    Strip hidden characters in a cell?

    Jai, I put you formula in the empty cell above my highlighted column of numbers I needed to address, and the formula produced a perfect result for the first cell (see below). How can I get the entire column to yield the desired result? 205212168   205-212-168 It left aligned the result...
  18. W

    Strip hidden characters in a cell?

    I copy data from a "main frame" type system and paste the data into Excel. Here is an example: @ 087-911-153   200-872-404 @ 095-885-477   205-008-592 @ 074-614-622   094-121-771   072-348-032 The column of data can be fairly large. I then have to go to each cell manually --after using "search...
  19. W

    Compare list of numbers

    A column of three digit numbers exist A1 through A34: Another column of numbers exist B1 through B34-- How do I compare the two lists and highlight the differences?
Back
Top