Forum Discussion
making a book list
HI, fairly new to excel and I am trying to make a book list containing book title, shelf location, author, and perhaps date published. It is for a bookcase with eight shelves and approx sixty books p...
Take a look at the attached example. It uses the FILTER function (available in Excel in Microsoft 365 and Office 2021) to allow you to search by title, author of shelf.