Results 1 to 7 of 7

Blanks cells against date picking without duplication in row to column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Blanks cells against date picking without duplication in row to column

    Data:

    Branch Invoice No Invoice Date Value Dispatch Date
    BHOPAL 4903714620 01.04.2015 2873.96 05.04.2015
    BHOPAL 4903715258 02.04.2015 1907.08 05.04.2015
    BHOPAL 4903717196 04.04.2015 1907.08
    BHOPAL 4903718178 06.04.2015 9017.08
    BHOPAL 4903718298 06.04.2015 9017.09
    BHOPAL 4903718299 06.04.2015 1907.08 10.04.2015
    BHOPAL 4903720880 08.04.2015 9915.9 10.04.2015
    BHOPAL 4903722128 09.04.2015 12789.86

    Req Format

    Branch Invoice Date

    Bhopal: 04.04.2015 06.04.2015 09.04.2015

    How do blanks cells against Invoice Date picking without duplication from row to column for corresponding to the Branch's

    please help me. file and snap shot attached herewith.
    Attached Images Attached Images
    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. Replies: 3
    Last Post: 05-09-2015, 01:25 AM
  2. [SOLVED] find a column by date and filter that column by removing blanks
    By rsami in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2013, 10:56 PM
  3. [SOLVED] Vlookup – Picking up first date and then picking up second date if there is one.
    By CranstonWatts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2012, 11:32 AM
  4. Picking entries left to right and skipping blanks
    By Hitch75 in forum Excel General
    Replies: 8
    Last Post: 10-13-2011, 10:38 AM
  5. Picking Values from a row with blanks?
    By jbanks in forum Excel General
    Replies: 6
    Last Post: 10-06-2008, 05:50 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