+ Reply to Thread
Results 1 to 3 of 3

Book lending excel

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    Finland
    MS-Off Ver
    Excel 2013
    Posts
    10

    Book lending excel

    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?

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Book lending excel

    My first pass would be to stick 'em in an autotable and then filter the third column for (blank) values. I guess you don't want to do that though...

    Well, I can't think of an easy way to do this without using filter somewhere. You could certainly push from a control table to a display table and drop out the blank values using an IF(isblank(C1),"",A1:B1) kinda thing for example, but then the "unlent" books would be blanks. Removing those blank rows... I can't think of an easy way to do it with formulas. Probably with VBA, but I can't think of a simple way to do that, either.

    Maybe you could feed the table of data to a pivot table and then use a Report Filter to remove (Blank) values, while using the author/title as Row Labels.

    Well, generally it would probably be best to have a "data" table and a "display" table.

  3. #3
    Registered User
    Join Date
    07-23-2013
    Location
    Finland
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Book lending excel

    Having a data table and a display table would be exactly what I'm looking for. I'll probably just do all this with the filter and try make it look cool. I guess I'm just looking for challenges that doesn't exist! :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro for importing data from one excel book to another excel book...
    By jaysakle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2013, 03:05 AM
  2. Replies: 3
    Last Post: 12-27-2012, 12:26 PM
  3. Lending and repayment calculations over a portfolio
    By smudgepost in forum Excel General
    Replies: 0
    Last Post: 08-19-2011, 04:39 PM
  4. [SOLVED] AOR to APR - Truth in Lending
    By Toan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2006, 04:15 PM
  5. microsoft should make a commercial lending software
    By George James Ducas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-30-2005, 11:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1