Making a list

  • Thread starter Thread starter scottymelloty
  • Start date Start date
S

scottymelloty

Sorry if this is obvious but i cant get my head round it today

I have two columns, column A is a name, column B is a figure, say
have a list of 50 names

On another worksheet i want to produce a list of anyone who has
figure under zero without having to sort the original list of name, i
if name no 1,4,26 and 48 are under zero i want the list on the new lis
to put these 4 names in a list in row 1,2,3,4 for example instead of sa
name 48 being right down the list

Hope this makes sense ?
 
the two column heading names, figure
highlight any cell in database
clikd data(menu)-autofilter
there will be two small arrows in the two columns
click the arrow in <gigure> column and you get a list and click <0> and
you will see only that part of database whose figureis o. copy this to
another sheet.
will this serve your prupose
 
Back
Top