Results 1 to 9 of 9

HELP with STDEVPA and Returning Multiple Individual Values

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    SoCal
    MS-Off Ver
    Excel 2007
    Posts
    7

    HELP with STDEVPA and Returning Multiple Individual Values

    Hey guys,

    I'm having trouble with writing an equation that would help me perform a STDEVPA function on sales for each individual item sold in the past year. The Sales Record raw data sheet has thousands of records, with each individual item having multiple sales transactions. My goal is to reference the item number and bring back multiple individual values for each of the item number to derive their standard deviations. I've tried using the Index, Match, Small, Row functions but am not experienced enough with those to write an equation that would help me.

    I'm really hoping you guys can help me with this. Sorry, I can't attach my workbook for security reasons.

    Please find an over-simplified mock Sales Sheet attached that should help make it easier to understand.

    Mock Sales Sheet - Excel Help.xlsx

    Thanks in advance!!
    Last edited by MrIceBreaker; 03-17-2014 at 11:57 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find and replace multiple values within individual cells
    By phbeats in forum Excel General
    Replies: 3
    Last Post: 03-14-2014, 05:13 PM
  2. Returning multiple values in multiple cells based upon one input
    By ccoonsk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 10:01 AM
  3. Replies: 2
    Last Post: 05-12-2011, 01:34 PM
  4. Assining individual values to multiple identical strings
    By vivavilla in forum Excel General
    Replies: 1
    Last Post: 03-08-2011, 07:58 AM
  5. STDEVPA question
    By RD Wirr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2005, 01:00 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