+ Reply to Thread
Results 1 to 6 of 6

select the relevant data for use from three lists

  1. #1
    Forum Contributor
    Join Date
    12-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    139

    select the relevant data for use from three lists

    All

    I am seeking assistance in how to select the relevant address for use from three lists were the address may be recorded. Please see attached file for example....

    I have the preferred name in column C, however if this is blank go to Column D else use Column B and paste preferred Name in Column E.

    I am guessing an if statement would work but unsure how to write it to do this....

    Any assistance greatly appreciated....

    rgds

    shaz5053
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: select the relevant data for use from three lists

    Hi Shaz,

    In column E, use this formula, and copy down (as required till the last record in your sheet) :

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  3. #3
    Forum Contributor
    Join Date
    12-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: select the relevant data for use from three lists

    Thanks Saranga84

    The formula did not work - only gave responses where there was a name in column C.... any ideas

    Please see attached....

    rgds

    shaz0503

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: select the relevant data for use from three lists

    Maybe

    =IF(COUNTA(B2:D2)=0,"",INDEX(B2:D2,1,MAX((B2:D2<>"")*COLUMN(B2:D2))-COLUMN(B2:D2)+1))

    This Array Formula, you need to press CTRL-SHIFT-ENTER button together and then copied down

    or see attach file

    Regards
    Azumi
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: select the relevant data for use from three lists

    Apologies, I'd given the wrong formula.

    Instead of checking for ISBLANK, use COUNTBLANK instead.

    Use the below formula :
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Note: You need to replace something else instead of [NO NAME] as highlighted in above formula.

  6. #6
    Forum Contributor
    Join Date
    12-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    139

    Smile Re: select the relevant data for use from three lists

    Thanks to you both - both did the job...

    rgds

    shaz0503

+ 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] Select Relevant Text till not exist. First Script.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 45
    Last Post: 04-04-2012, 03:45 PM
  2. Replies: 4
    Last Post: 06-06-2011, 07:54 PM
  3. SelectingCopying only relevant data across worksheets
    By miguelram in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2011, 08:31 PM
  4. Find relevant data from different data sets in a worksheet
    By Quagga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2010, 06:03 PM
  5. select relevant data and transpose
    By Back2Basics in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2009, 08:34 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