+ Reply to Thread
Results 1 to 4 of 4

Conditional Match Rows, then Output data

  1. #1
    Registered User
    Join Date
    12-10-2018
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    19

    Conditional Match Rows, then Output data

    Hello Excel Forum super users...

    I have a problem here in matching rows of data by a strict condition, then upon a match, I want to output text depending on the type of data encountered in the matching rows.

    I could do it manually by sorting it nicely, but I have thousands of rows to do and I don't want to do this all day

    Please help me with a vba code..
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-04-2019
    Location
    U.S.
    MS-Off Ver
    2016
    Posts
    48

    Re: Conditional Match Rows, then Output data

    Mr. sotplugy,

    Good morning sir!! I think we are gonna need a little more information on what you need. I do see the information you want to search and match inside the file, however, #2 says to print the X of chain / the X of T in Ocode. You want this actually sent to the printer?? Or do you mean you want this copied into another cell?? #3 says you want to sum up some numbers, but you didn't specify where you want the numbers to go after they are added. Just need a bit more specificity about not only what you want, but where you want the information to go. Thank you!!

    Dome

  3. #3
    Registered User
    Join Date
    12-10-2018
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    19

    Re: Conditional Match Rows, then Output data

    To clarify, print means to copy the data into the cell. The sum goes under the last column for the matching row of source T.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Conditional Match Rows, then Output data

    I am confused as to what the "corresponding Source T" means in #1: "if there's a match, and TAMTTT is smaller than the corresponding Source T, Output = pc. Else, fc"
    In row 2 the TAMTTT is 5.5 and the output is pc
    In row 9 the TAMTTT is 5.5 and the output is fc
    I don't see a difference.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] 2 Sheets data combined into output sheet with match 1 field common
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-24-2019, 03:00 PM
  2. [SOLVED] Compare two columns of data and output contents of a third column when there is a match
    By BENTLEY1984 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-11-2018, 10:00 AM
  3. excel 2003 match name to data if yes output name removing space.
    By Ditch1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2017, 09:44 AM
  4. Replies: 3
    Last Post: 07-26-2013, 06:46 PM
  5. Replies: 0
    Last Post: 05-02-2013, 06:21 PM
  6. Split Data Output into Rows
    By Inbound in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2010, 03:52 AM
  7. Match two lists of data, if set A is >25% of set B output difference
    By eldoradotower in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2008, 04:09 PM

Tags for this Thread

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