+ Reply to Thread
Results 1 to 6 of 6

Parallel between values

Hybrid View

Leo37587 Parallel between values 02-20-2017, 11:32 PM
avk Re: Parallel between values 02-21-2017, 12:38 AM
Glenn Kennedy Re: Parallel between values 02-21-2017, 01:15 AM
Leo37587 Re: Parallel between values 02-21-2017, 02:08 AM
Leo37587 Re: Parallel between values 02-21-2017, 02:24 AM
avk Re: Parallel between values 02-21-2017, 02:28 AM
  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Parallel between values

    Is this what you mean? If the no of units is in A1 =A1/337
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  2. #2
    Registered User
    Join Date
    05-10-2013
    Location
    Milano, Italy
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Parallel between values

    Sorry I try to clarify.

    One single Item measures 0.00297 CBM.

    So 1/0.00297 = 336.7 --> in a Cubic meter of space I can theoretically fit approx 337 items.

    So:

    (Qty)A1:337 (Volume,CBM)B1:1

    I would like to raise and lower the quantity in A1 and have an automatic adjustment in B1.

    Thanks.

  3. #3
    Registered User
    Join Date
    05-10-2013
    Location
    Milano, Italy
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Parallel between values

    Hi Glenn Kennedy,

    Actually you already provided the solution. So Simple! Shame on me...

    Thanks a lot.

+ 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] make list of values corresponding to unique values in parallel list
    By johnandrews in forum Excel General
    Replies: 3
    Last Post: 11-18-2014, 09:46 AM
  2. Parallel Processing
    By BuffaloFan32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2014, 02:45 PM
  3. Replies: 0
    Last Post: 10-28-2013, 02:55 PM
  4. Replies: 3
    Last Post: 04-29-2013, 10:15 AM
  5. Labels on bar charts parallel
    By se7encm in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-23-2010, 04:21 AM
  6. Running two vba macros in parallel
    By Milos Setek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2008, 09:26 AM
  7. [SOLVED] Looping across two parallel ranges
    By colin_e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2006, 07:25 PM

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