Forum Discussion

Twifoo's avatar
Twifoo
Silver Contributor
Jul 04, 2019

Excel Searchable Lists

To commemorate American Independence Day, I hereby share my Excel file with searchable lists of the popular American Names for those born from 1919 to 2018. Delve into it and please apprise me of you...
Excel
Formulas and Functions
nicoleahmed's avatar
nicoleahmed
Copper Contributor
Jan 10, 2023
This looks great thanks. From what I can see, the data validation formula would need to be changed for each cell making this a bit time consuming for bigger sheets needing lots of choices - but I can see this being very useful for some purposes.

the data validation formulae in F2 and F3 were
* =IF((F1<>"")*(F2="")*(F3=""),StdMales,IF((F1<>"")*(F2<>"")*(F3=""),FtdMales,""))
*=IF((F2<>"")*(F3="")*(F4=""),StdMales,IF((F2<>"")*(F3<>"")*(F4=""),FtdMales,""))
  • nicoleahmed's avatar
    nicoleahmed
    Copper Contributor
    Jan 10, 2023
    apologies - the data validation formula automatically updates as it goes down a column --- but the cells no longer function further down the column. some nice work though!

Resources