Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 18th 09, 08:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 460
Default Pull text from cell with if statement

For example if a set of cells read BEG70
DEG60
BEG80
and I want to write an if statement that will pull all the cells where the
text starts with BEG ( I want to pull BEG70 and BEG80) how do I do that?























  #2   Report Post  
Old February 18th 09, 08:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default Pull text from cell with if statement

Hi,
Why you don't use filter and select the information as per below

"Doug" wrote:

For example if a set of cells read BEG70
DEG60
BEG80
and I want to write an if statement that will pull all the cells where the
text starts with BEG ( I want to pull BEG70 and BEG80) how do I do that?






















  #3   Report Post  
Old February 18th 09, 08:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2,722
Default Pull text from cell with if statement

Pull and do what??
An array answer is
=IF(LEFT(A2:A5,3)="BEG",A2:A5,)
Entered using Ctrl+Shift+Enter


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Doug" wrote:

For example if a set of cells read BEG70
DEG60
BEG80
and I want to write an if statement that will pull all the cells where the
text starts with BEG ( I want to pull BEG70 and BEG80) how do I do that?
























Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using an IF statement from a pull down box Jason Excel Worksheet Functions 7 January 2nd 09 12:58 PM
Setting up an If-Then Statement that will pull from a valdiated li govols865 Excel Worksheet Functions 2 January 12th 07 10:48 PM
Create formula that will pull a value based on text in diff cell? So Tru Geo Excel Discussion (Misc queries) 0 June 22nd 06 08:16 PM
How do I get an IF statement to pull a date range?? Brooke Medvecky Excel Worksheet Functions 9 April 19th 06 08:48 PM
Pull-down text in a cell MrSeagull Excel Worksheet Functions 2 October 2nd 05 04:59 AM


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017