Results 1 to 10 of 10

VBA code to Find Average

Threaded View

  1. 05-31-2020, 01:00 AM #1
    pankaj25
    pankaj25 is offline
    Registered User
    Join Date
    05-31-2020
    Location
    Jaipur
    MS-Off Ver
    Office 365
    Posts
    5

    Question VBA code to Find Average

    Hi All,

    I have table data as below. There are 3 column.
    Vol1
    CNT
    CNT_WISE_AVERAGE

    I want to write a VBA code to display the average value from "Vol1" column, based on "CNT value, and put the average value in "CNT_WISE_AVERAGE" column.

    There are nore then 5000 rows, having CNT values upto 80.

    Could anyone please help on this.

    Please find attached excel for sample data.
    Attached Files Attached Files
    Last edited by pankaj25; 05-31-2020 at 01:05 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find a Text, average last 20,if < 20 average all available.
    By richhhh in forum Excel General
    Replies: 42
    Last Post: 08-28-2016, 09:51 PM
  2. Find Average of different columns and colour code it
    By Johnty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2014, 04:09 AM
  3. [SOLVED] Find Average, Return Column Header of Number Closest To Average
    By djmyers in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-07-2013, 04:19 PM
  4. Index/Match to find Starting Point of Average, Ending Point of Average Variable
    By tgentry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2012, 01:04 AM
  5. Find last 6 (or3) dates that match a given criteria then find the average
    By krunk in forum Excel General
    Replies: 6
    Last Post: 07-09-2012, 11:06 AM
  6. Trying to find average
    By Ashleyflower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2011, 05:21 PM
  7. UDF code to find specific text in cell comments, then average cell values
    By bruch04 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1