+ Reply to Thread
Results 1 to 26 of 26

if A3 has a number in, show A1 details in Z1

Hybrid View

petelomax if A3 has a number in, show... 08-06-2012, 04:58 AM
oeldere Re: if A3 has a number in,... 08-06-2012, 05:05 AM
mmmarks Re: if A3 has a number in,... 08-06-2012, 05:06 AM
Ace_XL Re: if A3 has a number in,... 08-06-2012, 05:33 AM
petelomax Re: if A3 has a number in,... 08-06-2012, 08:26 AM
oeldere Re: if A3 has a number in,... 08-06-2012, 08:41 AM
Ace_XL Re: if A3 has a number in,... 08-06-2012, 08:47 AM
petelomax Re: if A3 has a number in,... 08-06-2012, 09:35 AM
ChemistB Re: if A3 has a number in,... 08-06-2012, 10:12 AM
petelomax Re: if A3 has a number in,... 08-06-2012, 10:38 AM
ChemistB Re: if A3 has a number in,... 08-06-2012, 11:00 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 03:53 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 06:19 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 06:30 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 06:37 AM
oeldere Re: if A3 has a number in,... 08-10-2012, 07:12 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 06:48 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 07:03 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 07:07 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 07:20 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 07:45 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 07:53 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 08:44 AM
petelomax Re: if A3 has a number in,... 08-10-2012, 08:55 AM
smls Re: if A3 has a number in,... 08-10-2012, 09:00 AM
jason.b75 Re: if A3 has a number in,... 08-10-2012, 09:43 AM
  1. 08-06-2012, 05:33 AM #1
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: if A3 has a number in, show A1 details in Z1

    How about..

    =IF(COUNT(A3:C3)>0,CONCATENATE(A1,B1,C1),"")

    adapt your range accordingly
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  2. 08-06-2012, 08:26 AM #2
    petelomax is offline
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    140

    Re: if A3 has a number in, show A1 details in Z1

    Thanks Ace_XL, works great but my range is vast, it runs from G to AS so the end part of the formula, ie G9,H9,I9,J9 etc will be very big, is there a way to cut this down? thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1