View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wind54Surfer Wind54Surfer is offline
external usenet poster
 
Posts: 16
Default Capture lines with entries?

Hi all,

I don't even know how to search for this, I have a long (almost 500 items)
price list like:

A-----------B----------------------------------C
1 CM 4 $400
2 1 CM 5 $500
3 CM 6 $600
4 1 CM 7 $700
5 CM 8 $800

I need a way to capture on another part of the sheet the
lines that have entries in the A column, like:

1 CM 5 $500
1 CM 7 $700

so I can tell if all the items have been entered properly, since the list is
so long
and I am using a handheld device, making it less clear and prone to
omissions and/or errors.

I appreciate any help.

Thanks in advance,
Emilio