![]() |
|
#1
|
|||
|
|||
![]() Quote:
Thanks for the reply! However, none of these equations works for me. The first one allows me to enter the formula, but the cell is blank, whereas I would like a formula that when entered in four consecutive cells gives me the first four nonblank text cells within the range I specified. The second column won't allow me to enter it all due to some sort of error :/ |
#2
|
|||
|
|||
![]()
I decided that my original answer works well, except for one issue.
=IF(COUNTIF(E1:H1,"?*")>=2,INDEX(E1:H1,SMALL(IF(E1 :H1<>"",COLUMN(E1:H1)-COLUMN(E1)+1),1)),"") (for the first nonblank) gives me what I want, but it needs to return a blank if there is no text to be returned (for example, if a particular row only has 3 non-blank text cells, it needs to still work for the 4th non-blank but just return "" so it appears blank). Instead, in the cases where there isn't any text to be returned, I get a #NUM! error. Any tips for how to get rid of this error and replace it with empty text like ""? Thanks! |
#3
|
|||
|
|||
![]()
My formulas work fine.
|
#4
|
|||
|
|||
![]()
Thank you!
![]() |
![]() |
Tags |
formula help |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Marco | Word VBA | 1 | 11-02-2015 05:08 PM |
![]() |
spc94 | Word VBA | 3 | 06-25-2015 04:46 AM |
Finding varying text in an MS Word file | sergiodcq | Word | 1 | 07-08-2014 03:12 AM |
Finding specific text within body of email | Tammfran | Outlook | 0 | 03-14-2014 02:32 PM |
Finding a text style in a cell | jimbassett | Excel | 1 | 02-10-2010 08:39 PM |