Tricky? Excel Question

Discussion in 'General Chat' started by liveforav, Feb 10, 2009.

  1. liveforav

    liveforav
    Well-known Member

    Joined:
    Sep 26, 2005
    Messages:
    1,450
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    86
    Location:
    Uk
    Ratings:
    +315
    I'm not bad with excel, but have got myself a little stumped with this one.. Its got me truely confuzzeled! Once i know how it can be done i'll be able to automate it in vb and loop through the data set if needed. I've looked into using, INDEX and MATCH as well as IF statements to no avail.

    (its for inventory calculation btw, i've used examples below rather than complicate things with real item names)

    Data Set
    I've got a set of data in four columns (A, B, C, D), by >1000 rows. Column 'D' contains the item type, eg 'Drawer 1', 'Drawer 2, 'Drawer 3' etc. Columns A, B and C contain the items that go into the 'Drawer #'. Generally speaking there's usually 4 to 8 items that go in each drawer.

    Output Needed
    The data i'm looking for is a note of which Drawers contain the same items. eg.

    Drawer Number
    Drawer 1
    Drawer 2
    Drawer 3

    Contains
    Item 1
    Item 3
    Item 6
    Item 11
    Item 21
    Item 54
     
    Last edited: Feb 10, 2009
  2. Mr_Wistles

    Mr_Wistles
    Distinguished Member

    Joined:
    Mar 11, 2004
    Messages:
    12,109
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Essex
    Ratings:
    +3,035
    Get over to mrexcel.com, very clever bunch. Forum is packed with mvp's.
     
  3. liveforav

    liveforav
    Well-known Member

    Joined:
    Sep 26, 2005
    Messages:
    1,450
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    86
    Location:
    Uk
    Ratings:
    +315
    Nice none, its a cracking site! Had a browse about over there before posting this, not posted yet though.. v.good idea. Cheers
     
  4. Mr_Wistles

    Mr_Wistles
    Distinguished Member

    Joined:
    Mar 11, 2004
    Messages:
    12,109
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Essex
    Ratings:
    +3,035
    Post there they are amazing, will reply quickly also. There is an absolute mutant there called Aladin Akyurek (deffo spelt wrong), mvp for over 10 years, best on Excel I have ever seen.
     
  5. liveforav

    liveforav
    Well-known Member

    Joined:
    Sep 26, 2005
    Messages:
    1,450
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    86
    Location:
    Uk
    Ratings:
    +315
    Posted, and replies alread.. :clap:
     

Share This Page

Loading...