Rank companies by financial metrics relative to peers in Excel using Z-scores and dynamic arrays for accurate comparative analysis.