Thread: Find the row number of name occurence
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Find the row number of name occurence
Use Excel 2007 PivotTable.
Simple formulas.
Automatically expands if reps 7.
Automatically updates when list expands.
Table can be sorted/filtered various ways.
Various built-in formats . See:
http://www.savefile.com/files/1817635

Reply With QuoteReply With Quote