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

    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)?
  2. 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
  3. 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?
  4. 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...
  5. W

    IF statement with multiple conditions

    =IF(C2=D2,"",IF(C2="FB","Move","Request"))
  6. 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,"@...
  7. 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...
  8. 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