Results 1 to 9 of 9

Thread: Delete Rows where data is the same but in different columns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-20-2014, 10:56 AM #6
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14
    Hi Excel Fox

    Thanks for letting me know. I have now used the formula as an array. It is howver, not giving me the correct solution

    What Is need is where the value in Col F & G match for Eg F8 is 60.63 and G18 is 60.63 and the reference is the same i.e BR3P11/0001, then true must be returned

    https://www.dropbox.com/s/gnnc1g9ssq...e%20Values.zip


    It would be appreciated if you would amend your formula to accommodate this.
    Last edited by Howardc; 04-20-2014 at 11:33 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. seprate data in rows to columns
    By CORAL in forum Excel Help
    Replies: 2
    Last Post: 03-10-2014, 08:18 AM
  2. search for data and delete rows containing it
    By RickStewart in forum Excel Help
    Replies: 2
    Last Post: 02-24-2014, 09:12 PM
  3. Retain set of 4 Days Data, based on Row data in 3 columns, and delete rest
    By analyst in forum Excel Help
    Replies: 10
    Last Post: 02-18-2014, 01:34 PM
  4. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  5. How To Remove or Delete Blank Or Empty Rows After Data Is Transferred
    By jeff in forum Excel Help
    Replies: 5
    Last Post: 07-11-2013, 07:31 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