1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Need a formula/code to get an individual price from a range

Discussion in 'Business Applications' started by Pedro14, Jul 17, 2019.

Thread Status:
Not open for further replies.
  1. Pedro14

    Pedro14 Thread Starter

    Joined:
    Jul 6, 2019
    Messages:
    13
    This is a share related question.
    I am trying to ascertain what the volume at each price a share traded at during a day's trading.
    In the attached file on tab"Course of sales" I have used Min and Max to ascertain the range share has traded.
    You will note in column B the prices have been sorted AtoZ

    I have dummied up the price in column H by adding .0025 to give an idea of what i am after.
    Questions
    1. Is there a way to get the actual individual prices within the Min and Max and show them in column H
    2. Is there another way to transfer individual prices from Column B to column H
    Am using Excel 2003

    Tech Support Guy System Info Utility version 1.0.0.4
    OS Version: Microsoft Windows 10 Home, 64 bit
    Processor: Intel(R) Core(TM) i5-3330 CPU @ 3.00GHz, Intel64 Family 6 Model 58 Stepping 9
    Processor Count: 4
    RAM: 8071 Mb
    Graphics Card: Intel(R) HD Graphics, -1984 Mb
    Hard Drives: C: 446 GB (182 GB Free); D: 931 GB (692 GB Free);
    Motherboard: Gigabyte Technology Co., Ltd., B75M-D3V
    Antivirus: Norton 360, Enabled and Updated
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1230156

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice