Close

Results 1 to 6 of 6
  1. #1
    DF VIP Member
    satzzz's Avatar
    Join Date
    Oct 2000
    Location
    Here
    Posts
    2,628
    Thanks
    146
    Thanked:        549
    Karma Level
    412

    Default Excel database help

    Gents,
    I hope someone can help with the attached database. I've nearly sorted it for what I want it t do apart from one thing. That one thing being is that when a part number is in various DEL SEQUENCE,STOCKROOMS and MAX LEVELS I want them all to appear instead of just the first option. For example part number 1015597 has 5 DEL SEQUENCES so I would want ALL 5 to appear in cell F10.
    Hope you can understand.
    [Only registered and activated users can see links. ]
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....

  2. #2
    DF PlaYa Squizza's Avatar
    Join Date
    Jun 2014
    Location
    London
    Posts
    575
    Thanks
    193
    Thanked:        210
    Karma Level
    88

    Default Re: Excel database help

    Hey,

    I think you need to use CONCATENATE : [Only registered and activated users can see links. ]

    Failing that you might have to add a Macro.

  3. #3
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    2,817
    Thanks
    1,020
    Thanked:        770
    Karma Level
    297

    Default Re: Excel database help

    All done :-)

    Not as easy as squizza says you need to use an INDEX array to get the results and then concatenate them together
    Not got space to upload to here but you can get from this link [Only registered and activated users can see links. ]

    Thanks to akimba

    Squizza (13th February 2015) 


  4. #4
    DF VIP Member
    satzzz's Avatar
    Join Date
    Oct 2000
    Location
    Here
    Posts
    2,628
    Thanks
    146
    Thanked:        549
    Karma Level
    412

    Default Re: Excel database help

    Thanks fella's can't get my head around what you've done so I need to ask if you can do the same so STCKROOMS and MAX LEVELS read all options also and not just the first.
    I've looked at the new sheet and trying to get my head around it. I'll keep trying myself but i the meantime if you could look at it.
    Last edited by satzzz; 13th February 2015 at 12:06 PM.
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....

  5. #5
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    2,817
    Thanks
    1,020
    Thanked:        770
    Karma Level
    297

    Default Re: Excel database help

    Done, I have also tidied up your sheet abit as you had Part number copied about 3 or 4 times when you only really need this once.

    Download from same place I have overwritten rar file with new one ;-)

    Thanks to akimba

    satzzz (14th February 2015) 


  6. #6
    DF VIP Member
    satzzz's Avatar
    Join Date
    Oct 2000
    Location
    Here
    Posts
    2,628
    Thanks
    146
    Thanked:        549
    Karma Level
    412

    Default Re: Excel database help

    You're a star mate
    Just use enough water to cover your vegetables,the same goes for when you're having a bath....

Similar Threads

  1. Car Reg Database?
    By AspectUK in forum Website Coding & Graphics
    Replies: 1
    Last Post: 13th September 2012, 12:27 PM
  2. Importing Excel spreadsheet into MySQL database
    By ParkerDigital in forum Website Coding & Graphics
    Replies: 4
    Last Post: 23rd November 2006, 03:29 PM
  3. were is database
    By copystuff in forum Digital & Cable TV
    Replies: 2
    Last Post: 14th July 2004, 01:58 PM
  4. Database Chk Pls
    By Big AP in forum Digital & Cable TV
    Replies: 3
    Last Post: 4th April 2004, 04:51 PM
  5. N-database
    By macy in forum Digital & Cable TV
    Replies: 3
    Last Post: 6th June 2003, 08:15 PM

Social Networking 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
  •