Results 1 to 21 of 21

Select data within a range

Threaded View

lone.vaas Select data within a range 03-16-2019, 04:15 AM
AliGW Re: Select data within a range 03-16-2019, 04:19 AM
lone.vaas Re: Select data within a range 03-16-2019, 04:51 AM
AliGW Re: Select data within a range 03-16-2019, 04:55 AM
lone.vaas Re: Select data within a range 03-16-2019, 05:01 AM
AliGW Re: Select data within a range 03-16-2019, 05:16 AM
lone.vaas Re: Select data within a range 03-16-2019, 05:29 AM
AliGW Re: Select data within a range 03-16-2019, 05:31 AM
lone.vaas Re: Select data within a range 03-16-2019, 05:45 AM
AliGW Re: Select data within a range 03-16-2019, 06:14 AM
lone.vaas Re: Select data within a range 03-16-2019, 06:34 AM
AliGW Re: Select data within a range 03-16-2019, 07:04 AM
avk Re: Select data within a range 03-16-2019, 07:02 AM
lone.vaas Re: Select data within a range 03-16-2019, 10:02 AM
torachan Re: Select data within a range 03-16-2019, 12:25 PM
AliGW Re: Select data within a range 03-16-2019, 12:26 PM
lone.vaas Re: Select data within a range 03-18-2019, 01:20 AM
lone.vaas Re: Select data within a range 04-07-2019, 09:52 AM
lone.vaas Re: Select data within a range 04-09-2019, 01:12 AM
torachan Re: Select data within a range 04-14-2019, 10:27 AM
lone.vaas OK but thanks for looking in... 04-19-2019, 01:32 AM
  1. #1
    Registered User
    Join Date
    03-16-2019
    Location
    Mumbai
    MS-Off Ver
    OFFICE 365
    Posts
    16

    Select data within a range

    I have to work with multiple data sets everyday and I need to follow the same procedure for each data set.
    So this is not a 'one time' thing. I am fine with basic excel and that's where my experience is limited to.

    I need to select data based on a range that I define.

    Column A to B are values I define
    Column E to H is the data range
    Column J to M are the results I need. (just the average values within that range actually)

    A formula that takes the range i define, looks through the data range and gives the average within that range would make my life a whole lot easier.

    If anyone could help me please.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select range of data
    By vipx2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2016, 03:16 PM
  2. [SOLVED] Select range of data VBA
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2016, 11:40 AM
  3. Replies: 3
    Last Post: 09-03-2014, 09:59 AM
  4. Select specific range in last row with data
    By violetmind in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-13-2014, 01:55 AM
  5. Replies: 4
    Last Post: 06-17-2013, 05:21 AM
  6. Select a set of data that matchs a range then input said data into a new column SOS
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2012, 07:46 PM
  7. Select / range data
    By ciprian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2011, 02:49 AM

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