Results 1 to 4 of 4

Data selection using drop down options

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2023
    Location
    Glasgow
    MS-Off Ver
    Office 365
    Posts
    25

    Data selection using drop down options

    Hi,

    Got my original formula in a separate thread but looking to expand this if possible?

    The formula in line 6 pulls the relevant data from the selected drop down options in cells B3 & E3

    I am now trying to split this data as per contract status in blue highlighted cells (Which when totalled will match the data populated in line 6)


    Any ideas what the best formula would be?

    Another request, although I don't think possible, would be to then list the sales orders in line 14 down showing only the movements between the 2 selected dates? (i.e. list the sales order number and what has moved - status change, order value change. I would not want to show any sales orders that have no movement)

    Many thanks again for your assistance
    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. Make a table based on all options in a Data Validation drop-down
    By SouthOxon1997 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2021, 10:41 AM
  2. [SOLVED] Drop down list and matching drop down selection to other data
    By connormg in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-06-2015, 02:18 AM
  3. Post drop down selection in html data dependent on drop down is not coming
    By wfm007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2015, 08:57 AM
  4. Replies: 1
    Last Post: 01-21-2015, 11:26 AM
  5. Replies: 2
    Last Post: 12-10-2014, 12:42 AM
  6. Replies: 3
    Last Post: 05-30-2012, 12:35 PM
  7. Replies: 1
    Last Post: 03-06-2012, 10:19 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