Hi team, I’m creating an attendance app which has a family code column and a child name column. Each family has a number of children and allocated code.
The idea is that the parent type in the allocated [Family Code] and as a result, the list of [Child Name] appears “filtered” according to code.
The issue is that the whole list of children names in the worksheet shows on the list and doesn’t filter according to family code !! What is the formula that I need to use to filter the list of names according to the typed code?. Also, should I use the slices option as a better solution or can it be done my way?
Hopefully, I haven’t confused you