E X C E L Experts Come Here

[Allpatchino]

use adv filter for each column and select UNIQUE records only ... later use vlookup

[aytida]

[quote name='_poori' timestamp='1351817204' post='1302728114']
#2. Column E and F (data from Ponky.xlsx) ni motham okka range name ivvu (RangeEF).. and now in Column D you can use the formula

[color=#282828][font=helvetica, arial, sans-serif]"[b]=VLOOKUP(A1, RangeEF, 2, FALSE)[/b]"[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]This will put the value from Column F (aka Column B from Ponky.xlsx) for all the values in Column A which match Column E[/font][/color]
[/quote]


Baa nee PM choosi reply ivvu