View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default duplicate occurance, assigning an ordinal value

Thanks for the response. As I understood it, Rick, the use of XXX
referenced below doesn't do it.
Here's what it looks like:
http://www.editgrid.com/user/mcheng/sample


Here is what it looks like on my system...

http://www.rickrothstein.com/excel_stuff/testsheet.xls

seems to work as you asked for. If I did it right, you should be able to
add/delete model numbers and watch the formulas work. I copied down to A20,
so you have a little room to play with.

Rick