View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric_in_EVV Eric_in_EVV is offline
external usenet poster
 
Posts: 1
Default 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 ?