Have u tried using text to columns??
Its a simple way to do so.
Regards,
Vijay Iyer
On 20 Mar 2014 14:23, "Deepak Rawat" wrote:
> Dear All,
>
> I have attached a sheet with rawa data & final data.
>
> I need a macro to sort coma separated data in each cell, like example is
> given below:
>
> N
Dear All,
In the validation column try using a combination of these formulaes:
=OFFSET(AE1,MATCH(B8,AE2:AE65536,0),1,COUNTIF(AE2:AE65536,B8),1)
Wherein AE2 : AE65536 should contain thelist of products chosen.and given
the specifications alongside these in the next column. As a result of the
Offs
