Posted to microsoft.public.excel.worksheet.functions
|
|
if then statement to return text from cells satisfying condition
Thanks. It worked!
On Aug 10, 10:31*am, NBVC wrote:
After you enter the formula, you need to hold the CTRL and SHIFT keys
down and then press ENTER.. You should see { } brackets appear around
the formula.. and the result should be visible in the cell.
Savvy;447518 Wrote:
I tried doing this and the resulting cell looks blank. Should I be
running any of the extra functions that I added in, for this to work?
On Aug 10, 9:59 am, NBVC wrote:
Download the free Morefunc.xll addin from he'Morefunc - Free
software downloads and software reviews - CNET Download.com'
(http://download.cnet.com/Morefunc/30...-10423159.html)
and use this formula:
=SUBSTITUTE(TRIM(MCONCAT(IF(ISTEXT(A1:G1),A1:G1,"" )," "))," ",",")
which must be confirmed with CTRL+SHIFT+ENTER not just ENTER...
after
you have adjusted the ranges to suit.
--
NBVC
Where there is a will there are many ways.
'The Code Cage' ('The Code Cage - Microsoft Office Help - Microsoft
Office Discussion' (http://www.thecodecage.com))
------------------------------------------------------------------------
NBVC's Profile:'The Code Cage Forums - View Profile: NBVC'
(http://www.thecodecage.com/forumz/members/nbvc.html)
View this thread:'if then statement to return text from cells
satisfying condition - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=123925)
--
NBVC
Where there is a will there are many ways.
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile:http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:http://www.thecodecage.com/forumz/sh....php?t=123925- Hide quoted text -
- Show quoted text -
|