+ Reply to Thread
Results 1 to 1 of 1

Adding & average calculating stock

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    uae
    MS-Off Ver
    2013
    Posts
    21

    Adding & average calculating stock

    Hi,


    Q1- I want to add the 5-month stock & calculate the average stock. |I used consolidate feature in sheet 7 but "Item Description" & "Whse" field does not come in the field. Kindly tell me how to do that with consolidate feature & different function or which one will be easy. I gather all the data in 5 month inventory sheet.

    Q2- After calculating the Average stock unit of different item, I have another sheet were I have to put it average unit value, how I can use index match in that sheet.
    Last edited by anu0512; 03-01-2019 at 04:27 AM. Reason: File updated

+ 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. Trying to build Function to calculate average of stock returns, with stock prices as input
    By jameslaughlin129 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2017, 05:18 PM
  2. Query regarding Calculating Weighted average value or average value in Percentage.
    By adamsmith1337 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2016, 07:56 AM
  3. Replies: 10
    Last Post: 04-25-2013, 06:12 PM
  4. Replies: 0
    Last Post: 01-22-2013, 12:22 PM
  5. Replies: 0
    Last Post: 09-25-2012, 09:39 AM
  6. Replies: 5
    Last Post: 06-19-2012, 04:37 PM
  7. [SOLVED] calculating days of stock
    By Cor in forum Excel General
    Replies: 1
    Last Post: 05-06-2005, 05:06 PM

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