Share via

How does #All, #Data, #Headers, #Totals, #ThisRow work in Excel?

Anonymous
2017-02-07T09:36:53+00:00

Hello, 

Can you help me understand the below in Excel. Where/How can I use the below? And also can you give a brief explanation for each. 

I have a formula used =IF(ISNA(Table1[[#This Row],[NAME]]),0,1)

#All

#Data

#Headers

#Totals

#This Row

R/

Niranjan

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-02-08T23:38:28+00:00

    Hello Niranjan,

    To answer your questions about Excel, we suggest you check this page from Microsoft Office Support: Using structured references with Excel tables.

    ****Let us know if you require further information.

    Thank you.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments