+ Reply to Thread
Results 1 to 5 of 5

Sorting raw data by date and other variables

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel:Mac 2011 14.4.1
    Posts
    25

    Sorting raw data by date and other variables

    This is very similar to an issue I had before with a spreadsheet, and I'm using a similar formula but I cant seem to get it right. Forgive the condition of the sheet, the higher ups want to piece on more functionality without redoing the original workbook. What I am trying to do is take raw sales data from Shipworks and have it populate the monthly sales section. With this functionality we could cut hours off running the monthly sales numbers. However, it needs to be able to draw from the list based upon color as well as the month the sale took place. Unfortunately, the color section is filled in based on what's on another page using a formula as are numerous other fields, adding complictions. I feel the only way to adequately understand the conundrum I have is by providing a pared down copy of the workbook with sales data. The formula I'm using is in B3. I hope I've explained this properly enough and will be checking back frequently to answer any questions, thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel:Mac 2011 14.4.1
    Posts
    25

    Re: Sorting raw data by date and other variables

    Can we bump here? I'm actually surprised no one's even responded yet, could this be in the wrong section?

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel:Mac 2011 14.4.1
    Posts
    25

    Re: Sorting raw data by date and other variables

    Really? No one can offer any push in the right direction?

  4. #4
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel:Mac 2011 14.4.1
    Posts
    25

    Re: Sorting raw data by date and other variables

    I mean is it something I said? No one can give me any advice on this issue at all? If it's not clear I'd be happy to elaborate, clarify, or correct anything, I just need to figure out a way to make this work and since it's such a vague issue it's very hard to look up otherwise

  5. #5
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel:Mac 2011 14.4.1
    Posts
    25

    Re: Sorting raw data by date and other variables

    Anyone? Anyone at all?

+ 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. [SOLVED] Need formula for sorting data by based on two variables
    By kl989 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2014, 02:19 AM
  2. [SOLVED] Sorting variables from a file and creating table with some data
    By ajang in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2013, 11:36 PM
  3. Sorting/Placing Data by Three Variables
    By keenercoug in forum Excel General
    Replies: 1
    Last Post: 08-20-2010, 12:49 AM
  4. 3 columns; date and two data, problem is sorting and calculating with respect to date
    By phosphorescence in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2008, 04:21 PM
  5. Paste data into cell based on date variables
    By tanewha69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2006, 06:44 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