+ Reply to Thread
Results 1 to 3 of 3

List with 2 variables

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Office 2019

    List with 2 variables

    I have a long list with many values with object temperature and ambient temperature.
    I want all object temperatures to come in succession in a row and all of the ambient temperatures come in another row.
    ambient temperature stands on odd colonies and object tempereature stands on some columns. How can I do this?

    Skjermbilde (369).png

    as in this picture, but now I have just taken and copied the values over to the right cell but doing so with 25000 values takes a very long time
    Attached Files Attached Files
    Last edited by Harald93; 05-07-2019 at 06:03 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.

    Re: List with 2 variables

    Hi, and welcome to the forum

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 2019

    Re: List with 2 variables

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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. Multiple variables to create a list
    By Tarontagosh in forum Excel General
    Replies: 1
    Last Post: 05-03-2017, 08:50 AM
  2. [SOLVED] Get list of variables
    By plans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2016, 06:28 PM
  3. Replies: 3
    Last Post: 06-14-2014, 03:05 PM
  4. Multiple Variables for Lookup and List
    By capitalsfan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2013, 05:20 PM
  5. Looking up results from a list with two variables
    By damage in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 08-13-2013, 07:11 AM
  6. Sorting using a predetermined list of variables
    By cheddarthief in forum Excel General
    Replies: 2
    Last Post: 09-15-2011, 08:52 AM
  7. List of variables
    By w_lred in forum Excel General
    Replies: 1
    Last Post: 11-21-2008, 06:26 PM


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