Name as per type column

Hi Guys,

Please find the attached sheet, the formula which i am using doesnt show the 2nd criteria, i have highlighted my result,
I remove duplicates from the shot column & then i run formula...
My problem is 118_SQ001_Sc001 has 2 SET & 2 PROP but my formula shows only 1 that is too first one

I need both answers , i.e. both the SET & PROP

Note - I need my solution from column A,B &C

Link of my previous post - http://www.excelforum.com/excel-form...ml#post4214768

I think I follow what you want...

I created a helper column

=A2&B2&C2

and then made a unique list from the helper column(array entered)

=IFERROR(INDEX($D$2:$D$596,MATCH(0,COUNTIF($J$1:J1,$D$2:$D$596),0)),"")

I then used that in an INDEX-MATCH to return your results, dragging across and down:
=INDEX(A$2:A$596,MATCH($J2,$D$2:$D$596,0))

My www connection died! Here's the attachment

Hii glen,

please find attached sheet .. need solution like this.. i m srry for not explaining it properly

I would have helped if you had shown that in the first place. This is a TOTALLY different question. You will need VBA for this. Is that OK?

Yes...Glennn....i m okay with it...and i m really sorry as my manager askd me this now...hope u understand...

Hi JohnTopley

Its works great only 1 thing it is giving me a error after a press the button "Run time Error 13" Type Mismatch..

Please find attached sheet

Thank you ..it works great....

Hi JohnTopley,

1problem is here 118_SQ001A_Sc001 shot is not in the list after running macro & 1 more thing is shot nos are repeating & i want duplicate to be removed in shot nos.i.e. ("E Column")

Please help..

Hi JohnTopley,

If you see Column A has total 596 shots, and if i remove duplicates (Data- Remove Duplicates) from it i should get total 121 shots, but E column it is 133 shots...

Please see the highlighted part in the attachment

I think i m not clear ..but it still doesnt removed duplicates from Column E..pls check it again...i have manually removed duplicated and pasted in column M.. this is correct result which should appear in Column E... i Hope i m clear now...

HI John,

Sorry for delay response..the website was not opening because of some sucuri firewall backend error..please ignore the duplicates and can u pls also code in the attached sheet for "FX " part too as coding doesnt pull FX and rest everything is working grt...

find the attached document and pls do the changes for only FX part in the coding...
Thanks a lott....

Hi

Thanks a lot for your hep & patience....my problem is solved now...and can u pls suggest some easy macro learning sites.. if you dont mind...Thank You again...