https://docs.google.com/file/d/0B6LXy9sguZVkSXVqdnBWd0tVWUk/edit?usp=sharing
2 ways to auto-sort a numerical table using simple formulae when cells
in a totals column are modified
On 2013/07/11 06:00 PM, Dave Barton wrote:
Johnny Rosenberg wrote:
2013/7/11 Errol Goetsch <[email protected]>:
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.
Why not upload it somewhere and give us the link? Maybe someone else
want to study it. Me, for instanceâ?S(
Johnny Rosenberg
+1
Dave
--
--
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
