Vlookup multiple value

[deen]

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

 

[Guest]

Why don't you just filter on F0001 etc

Mike

 

[deen]

Why don't you just filter on F0001 etc

Mike

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

 

[deen]

Why don't you just filter on F0001 etc

Mike

It will going to happen in diffrent excel,

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

 

[Guest]

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

 

[Guest]

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