Thanks Ranjan but I could not use file filter because;
1.Data is required at different place.
2.Filter is not effective when i have to use it more than 50 times in a day.
3.Data captured on the basis of the criteria is further required for
calculation purpose.
Therefore, i intend to use *formula
you should apply contain Filter.. i think
On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote:
> Hello,
> I have a very tricky problem. I have got an excel sheet having some columns
> but more than 5000 rows. In those columns there are some names which may/may
> not be similar to each other. I want
