Thread: Name Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harddrive747 Harddrive747 is offline
external usenet poster
 
Posts: 9
Default Name Formula

I have created a spreadsheet with information from Access. I have the
information put in columns A-F. I have put in coumn G the percentage of
traffic based on the sum of all the data in column C.

Now what I want to be able to do is to create a name that will select the
rows that have the percentage greater than 0.5%. This way I can put them in
a chart.

Can I do this or do I have to create a macro to do this? I also would not
want to have the macro run each time that I open the file. So any help on
this would be greatly apprechatied.

Thanks.