Automatic sorting of lists V2



18
66864

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: 15 years ago Category: آموزشی