View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevec stevec is offline
external usenet poster
 
Posts: 177
Default Creating A List of Items Between Two Numbers

I have two worksheets in the same workbook, "Filter" and "Data"

In worksheet Filter, Cell A1 is 40%, Cell B1 is 50%, Cells C1 to C100 is
where your "magic formula" goes, referencing Cells A1 and B1.

On worksheet Data, There is percentile data in BA13:BA6000
On worksheet Data, There are names in D13:D6000 --

In worksheet Filter, Cells C1:C100 I want to create a list of all names
(worksheet Data Column D) that contain values (worksheet Data Column BA)
between the range of numbers provided (worksheet Filter, cells A1 and B1).

Thank you !