View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunny Sunny is offline
external usenet poster
 
Posts: 42
Default How do I copy a table w/o certain entries?

I have a table 4x316 that I wish to use as source for a table 4x316. The
resulting array should only contain info on states with a taxable amount.
What is the simplest way to accomplish this?

source table desired result
state taxable amt tax code rate state code
taxable amt rate
LA 25.00 .50 12-12 2% LA
12-12 25.00 2%
MS .00 .00 36-92 4% TX
06-32 14.25 5%
TX 14.25 .71 06-32 5%