LinkBack URL
About LinkBacks
Im sorting everything between 0 and 90 from UD to IN,
But it doesn't seem to be able to handle if there are more of one value... how do I?
Thanks!
http://www.excelforum.com/attachment...1&d=1470814106
Im sorting everything between 0 and 90 from UD to IN,
But it doesn't seem to be able to handle if there are more of one value... how do I?
Thanks!
http://www.excelforum.com/attachment...1&d=1470814106
How do you want it to handle duplicates?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Don't care about the order, I just need all duplicates to show. I can have more then one item on that day, and I need to know about them all - not just one of the items.Originally Posted by AliGW
I'm not clear what you are trying to achieve. Apart from the missing item, the two sheets seem to contain the same data in the same order. What am I missing?
Try
in A4
=IFERROR(INDEX(UD!A$3:A$100,SMALL(IF((UD!$G$2:$G$100>0)*(UD!$G$2:$G$100<=90),ROW($A$2:$A$100)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")
Enter with Ctrl+Shift+Enter
Copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks