+ Reply to Thread
Results 1 to 4 of 4

How to check data in 2 columns and write the results on the 3rd one?

  1. 11-27-2014, 12:03 PM #1
    sami770
    sami770 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    How to check data in 2 columns and write the results on the 3rd one?

    See the 2 files attached - blago1 & blago2

    In blago2, column B has numbers and column C has colors.
    I need a simple macro that will check the combinations in all cells of column B and C, and write the result in column G.

    There are only 21 possible combinations, you can see them in blago1 file...

    The solution mast be a macro based, not a formula

    Many thanks,

    Sami
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-27-2014, 01:19 PM #2
    sami770
    sami770 is offline
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Re: How to check data in 2 columns and write the results on the 3rd one?

    Any idea how to solve it?
    Reply With QuoteRegister To Reply
  3. 11-27-2014, 02:24 PM #3
    lulupatel
    lulupatel is offline
    Registered User
    Join Date
    04-17-2014
    Location
    DUbai
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: How to check data in 2 columns and write the results on the 3rd one?

    What about Column D and E Color.
    Reply With QuoteRegister To Reply
  4. 11-27-2014, 03:31 PM #4
    lulupatel
    lulupatel is offline
    Registered User
    Join Date
    04-17-2014
    Location
    DUbai
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: How to check data in 2 columns and write the results on the 3rd one?

    Find This file with solutin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index and match to check data and provide exception results
    By carisackc in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-27-2014, 05:37 PM
  2. [SOLVED] To move Data rows to columns against one cell so can write separate SQL insert statments
    By hadster016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 09:52 AM
  3. Macro to perform a task, write the results, perform the task, write the results . . .
    By lukegerd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2012, 03:14 PM
  4. How do I write a script for + or - results
    By rbaron in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2012, 10:02 AM
  5. Wanting to write results to array instead of sheet, results overwriting....
    By sarjuhindocha@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2005, 10:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1