+ Reply to Thread
Results 1 to 8 of 8

Avoiding duplicates.I have the columns K,L,M and V,W,X. I have values in column L which I

  1. #1
    Registered User
    Join Date
    01-31-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Avoiding duplicates.I have the columns K,L,M and V,W,X. I have values in column L which I

    Hi,


    My name it is Marius and I am here because I need help, obviously. If you could help, I would appreciate.
    I have attached just a fraction from what I am working on, the one I am struggling with.
    I have the columns K,L,M and V,W,X. I have values in column L which I want to arrange it in the column W from the smallest to the biggest(ex.SMALL($L$21:$L$80,ROW(W22:W80)-ROW($W$22:W80)+1)). However, in column K I have names and in column M values. Depending on W, I would like the names and values to go in V and X((INDEX(K21:K80,MATCH(W22,L21:L80,0)).
    The problem I have it is that if I have exactly the same figure in L, it will go in W but the values and names from V and X will become duplicates.
    I am a beginner and I do apologise but I hope I could get some help,
    Thanks.
    Last edited by MariusBadea; 01-31-2016 at 09:23 AM.

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: First Time

    Hi and Welcome to the forum
    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: First Time

    Welcome to the forum.
    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Quang PT

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Avoiding duplicates.I have the columns K,L,M and V,W,X. I have values in column L whic

    Thanks for changing title.

  5. #5
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: First Time

    In V22
    copy paste below then hold control and shift together and then hit enter to make it array formula and drag down
    =INDEX($K$21:$K$34,SMALL(IF(W22=$L$21:$L$34,ROW($L$21:$L$34)-ROW($L$21)+1),COUNTIF($W$22:W22,W22)))

    In X22 copy paste below then hold control and shift together and then hit enter to make it array formula and drag down
    =INDEX($M$21:$M$34,SMALL(IF(W22=$L$21:$L$34,ROW($L$21:$L$34)-ROW($L$21)+1),COUNTIF($W$22:W22,W22)))



    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

  6. #6
    Registered User
    Join Date
    01-31-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    2

    Re: Avoiding duplicates.I have the columns K,L,M and V,W,X. I have values in column L whic

    Hemesh, thanks man.
    Namaste!

  7. #7
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Avoiding duplicates.I have the columns K,L,M and V,W,X. I have values in column L whic

    Namaste!
    Nice One!! By any any chance have you seen the movie "Namaste London"?
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  8. #8
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Avoiding duplicates.I have the columns K,L,M and V,W,X. I have values in column L whic

    @ Marius You are welcome ! if that takes care of your original question you can mark thread as solved and as you are relatively new to the forum, let me take this opportunity, that you can thank the people who helped you by clicking little star icon ( Add reputation) at the bottom left corner of their post.This adds to the reputation of person which can be seen as a green bar below the names of person

+ 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. [SOLVED] EPOCH Time Conversion to local time and daylight savings time (DST)
    By cwwazy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2015, 02:14 PM
  2. Replies: 10
    Last Post: 11-08-2014, 04:51 PM
  3. Automatic generation of Start time, end time and total time in excel
    By dreamwarden in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2013, 08:03 PM
  4. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  5. [SOLVED] Extracted time from date/time field does not flag on =IF(TIME function.
    By Vlad717 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2013, 03:29 PM
  6. Replies: 3
    Last Post: 11-06-2012, 01:37 AM
  7. Replies: 0
    Last Post: 08-23-2005, 12:22 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