Results 1 to 7 of 7

Converting Table in Excel to List in excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    NZ
    MS-Off Ver
    Excel 200a
    Posts
    14

    Converting Table in Excel to List in excel

    Howdy. I am am ammo collector an use a spreadsheet to keep track of my collection. One part of this is headstamps (the marks on the base of a cartridge) and what they mean. I have a "base" sheet that has all my info and from there it breaks up into sub catagories.
    I have included the relelvant sheets so my explaination makes sense.

    My info is put in with the calibre in the A column and labels in row 1.
    So I have a table of headstamps that I want a list out of. I do not a have a set number of headstamps for each calibre and I am continually adding to it.

    Someone reccomended to me using VLOOKUP or HLOOKUP. I have had a play with both but can't get either to work exactly right. Both are close but I haven't been able to dial either in perfectly.
    I realise I could just use an =A? but then I have to modify it each time I add cartridges.

    Cheers

    Nick
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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