| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fussy check of cell contents
Hi Can anybody help me in following task... I want check/compare two cells containing alpha numeric sentences. If the cells are having more than 3 words in common or the meaning of the cells is same irrespective of the words then it sould return some thing like 'DUP' in the corresponding row A B C 1 depth of 3 metres depth of 3 metres Dup 7 decimetres 7decimetres 2. daybeacon BnOr daybeacon BnOr Dup 3. the legend of lights F.R. the legend of lights F.R. Not duplicate 35m by Q.R. 35m 6M by Q.R. 7M point (a) eventhough few words are same 4. obstructions 5.1 Obstn obstructions 3.5 Obstn Not Dup 5. light to, Fl(3)10s17M light to, Fl(3)10s17M Dup (B5 is same as A5 with additional info) so the required function/macro should think and decide the duplication. Is that possible... if so kindly help me out... -- access_mk ------------------------------------------------------------------------ access_mk's Profile: http://www.excelforum.com/member.php...o&userid=33636 View this thread: http://www.excelforum.com/showthread...hreadid=534090 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding the contents of a cell to a formula | Excel Discussion (Misc queries) | |||
| Showing the contents of a cell based on another cell | Excel Worksheet Functions | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Threaded Mode
