Data clubbing thru Farmula

[shukla.ankur281190]

Hi to All,

hope you all are doing good.

Here is attached a file containing two sheets naming Chart1 & Chart2.

Chart 1 is data clubbing manual from Chart 2.

Can any1 help me out thu formula.

Thanks in Advance.

Ankur

[Special-K]

So at a rough guess, (cos you havent actually explained what you want to do) it seems you want to generate Chart1 fromt he data in Chart2, ie

Part 325 has Sr No from 1 to 4 with Section No 1 and you want to generate each of the Sr No.s and Section No for each part as per Chart2.

I won't be solving this one, over to the VBA experts . . .

[shukla.ankur281190]

Yes Mr.Special-K you are absolutely right..... i need formula's instead of VBA... any one who can help me out plz

[samba_ravi]

A3=INDEX('Chart-2'!$A$3:$A$37,SMALL(INDEX(((('Chart-2'!$B$3:$B$37>='Chart-2'!$B$4:$B$38)+('Chart-2'!$C$3:$C$37<>'Chart-2'!$C$4:$C$38))=0)*10^10+(ROW('Chart-2'!$B$3:$B$37)-ROW('Chart-2'!$C$3)+1),0),ROWS($A3:$A$3)))

B3=IF(COUNTIF(A$3:A3,A3)=1,1,SUM(G2,1))

C3=INDEX('Chart-2'!$B$3:$B$37,SMALL(INDEX(((('Chart-2'!$B$3:$B$37>='Chart-2'!$B$4:$B$38)+('Chart-2'!$C$3:$C$37<>'Chart-2'!$C$4:$C$38))=0)*10^10+(ROW('Chart-2'!$B$3:$B$37)-ROW('Chart-2'!$C$3)+1),0),ROWS($A3:$A$3)))

D3=INDEX('Chart-2'!$C$3:$C$37,SMALL(INDEX(((('Chart-2'!$B$3:$B$37>='Chart-2'!$B$4:$B$38)+('Chart-2'!$C$3:$C$37<>'Chart-2'!$C$4:$C$38))=0)*10^10+(ROW('Chart-2'!$B$3:$B$37)-ROW('Chart-2'!$C$3)+1),0),ROWS($A3:$A$3)))

SEE THE ATTACHED FILE

[shukla.ankur281190]

Thanks Mr.Siva ... thanks A lot

1 more help i need can you convert the same chart 1 to chart 2

[samba_ravi]

see the attached file

[shukla.ankur281190]

You are awesome bro thanks I must learn some more function and thoughts as you did in the same. Thanks once again

[samba_ravi]

You are welcome and thanks for your feedback