copy and past cells found by SUMPRODUCT

[Tromal]

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.

 

[Bernard Liengme]

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