software

I have a column which lists various dollar amounts (thousands of cells). I
want to search that column and locate cells which total a specific dollar
amount. For example, a customer has fifty accounts with us and I know he paid
$100.00 that were divided randomly over five of his accounts. I need to know
which five accounts that $100.00 could have been spread across, so I need to
find a way to search the column to find which cells total that $100.00. I
have been unsuccessful in finding something suitable in the Help file. Thank
you.
--
C. Brown

Apply datagt;filtergt;autofilter and filter on the amount and the customer

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;C. Brownquot; gt; wrote in message
...
gt;I have a column which lists various dollar amounts (thousands of cells). I
gt; want to search that column and locate cells which total a specific dollar
gt; amount. For example, a customer has fifty accounts with us and I know he
gt; paid
gt; $100.00 that were divided randomly over five of his accounts. I need to
gt; know
gt; which five accounts that $100.00 could have been spread across, so I need
gt; to
gt; find a way to search the column to find which cells total that $100.00. I
gt; have been unsuccessful in finding something suitable in the Help file.
gt; Thank
gt; you.
gt; --
gt; C. BrownWell, yes. The problem is, I don't think the payment was applied to the
correct person's accounts, so searching by name has not been successful.
Also, the amount is spread over several cells. I want the formula to be able
to search the column and return the actual cells which total that specific
amount; the amount would not be located in one cell. I want it to find the
first group of cells which total a specific amount, then if that's not it,
move on to the next group of cells which total that specific amount. Thank
you for your assistance.
--
C. Brownquot;Peo Sjoblomquot; wrote:

gt; Apply datagt;filtergt;autofilter and filter on the amount and the customer
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;C. Brownquot; gt; wrote in message
gt; ...
gt; gt;I have a column which lists various dollar amounts (thousands of cells). I
gt; gt; want to search that column and locate cells which total a specific dollar
gt; gt; amount. For example, a customer has fifty accounts with us and I know he
gt; gt; paid
gt; gt; $100.00 that were divided randomly over five of his accounts. I need to
gt; gt; know
gt; gt; which five accounts that $100.00 could have been spread across, so I need
gt; gt; to
gt; gt; find a way to search the column to find which cells total that $100.00. I
gt; gt; have been unsuccessful in finding something suitable in the Help file.
gt; gt; Thank
gt; gt; you.
gt; gt; --
gt; gt; C. Brown
gt;
gt;

Hi

Have a look at this reply:
groups.google.com/group/micro...eeace873b464ae

It did the trick for me and is very smart!!

Hope this helps.
Andy.

quot;C. Brownquot; gt; wrote in message
news
gt; Well, yes. The problem is, I don't think the payment was applied to the
gt; correct person's accounts, so searching by name has not been successful.
gt; Also, the amount is spread over several cells. I want the formula to be
gt; able
gt; to search the column and return the actual cells which total that specific
gt; amount; the amount would not be located in one cell. I want it to find the
gt; first group of cells which total a specific amount, then if that's not it,
gt; move on to the next group of cells which total that specific amount. Thank
gt; you for your assistance.
gt; --
gt; C. Brown
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Apply datagt;filtergt;autofilter and filter on the amount and the customer
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Northwest Excel Solutions
gt;gt;
gt;gt; www.nwexcelsolutions.com
gt;gt;
gt;gt; (remove ^^ from email address)
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;C. Brownquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a column which lists various dollar amounts (thousands of cells).
gt;gt; gt;I
gt;gt; gt; want to search that column and locate cells which total a specific
gt;gt; gt; dollar
gt;gt; gt; amount. For example, a customer has fifty accounts with us and I know
gt;gt; gt; he
gt;gt; gt; paid
gt;gt; gt; $100.00 that were divided randomly over five of his accounts. I need to
gt;gt; gt; know
gt;gt; gt; which five accounts that $100.00 could have been spread across, so I
gt;gt; gt; need
gt;gt; gt; to
gt;gt; gt; find a way to search the column to find which cells total that $100.00.
gt;gt; gt; I
gt;gt; gt; have been unsuccessful in finding something suitable in the Help file.
gt;gt; gt; Thank
gt;gt; gt; you.
gt;gt; gt; --
gt;gt; gt; C. Brown
gt;gt;
gt;gt;