V
V
Hi~
Another problem I encounter is when using Advanced Filter. My data is
structured as follows:
Port# | Name Line# | Name | Address | City | State | Zip
1 | 1 | John Doe | Address1
1 | 2 | Jane Doe | Address1
14 | 2 | John Doe | Address1
When adding another column in between Name and Address which has a
calculation based on Name, and then using Advanced Filter, the filter
does not copy the values in this newly created column.
Example (because John and Jane have a joint acount):
1 | 1 | John Doe | Jane Doe | Address 1
When using Advanced filter the column for Jane Doe will remain empty.
Why would that be and how can I prevent it?
Thanks greatly for your help!
Another problem I encounter is when using Advanced Filter. My data is
structured as follows:
Port# | Name Line# | Name | Address | City | State | Zip
1 | 1 | John Doe | Address1
1 | 2 | Jane Doe | Address1
14 | 2 | John Doe | Address1
When adding another column in between Name and Address which has a
calculation based on Name, and then using Advanced Filter, the filter
does not copy the values in this newly created column.
Example (because John and Jane have a joint acount):
1 | 1 | John Doe | Jane Doe | Address 1
When using Advanced filter the column for Jane Doe will remain empty.
Why would that be and how can I prevent it?
Thanks greatly for your help!