Hi JohnnySheet 1 auto-sorts a numerical table using rank, vlookup and countif, sheet 2 uses hlookup, vlookup, countif, max and min.Sheet 1 simpler by far.The trick with both is sorting duplicate values. The solution involves using countif to identify duplicates, adding 1/frequency to the rank value, then ranking | sorting by the new list.regards
-- View this message in context: http://nabble.documentfoundation.org/Auto-sort-group-of-cells-when-any-cell-is-modified-saved-tp4064677p4065019.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
