Results 1 to 3 of 3

Adding Match to a formula and unique list in dropdown box

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Adding Match to a formula and unique list in dropdown box

    Hi,

    Can anyone help with the two requirements listed below please.

    On the Journal sheet in cell I6 I would like a list which will only display unique dates based in column K of the data 2 tab. How do I do this?

    Then the second requirement is to amend the formulas currently on the summary sheet. Currently it is return all data from “data 2” sheet howeverwhat I would like is that if there is da date in cell I6 for it only to pull data based on the match.

    e.g. if I6 is blank then return everything
    e.g. 2 If I6 contains 25/5/2015 then it would match this with column K of the data sheet and return the values 396 and 197 only.

    Can anyone help with either please?
    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. Create dropdown list in Excel that will only list unique entries
    By MissAudrey in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2015, 04:56 PM
  2. How to generate a unique id based on a dropdown list
    By hannahvan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2014, 03:16 PM
  3. [SOLVED] Formula (array?) to list unique entries that match criteria?
    By Rerock in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-11-2014, 04:23 PM
  4. Unique list of records dropdown in Data Validation list
    By sghosh12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2013, 08:27 AM
  5. Unique dropdown list based on two criteria but...
    By Darsk in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 04:37 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