copy and past cells found by SUMPRODUCT
 

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.

copy and past cells found by SUMPRODUCT
 

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/...ry/officeexcel

"Tromal" wrote in message
...
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.

if you are looking to copy and paste the values.

copy the values, go to cells where you to paste, right click and choose "paste special values".

all the best