+ Reply to Thread
Results 1 to 2 of 2

Problems to display cells complying multiple conditions

  1. #1
    Registered User
    Join Date
    04-21-2014
    Location
    Budapest
    MS-Off Ver
    Excel 2010
    Posts
    1

    Lightbulb Problems to display cells complying multiple conditions

    Hi All,

    I am not a master in VBA Excel and I really stuck with a problem.
    In nutshells:
    Given a database like this:

    Name Dep Grade
    Person 1 1 Level 12
    Person 2 1 Level 12
    Person 3 2 Level 11
    Person 4 2 Level 11
    Person 5 2 Level 10
    Person 6 3 Level 10
    Person 7 4 Level 9
    Person 8 4 Level 9
    Person 9 4 Level 8
    Person 10 4 Level 8
    This list can be 220 rows long, but it depends on the organisation.
    My Aim to arrange the values in the name column in a table like this:
    1 2 3 4
    Level 12
    Level 11
    Level 10
    Level 9
    Level 8

    Since I know there's possibility of more cells with same level and department, I needed a table sheet with exact rows I manage to display as many rows for each levels as they have in the database (f.e. each level is at least 1 row, but if there are more cells than the actual count of the levels).
    I tried with while and also with for but it always fails to how the cells in the correct rows and columns:

    Please Login or Register  to view this content.

    I really appreciate any ideas.

    Thanks.
    Last edited by Davidish; 04-21-2014 at 03:03 PM. Reason: missing code mark

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,596

    Re: Problems to display cells complying multiple conditions

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click Edit post, select your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ 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. [SOLVED] Drop Down Data Validation - Display a result based on multiple conditions
    By carlmf1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:50 PM
  2. Get cells to display certain values with conditions
    By veewyy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2013, 05:39 AM
  3. Using IF function to display multiple conditions?
    By Abgirl in forum Excel General
    Replies: 2
    Last Post: 03-12-2012, 02:15 PM
  4. Problems with assigning range of cells to display chart
    By Richard Flame in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-03-2006, 09:52 AM
  5. Combining Text from multiple cells under multiple conditions
    By KNS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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