My records have a lot of cells (columns). Now i want to write a search formula to horizontally search and scan all cells of a record to find a specific value. How can I solve this?
About search formula’s:
Who knows how I can organize this?
I have two tables:
Groups, with each 10 columns for the names of their membersMembers, with the data of all members of all groups
Now i want to automatically add the name of a new member to the first open spot of th...
Thanks for reaching out.
I would like to find the first blank cell on a specific row, to put a new entry there.
So for example, if the first three cells on a row are filled but the fourth cell is empty, then the new entry should be automa...
Thanks @kuovonne and @Raminder_Singh.
A member can only belong to one group. And i’ll need all members of a group in a seperate cell. So based on the reply of @kuovonne i’ll need some scripting automation then. Are you familiar with this? Or should i...