View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Help please - looking for a formula

wrote...
Thank you for the formulas! However, I cannot get them to work (user
error I am certain). Considering the result I am getting is #name?
Any suggestions?

....

First suggestion, for follow-up questions respond to responses rather
than to your original posting.

Second, if you didn't name your first table TBL then replace the
instances of Tbl in my formulas with the range reference for your first
table.