ExcelBanter - View Single Post - Help please

Harlan Grove

wrote...
Thank you for your time and willingness to help. However, I did change
my first table to TBL as instructed and the result returned was #name?

Do I need to include an exclamation after TBL?
....

By 'change my first table to TBL' do you mean you used the menu command
Insert Name Define to create the defined name TBL referring to the
range containing your first table?

Try this diagnostic: enter the following formula in an empty cell.

=COUNTA(TBL)

If that also returns #NAME?, then you haven't created the defined name
TBL. If that returns a numeric result, then please show the entire
formula you're trying to use that returns #NAME?.