Prev: Remove non-space spaces?
Next: Password to open excel file
From: Tromal on 30 May 2010 02:56
I have colum A and B. I use SUMPRODUCT to calculate the sum of values in
column B with a criteria.

What I would like to do is copy the cells from column A (some row that
SUMPRODUCT have use) and paste them elsewhere.

From: Bernard Liengme on 30 May 2010 09:03
Functions cannot do this. Why not use Data | Filter followed by copy &
paste?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel

"Tromal" <Tromal(a)discussions.microsoft.com> wrote in message
news:1B98F955-78D3-422B-A25B-623F6E86B170(a)microsoft.com...
> I have colum A and B. I use SUMPRODUCT to calculate the sum of values in
> column B with a criteria.
>
> What I would like to do is copy the cells from column A (some row that
> SUMPRODUCT have use) and paste them elsewhere.
>
 | 
Pages: 1
Prev: Remove non-space spaces?
Next: Password to open excel file