Results 1 to 5 of 5

How can I remove multiple data by multiple conditions?

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2009
    Location
    BUCHAREST
    MS-Off Ver
    Excel 2003
    Posts
    3

    How can I remove multiple data by multiple conditions?

    Hello guys!

    This is my first post, so I am glad to meet you all!

    Here is what I want to do:

    1. I have 4 columns (let's say D,E,I,J);

    D E I J
    Account1 Sum1 Account2 Sum2

    151 93,79 BF2479 30,00
    1476757 93,79 BF7 22,00
    BF2479 30,00 151 93,79
    86041 84,03 23235 30,00
    534 6608,45

    2. I need to clean the multiple identical data in the list by both Account no. and Sum (of course the list is much longer!) so that the list should look like this:

    D E I J
    Account1 Sum1 Account2 Sum2


    1476757 93,79 BF7 22,00

    86041 84,03 23235 30,00
    534 6608,45

    I must say that I am a beginner in Excel, so I tried to use this:

    =IF(OR(E5=$J$5:$J$430);IF(INDEX($I$5:$I$430;MATCH(E5;$J$5:$J$430;FALSE);1)=D5;"";E5);E5)

    for column E, and

    =IF(OR(J5=$E$5:$E$452);IF(INDEX($D$5:$D$452;MATCH(J5;$E$5:$E$452;FALSE);1)=I5;"";J5);J5)

    (which is reverse of the first one) for column J; (The ranges are the ones used in the real sheet), not for the ones in the example above!);
    The formula does seem to eliminate a dew unwanted data, but does not give me all the wanted results!

    Please, give me a little eadvice if you can!

    Thank you in advance!
    Last edited by FlorinS; 08-23-2009 at 01:58 PM.

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