Automatic sorting of lists V2

۶۵.۴ K


۱۶

By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order. To see how to avoid ranks that are the same visit http://www.auditexcel.co.za/blog/how-to-rank-items-that-have-the-same-rank/ or http://www.auditexcel.co.za/blog/how-to-avoid-the-rank-function-finding-equal-results/ )

Published by: AuditExcel Advanced Excel and Financial Model Training and Consulting
Published at: ۱۲ years ago
Category: آموزشی