+ Reply to Thread
Results 1 to 3 of 3

Query regarding formation of similar match data

  1. #1
    Registered User
    Join Date
    10-10-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    58

    Query regarding formation of similar match data

    Hi,

    Please help on the below issue.

    I have a data from cells A2:GF6 by date wise. Now I need to format these data into similar type by date wise.

    Data:
    Data.jpg

    Result to be required:
    Result.jpg

    Thank u
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by roven.aravind; 05-30-2018 at 02:46 AM. Reason: resource column not included

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,416

    Re: Query regarding formation of similar match data

    In the attached file I put your dates in column A from A22 downwards, and this formula in B22:

    =VLOOKUP(COUNTIF(A$22:A22,A22),$A$4:$B$6,2,0)

    In C22 I used this formula:

    =INDEX($C$4:$GF$6,MATCH($B22,$B$4:$B$6,0),MATCH($A22,$C$2:$GF$2,0)+COLUMNS($C:C)-1)&""

    which can be copied across into D22:H22. Then those formulae on row 22 can be copied down as far as you need.

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-10-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: Query regarding formation of similar match data

    Thank u very much.
    It is working.
    Can you please please explain the detailing about +COLUMNS($C:C)-1)&""

+ 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. Match and average similar data
    By P91 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 04:55 AM
  2. Replies: 3
    Last Post: 05-18-2012, 08:11 AM
  3. Replies: 3
    Last Post: 04-23-2012, 07:14 PM
  4. vba to match multiple similar data question
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-12-2012, 05:53 PM
  5. To match data of similar coding
    By avk in forum Excel General
    Replies: 5
    Last Post: 01-25-2010, 05:35 PM
  6. Query to find similar data..
    By dvspriest in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2008, 11:33 PM
  7. MATCH function - 2 columns w/ SIMILAR, not EXACT data
    By Jane in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2005, 12:06 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