Thanks Errol, Trying to work out how it works as we speak... :)
On 2013-07-11 10:58 AM, Errol Goetsch <[email protected]> wrote:
Hi all You can get to a auto-sorted table in 4 steps without macros by using vlookup, hlookup, count, max and min. Ive sent Charles a working example for 20 salespeople over 12 months, where the duplicate list re-sorts as soon as the YTD total changes. I couldn't bear the thought of Charles spending valuable coffee time manually sorting tables. Errol
-- To unsubscribe e-mail to: [email protected] 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
