Thread: Structured reference does not return correct value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vsoler vsoler is offline
external usenet poster
  
Posts: 79
Default Structured reference does not return correct value
I have a small table of data, named MyTable:

A A2
1 3
5 7
Totals 10

When I input the formula =Max(MyTable[#Data]) then I get 10 whereas I
should get 7

I don't think I am wrong!!!

What do you think?
Reply With QuoteReply With Quote