Data Validation List with Formulas

Hi, I was searching google and figured this is from list-data validation. However, I can't seem to add formulas / functions in Data Validation. Will be lovely if someone could help me out! ...

01_04_Begin.xlsx31 KB

Excel on Mac

Formulas and Functions

Detlef_Lewin
Aug 25, 2021
CadenChen
That is the total row of an Excel table and not data validation.

https://support.microsoft.com/en-us/office/total-the-data-in-an-excel-table-6944378f-a222-4449-93d8-474386b11f20?ui=en-US&rs=en-US&ad=US

Detlef_Lewin

Silver Contributor

Aug 25, 2021

CadenChen

That is the total row of an Excel table and not data validation.

https://support.microsoft.com/en-us/office/total-the-data-in-an-excel-table-6944378f-a222-4449-93d8-474386b11f20?ui=en-US&rs=en-US&ad=US

CadenChen

Copper Contributor

Aug 25, 2021

saw it, thank you so much!

Forum Discussion

Data Validation List with Formulas

Resources