Results 1 to 16 of 16

Formula to consider first value of multiple same values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-25-2021
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    2,171

    Formula to consider first value of multiple same values

    Hello formula experts
    I am facing an issue with the formulas in columns L and O. When the amounts are same under one GSTIN number, the formula is selecting all the amounts and displaying matched. I need your expertise to edit the formula in such a way that it will select only one row (first row) to match and the remaining ones as blank. The code needed to be edited are columns L and O only as they do not take the Invoice number and Date into consideration. Please help me to solve this issue.
    Thank you in advance
    Attached Files Attached Files
    Last edited by RAJESH SHAH; 08-29-2022 at 04:50 AM. Reason: #Solved by HansDouwe

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-12-2021, 07:21 PM
  2. Replies: 13
    Last Post: 05-24-2018, 01:18 AM
  3. Formula to Sum 3 Column Values based on Multiple Criteria for Multiple Rows
    By RMerckling in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2016, 07:46 PM
  4. Formula to check multiple values for multiple specific results
    By lqangel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2015, 01:29 PM
  5. Replies: 12
    Last Post: 02-10-2014, 11:59 AM
  6. Formula to lookup multiple text values in multiple columns
    By karimk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2013, 05:33 AM
  7. Replies: 1
    Last Post: 10-23-2012, 12:08 AM

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