Is there any look function available in xl which can provide all
common data from the sheet. Currently i am using vlookup function to
sort common records between two sheets but the problem is its only
provide the first data which comes from ascedning order also suggest
if any function availabe to find out common words from two cells.

Thanks in advance


Regards

Visit Chip's site and search fro 'duplicates'. He has lots on info on this
subject
www.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ams" wrote in message
...
Is there any look function available in xl which can provide all
common data from the sheet. Currently i am using vlookup function to
sort common records between two sheets but the problem is its only
provide the first data which comes from ascedning order also suggest
if any function availabe to find out common words from two cells.

Thanks in advance


Regards

Any other option pls....

Not able to make out

On Oct 2, 7:29*pm, "Bernard Liengme"
wrote:
Visit Chip's site and search fro 'duplicates'. He has lots on info on this
subjectwww.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email

"Ams" wrote in message

...



Is there any look function available in xl which can provide all
common data from the sheet. Currently i am using vlookup function to
sort common records between two sheets but the problem is its only
provide the first data which comes from ascedning order also suggest
if any function availabe to find out common words from two cells.

Thanks in advance

Regards- Hide quoted text -

- Show quoted text -

Any other option?


On Oct 2, 7:29*pm, "Bernard Liengme"
wrote:
Visit Chip's site and search fro 'duplicates'. He has lots on info on this
subjectwww.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email

"Ams" wrote in message

...



Is there any look function available in xl which can provide all
common data from the sheet. Currently i am using vlookup function to
sort common records between two sheets but the problem is its only
provide the first data which comes from ascedning order also suggest
if any function availabe to find out common words from two cells.

Thanks in advance

Regards- Hide quoted text -

- Show quoted text -