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.
Bookmarks