+ Reply to Thread
Results 1 to 1 of 1

Pick item in column to be shown in line and columns

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Pick item in column to be shown in line and columns

    hello , please I have been trying with formulas and didn't work



    Please I have 24 item in E9:E32 I can only select 5 item and they must be placed in either P7,P16,P25,P34,P42
    if I unselect on of the 5 item them the corresponding cell in either (P7,P16,P25,P34,P42 ) must be empty

    for example if I select for instance one item in E10 if shall be in one of (P7,P16,P25,P34,P42 ) let say P16 then the
    number in R24 must the shown in M10


    please any help see attachment,
    Attached Files Attached Files

+ 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. selected item from column to line
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2014, 06:31 AM
  2. Pick a number in a column and it shows on another line
    By kuzna26 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2013, 02:38 PM
  3. Replies: 9
    Last Post: 10-25-2013, 12:13 AM
  4. Replies: 1
    Last Post: 10-09-2013, 11:44 AM
  5. Combining multiple line items into one line item based on column.
    By mguz018 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2012, 07:22 PM

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