| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find first occurance of certain value in grid
I have a worksheet that is 7 columns by 5 rows...in any one of those cells
the user can input a certain text value, say "X". I need to find which cell that value is in and then test the next two cells, going across and then down to see if the same value exists in order to assign points based on a predefined points system. Any ideas on how to do that ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find occurance of something from 2 creterion | Excel Discussion (Misc queries) | |||
| Find the next occurance | Excel Worksheet Functions | |||
| Find nth occurance of data | Excel Worksheet Functions | |||
| help to find a string for 4th occurance | Excel Worksheet Functions | |||
| Find next occurance | Excel Discussion (Misc queries) | |||
Threaded Mode
