+ Reply to Thread
Results 1 to 5 of 5

Data from One Range to Another - return an error if more than 1 entry per column

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Data from One Range to Another - return an error if more than 1 entry per column

    I need to bring data from range I3:Q13 to C3:G13 , in corresponded Columns
    So I need a Formula at C3.
    In D5 should be D4, Z5 so I need Error , I should have only one value in corresponded columns (that mean in I3:Q13, something wrong happened for column 2)
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 11-10-2019 at 02:32 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Data from One Range to Another, Unique

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Data from One Range to Another, Unique to corresponded columns

    I am not sure how can I better describe the title then this ...

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Data from One Range to Another, Unique to corresponded columns

    Neither do I!!

    In C3:

    =IFERROR(IF(SUMPRODUCT(--($I$2:$Q$2=C$2)*--($I3:$Q3<>""))<=1,INDEX($I3:$Q3,MATCH(1,INDEX(($I$2:$Q$2=C$2)*($I3:$Q3<>""),0),0)),"Error"),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Data from One Range to Another - return an error if more than 1 entry per column

    I did change the title for you, as you made an effort, but... I doubt if ANYONE would ever want to do the same kind of thing that you are wanting to do...

    I often wonder what you really want all these formulae for!!!!!

+ 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. [SOLVED] Populate a Listbox with Unique data of filtered range
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2018, 02:35 AM
  2. Replies: 14
    Last Post: 03-19-2017, 08:11 AM
  3. Need change in code to add unique data to range
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2017, 02:02 AM
  4. [SOLVED] Add unique data to 2 separate name.range using vba
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-07-2016, 05:00 AM
  5. Replies: 1
    Last Post: 07-04-2014, 11:52 AM
  6. [SOLVED] Count unique values in a data range with exemption
    By lheyanne in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-01-2013, 11:48 AM
  7. [SOLVED] Validating Data To Be Unique In A Range
    By James Dobson in forum Tips and Tutorials
    Replies: 8
    Last Post: 04-14-2007, 12: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