+ Reply to Thread
Results 1 to 14 of 14

compare A and C column if match my logic display result in B column

  1. #1
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    compare A and C column if match my logic display result in B column

    many many thanks to all expert., am very happy to being in this site, my credits to you all friends..

    i need formula to below logic,

    see my sample file, i want find "suspend number errors"

    In A column i give number status, In C column i give errors,

    i need result in B column, In A column any "Susp for TV process Rental Charging" word match in any error message in C column then display "Susp for TV process Rental Charging" in C column,

    pls must see my sample file, you can guess easy,

    thank you all.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: compare A and C column if match my logic display result in B column

    use this formula
    =IF(AND(LEFT(A2;4)="susp";C2<>"");A2;"")
    And remove the spaces in column C
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: compare A and C column if match my logic display result in B column

    Im not exactly sure what you want, your explanation is a little confucing (to me, anyway)

    To test for certain contents in a cell, try something like this...
    =IF(A2="Susp for TV process Rental Charging",1,"")

    Yoy can change the ,1, and the ,"") to whatever you want.
    =IF(A2="Susp for TV process Rental Charging",do this,do that)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    popipipo your formula is not working, anyway thanks,

    fdibbins, i dont want replace "susp for TV process Rental charging" this word,


    simple logic, see new updated sample file
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: compare A and C column if match my logic display result in B column

    Another attempt
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    Yah popipipo, your idea is good, only one thing, please hide "React for TV process Rental Charging" in B column, Thats all.

  7. #7
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    hi anyone one solve my problem,

    see my sample file,

    u can understand..
    i have a mobile number status, we can know which numbers are activated and suspended,

    Some service may be not given in activated numbers such as gprs service, sms service such as....(we called as errors)
    Attached Files Attached Files

  8. #8
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: compare A and C column if match my logic display result in B column

    Maybe something like this :
    In E1:
    Susp for TV process Rental Charging
    (this is the message to look for)

    in C2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    drag down

    (note I had to add the TRIM()s to get the matches to work, as some cells have extraneous spaces in them)
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  9. #9
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    your formula is not working,

    look my last sample file, in column B error message based on the below formula, this formula filled in my original excel, i copied that original excel and pasted as paste special value in new sheet, i given that sheet to you,

    =""&H2&" "&K2&" "&N2&" "&Q2&"" (totally 6 spaces in this formula)

  10. #10
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: compare A and C column if match my logic display result in B column

    what is not working ?
    see attached
    I inserted a new d column to allow for a comparison to what you showed (all added is highlighted in blue)
    This changes the formula to this(because of the column insertion)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    But the original in column c will produce the same results with the new column deleted

    Please show/explain which answers do not meet your requirements ?
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    wow..... superb dear buddy... its working, hearafter i can work quickly, you saved my time, i can create pivot easy, thanks a lot my dear friend.. if you have time just explain how your formula works.. i will learn through from you...

  12. #12
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    if possible could you create again a formula to just join error and React for TV process Rental Charging (just opposite to my previous logic)

    take your own time,
    thank you dear buddy...

  13. #13
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: compare A and C column if match my logic display result in B column

    The formula will be the same just change the $E$1($F$1 for my upload)) value to "React for TV process Rental Charging"

  14. #14
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: compare A and C column if match my logic display result in B column

    The formula works this way
    1st it checks if the (trimmed) text in column B is ="" (Blank), if it is then error column is ="" (Blank), if it is not, check the (Trimmed) text in A column against the value in E1(or F1 in unedited worksheet), if they are the same, take the error in column B , add a space (" "), and add the message in A column, if neither is true, blank ("")

    I made this use the messages in A column & B column to get as much flexibility as I could see for what you want, this is why the simple change for the new values, if want it more complex, then I think we may have to got to ARRAY formulas or beyond

    Edit-
    (cont-) read up on logic statements/formulas, etc., if you need multiple A condition requirements as well, IT can be done with nested IF's (USUALLY), but there are sometimes better/easier ways ...

    Hope this helps
    Last edited by dredwolf; 11-03-2013 at 02:13 AM.

  15. #15
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    Re: compare A and C column if match my logic display result in B column

    great idea, you are brilliant, superb very wonderful, many thanks to you dear friend...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 06-06-2013, 12:51 PM
  2. Compare values in column a to column b, and put it in column c if they match
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2013, 07:52 PM
  3. [SOLVED] Compare text in column B, C match with sheet 2 A:A and get result in E
    By Daniel Chang in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2013, 02:21 AM
  4. data in 2 column and display the desired result in 3rd column
    By vaz_saz in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-02-2013, 05:37 PM
  5. Replies: 2
    Last Post: 06-23-2011, 11:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1