Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi ...plz help
given : C 5 tea 6 tree 7 oil my search string is D5.... also i put my formula in E5 : =MATCH(D5;$C$5:$C$7;0) this mean that if i type the word "tree" in cell D5...the result will be =2 which means the second criteria NOW MY GOAL IS TO FIND A FORMULA WIHICH INDICATES ME THE LOCATION OF THE WORD "TREE".....PLZ HELP PS: IF THE GIVEN WOULD BE : C 5 tea 6 tree 7 tree HOW TO DEAL HERE WITH THE PRECEDENT PROCEDURE AND WHAT FORMULAS TO USE ??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Location of AddIns | Excel Discussion (Misc queries) | |||
Tab location | Excel Discussion (Misc queries) | |||
Template location | Excel Discussion (Misc queries) | |||
VBA Options Location | Setting up and Configuration of Excel | |||
Cursor Location | Excel Discussion (Misc queries) |