Vlookup multiple value
 

Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

Vlookup multiple value
 

Why don't you just filter on F0001 etc

Mike

"deen" wrote:

Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

Vlookup multiple value
 

On Apr 6, 1:32 pm, Mike wrote:
Why don't you just filter on F0001 etc

Mike

"deen" wrote:
Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

its happen in fillter,

but its for tax calculation going to be made we need to display the
amt in diffrent excel, thru vlookup or any other function

kindly help me

Vlookup multiple value
 

On Apr 6, 1:32 pm, Mike wrote:
Why don't you just filter on F0001 etc

Mike

"deen" wrote:
Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

It will going to happen in diffrent excel,

the value contain in rows ways, i want to get the all the values in
sheet2

Vlookup multiple value
 

Copy data from Sheet 1 and Paste into Sheet 2

Create a helper column C
In C2: =COUNTIF($A$2:A2,A2)=1
Drag the Fill Handle down as far as needed
AutoFilter the False and Delete them, when you done Delete helper column




"deen" wrote:

Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

Vlookup multiple value
 

Deen,

I feel Pivot Table will do Just the Trick that you want to Pull out...

Create a Pivot Table {Data - Pivot Table} of the Data to be analysed.

Drag in the Columns as first 'Code no.' and then 'amt.'.

The data will fall in just as you had asked for.

Hope that helped.

Sriram

"deen" wrote:

Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen