+ Reply to Thread
Results 1 to 3 of 3

Match cells that add to zero - then insert a comment in the same row to saying matched

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Glasgow
    MS-Off Ver
    Excel 2003
    Posts
    1

    Match cells that add to zero - then insert a comment in the same row to saying matched

    I want to match cells that have the same unique identifier e.g. column c, 3 rows have abc123 (document number). If the values in column d add to zero e.g. 10+6-16= 0 I then want to insert a comment in column e, for each of these rows saying "matched"

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Match cells that add to zero - then insert a comment in the same row to saying matched

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Match cells that add to zero - then insert a comment in the same row to saying matched

    Maybe..

    =IF(SUMIF(C:C,C1,D:D)=0,"matched","")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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