View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 594
Default Formula for High Value

Data Filter Autofilter.....then click the arrow at the top of the value
column and choose Custom is greater than set the value to exceed ok

When finished, Data Filter Autofilter again to return to normal.........

Vaya con Dios,
Chuck, CABGx3



"Jessinat" wrote in message
...
I have 2 columns of data (1st column is name, 2nd column is value) and

want
to filter the data so that the name appears on a separate sheet for those
individuals whose value exceeds a certain number. Any ideas would be

greatly
appreciated. TIA.