Results 1 to 5 of 5

Splashing the numbers based on past average

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    DUBAI
    MS-Off Ver
    Microsoft 365
    Posts
    47

    Post Splashing the numbers based on past average

    Good Day all,

    I am trying to allocate the May projected cost (H2) into country level (H4:H16) based on the country average of last month actual (F4:F16).
    The country average should be the same as Actual April for May. File attached for your easy reference.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average numbers based on date range
    By sunriver61 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2021, 08:43 PM
  2. Average to be updated based on weekly used numbers
    By jrubes77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2018, 12:52 PM
  3. [SOLVED] Need to Average numbers based off of 2 Criteria
    By nsmjc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-01-2015, 02:57 PM
  4. Modifying A Range Of Numbers Based On An Average
    By quench in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2015, 07:36 AM
  5. Average numbers based upon separate column
    By FreeThrow in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-08-2011, 01:32 AM

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