LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default text fragment comparison

i must count similar pathways, but to a limited extent:
eg: column:
RIOASSUDroit Ã* partir de 2010
RIOASSUDroit avant 2010
RIOASSUDroit avant 2010Montant minimum
RIOASSUDroit avant 2010Montant minimumRégime général
RIOASSUDroit avant 2010Montant minimumRégime indépendant


The structure of the text is always the same; i always compare the cell
below to the direct cell above.
The 'cut of' lies on the 4th ""
So: if the texte before the 4th "" is the same: true (0)
if the texte before the 4th "" is differente: false (1)
Objectif: to count the number of different publications, detected by pathway
indications.

in the example: row 2 is different from row 1 -- false = 1
row 3 is similar to row 2 -- true =0

Anybody who knows how to compare fragments of texte?

Thanks a lot,

ChrisM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparison of two lists of text and finding commonalities PayPaul Excel Discussion (Misc queries) 5 December 20th 07 11:05 PM
Text comparison - closest match pappu Excel Discussion (Misc queries) 5 July 6th 06 10:41 AM
Text string comparison - closest match pappu Excel Discussion (Misc queries) 1 July 6th 06 04:23 AM
ow to create comparison chart using text as value data? deejohn525 Charts and Charting in Excel 1 April 27th 06 12:51 PM
Text comparison in adjacent cells Andy Excel Discussion (Misc queries) 3 January 23rd 06 05:58 PM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"