+ Reply to Thread
Results 1 to 2 of 2

Compare two rows in first column, having text value in same integer, add values of all row

  1. #1
    Registered User
    Join Date
    03-27-2024
    Location
    India
    MS-Off Ver
    2013
    Posts
    1

    Compare two rows in first column, having text value in same integer, add values of all row

    Hi,
    I am facing a issue, My worksheet having too many rows, some of the row serial no marked as 1, 1(A), 2, 2(A), 3, 4, 5, 5(A).... and remaining columns having some values. My needs is if having serial no. 1 & 1 (A) combined and add values in both rows placed in 1's row.
    Any one please help making a formula for the same
    Attached Files Attached Files
    Last edited by shameem.s; 03-27-2024 at 11:07 PM.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Compare two rows in first column, having text value in same integer, add values of all

    Expected results, please?

+ 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: 4
    Last Post: 10-30-2015, 07:59 AM
  2. [SOLVED] VBA code to compare rows based on 4 column values and highlight is no match
    By Sirilias in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2015, 02:22 PM
  3. [SOLVED] Compare Rows, Delete duplicate values, Sum values but Retain blank rows
    By chancw in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-24-2013, 07:38 AM
  4. Replies: 3
    Last Post: 05-02-2013, 09:31 PM
  5. Solver - Changing cells to text values not integer
    By Kinnan in forum Excel General
    Replies: 0
    Last Post: 08-15-2010, 08:46 AM
  6. Compare string with integer
    By hurriance in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2006, 04:20 AM
  7. Formula to compare multiple rows values based on another column?
    By Murph in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-20-2005, 11:06 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