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

    Help on "Yes's" and "No's" for matching data

    Hello: I used the IFERROR formula to create yes's (when two columns of data have matches) and no's (when two columns of data don't have matches). My example appears to work for a lot of the data; however; I've found on some where they should have responded 'no' when they responded 'yes.'...
  2. L

    VLOOKUP: creating "Yes's" and "No's" for "matching" data

    Hi Azumi, You helped me learn the "IFERROR." I tried it on this data set. I think most of it's working. But I do seem to notice some columns (those 'compare' ones D, E, and F particularly) where I seem finding some "No's" when they should be "Yes's;" or some "Yes's" when they should be "No's."...
  3. L

    FINDING same data (but NOT use "Remove" Duplicates)

    Greetings: Obviously I have a simplified sheet for simplicity.:DD I manually highlighted what I mean by duplicate rows. Where I work, I could have like over 4,000 rows of data of addresses that are like this. Can you show me another method to find them? Thank you!
  4. L

    VLOOKUP: creating "Yes's" and "No's" for "matching" data

    THANK YOU!!!! Knew I could count on my 'PEEPS!"
  5. L

    VLOOKUP: creating "Yes's" and "No's" for "matching" data

    Say you have the the data as shown in my attached sample file. (The coloreds are manual for me to see which ones in the two columns "match." There're a total of "7" matches) What are my VLOOKUP "steps" to find which ones "match" between these two columns such that the resulting (3rd) columns...
  6. L

    Finding a match value in 2 columns - See attached XL file

    This TOTALLY WORKED on my real-life data @ work! Y'all ROCK! THANK YOU!!!!
  7. L

    Finding a match value in 2 columns - See attached XL file

    Hello! Question: What 'formula' can I use to easily find exact matches in these two columns? For simple example, COL A and COL B both contain exact match 1011 Likewise, COL A and COL B both contain exact match 1213. I know there's a way we can incorporate...
  8. L

    Moving in a single cell to add text directly underneath existing text

    Hello, Say I have one cell, name it A1. Let say I have this: I am LisaAnn. How do I get "I am Blue's parent" directly underneath "I am LisaAnn" easily in that same cell A1? So that it looks like this? I am LisaAnn I am Blue's parent
  9. L

    Displaying numbers from rows into ONE column in ONE cell

    Hi Bosco! This non-VBA method worked like a CHARM! I LOVE IT! THANKS SOOOOOO MUCH!! LAP
  10. L

    Displaying numbers from rows into ONE column in ONE cell

  11. L

    Displaying numbers from rows into ONE column in ONE cell

    MS excel for Mac 2011. But even at work, I'm using just MS excel 2010.
  12. L

    Displaying numbers from rows into ONE column in ONE cell

    Hello all, Please see my "Workbook1" attached and let me know if my question in there makes any sense? If it does, do you know how to do it? Thanks again! I tried simplifying it as best I could. I have a situation like this, but with of course, many more data than what I illustrate. Thanks...
Back
Top