Hello there,
I need some help.
I searched in web but only found out formulas for excel which are not working in numbers.
I have a spreadsheet with a table containing a column with a "code" number, a column with name, a column with surname and some other columns for telephone email etc. It is in conclusion something like an address book data base.
I want to be able to search in this list writing only the surname or the name and the multiple results be displayed with also the code beside. Can anyone help me out?
Here is a small part of the spreadsheet.
https://www.dropbox.com/sh/hh4t5ekxhqy4lab/AADvbHoxJ9HErYXh1oARjcVRa?dl=0
I would really appreciate your assistance.
PS sorry for my bad english, I am not a native speaker.
I need some help.
I searched in web but only found out formulas for excel which are not working in numbers.
I have a spreadsheet with a table containing a column with a "code" number, a column with name, a column with surname and some other columns for telephone email etc. It is in conclusion something like an address book data base.
I want to be able to search in this list writing only the surname or the name and the multiple results be displayed with also the code beside. Can anyone help me out?
Here is a small part of the spreadsheet.
https://www.dropbox.com/sh/hh4t5ekxhqy4lab/AADvbHoxJ9HErYXh1oARjcVRa?dl=0
I would really appreciate your assistance.
PS sorry for my bad english, I am not a native speaker.