Transfer Data from 1 sheet to another with a condition

**raunakkolte** · 02-18-2011, 06:02 AM

Hi All,

Can you please help me with a Formula to pull data from sheet 1 in Sheet 2 with a Condition, Condition is that in sheet 1 Column A there is a value "1215773", I want all associate name on Sheet 2 who are linked to 1215773 in sheet 1?

attaching the excel.

**zbor** · 02-18-2011, 06:55 AM

How about Pivot table?

I've assumed that Customer ID must be same for same customer... So I put AVERAGE.
However, you have COUNT to tell you how many times some name appear.

Choose ASSO ID from drop down menu.

(and please update your profile XL version to 2007)

**raunakkolte** · 02-21-2011, 07:30 AM

Thanks zbor, but Pivot is ok i know about it, why i require formula is cause, I Dont know Macros? and the value that i will obtain on Sheet 2 will be linked with another value by using Vlookup and that will be not is sorted format. and I cannot sort the values linked to Pivot table henc require this data with the help of Formula.

Originally Posted by zbor

How about Pivot table?

I've assumed that Customer ID must be same for same customer... So I put AVERAGE.
However, you have COUNT to tell you how many times some name appear.

Choose ASSO ID from drop down menu.

(and please update your profile XL version to 2007)