Results 1 to 13 of 13

Help required - Excel formula or Macro - Fill column with data based on cells in a table

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    8

    Question Help required - Excel formula or Macro - Fill column with data based on cells in a table

    Hello

    Last night I created a thread with a problem that was going to put me into an early grave, but you wonderful people saved me quite easily.

    Seeing as the result was so good I need your help with one other small formula

    SEE BELOW POST FOR UPDATED EXAMPLE DATA

    Solution provided by Kaper to create tables 2 and 3 (minus the red column)
    =COUNTIFS(B$2:B$2000,B2,C$2:C$2000,C2)
    and copy it down. now auto-filter everything except 1
    you will get table 2

    and slight modification:
    =COUNTIFS(B$2:B2,B2,C$2:C2,C2)
    copy down
    and show only values with 1 - you will get table 3 (minus the red column)
    What I need your help with is to create the additional column on table 3 that I have highlighted in red.

    all it needs to do is list the corresponding point number AND duplicate pair if one exists.

    The example data should display what I mean.

    Let me know if I am not explaining it clearly

    Cheers

    Sdak
    Attached Files Attached Files
    Last edited by sdak; 03-07-2014 at 06:08 AM. Reason: updated example data sheet

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Complex Excel Formula Required for Obtaining Values based on Column & Row
    By adeel726 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 04:36 PM
  2. [SOLVED] VBA fill in cells in a new column in table based on multiple criteria from other columns
    By HRA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2013, 06:48 AM
  3. Replies: 1
    Last Post: 11-07-2012, 01:50 AM
  4. Fill down formula based on another column data
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2012, 10:41 AM
  5. Creating Macro to fill data based on another column
    By jbk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2012, 02:57 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