Thread: Returning Bottom 10 Percent in another spreadsheet
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Returning Bottom 10 Percent in another spreadsheet
Copy B2 to C2 ...
Just extend the copying across of B2 further to D2, if you want to bring the
source "Rank" col as well. Or to E2 even, if you'd like the percentrank col
as well.

Press the YES button below to high-five this response, if it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
Reply With QuoteReply With Quote