Results 1 to 4 of 4

Question: Concise List

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2007
    Posts
    89

    Question Question: Concise List

    Hello,

    I have a list of rooms in Col. A and a List of devices in Col. C and time used in Col. F.

    I have a list of unique rooms in Col. I and unique devices in Col. J.

    Col A:
    AE137
    AE137
    AE137
    AE137
    AE137

    Col. C:

    Projector
    Blank
    Blank
    Desktop
    Laptop

    I would like a concise list of Rooms, Devices and Times used:

    AE137, Projector, time used, Desktop, time used, Lap top, time used.

    Is it possible?

    Thank you,

    Stephanie
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. making a lookup formula more concise
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 02-21-2014, 08:40 PM
  2. Make repetitive IF formula more concise?
    By leaning in forum Excel General
    Replies: 7
    Last Post: 03-18-2011, 05:48 AM
  3. making my data more concise
    By chedges in forum Excel General
    Replies: 2
    Last Post: 02-11-2009, 12:22 PM
  4. a more concise formula
    By jwongsf in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2009, 10:20 AM
  5. [SOLVED] Concise border removal method
    By XP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2006, 04:15 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