Is it possible to edit this formula to also arrange in alphabetical order at the same time, or do I need to use a separate formula for this?
=IFERROR(IF(ROWS(C$3:C3)>COUNTA(E:E),"",INDEX(C:C,SMALL(IF(E$3:E$10000<>"",ROW(E$3:E$10000)),ROWS(E$3:E3)))),"")
Alpauniq.xlsx
Try this.Adjust to your ranges.
Not sure if IFERROR works on MAC so try this
=IF(ISERROR(INDEX($A$2:$A$11,MATCH(0,COUNTIF($A$2:$A$11,"<"&$A$2:$A$11)-SUM(COUNTIF($A$2:$A$11,"="&B$1:B1)),0))),"",INDEX($A$2:$A$11,MATCH(0,COUNTIF($A$2:$A$11,"<"&$A$2:$A$11)-SUM(COUNTIF($A$2:$A$11,"="&B$1:B1)),0)))
Confirm Control+Shift+Enter
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thank you Robert, the following code (which I took from you sample workbook) is working for me:
=IFERROR(INDEX($C$3:$C$50000,MATCH(0,COUNTIF($C$3:$C$50000,"<"&$C$3:$C$50000)-SUM(COUNTIF($C$3:$C$50000,"="&G$2:G2)),0)),"")
However its running a little slow, I believe because of the number of records I have. Can the formula be altered to reference a dynamic range I already have for the C column called EquipmentList so its not unnecessarily referencing blank rows.
Last edited by Nitefox; 01-11-2014 at 03:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks