Hey,
I have been trying to create an excel that has a list of all my books with info. Columns are: A[book name] B[author] C[who lent it].
I want to make a dynamic list that will list all the books that has been lent.
Example of original list
Book name Author Who lent it
Harry Potter J.K.Rowling Ron
Silmarillion J.R.R. Tolkien Mad Max
The Hobbit J.R.R. Tolkien
Tunneli K. Illeri
Makkara S. Appikivi
Example of list that has found the lended books from the original list
Book name Author Who lent it
Harry Potter J.K.Rowling Ron
Silmarillion J.R.R. Tolkien Mad Max
I have no intentions of making a filtered list. Is there any way of doing this otherwise?
Bookmarks