if/index statement.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a list of names in column A. In column E I have a list of lette
codes to go with each name. I want to write a function to do the folllowing
Look for the letter P or S in Column E. when an Instance occurs I want it t
copy the name and put it in a seperate worksheet

Thank you for your time and effort
Stev

PS I submitted this yesterday, however the INDEX Statement wouldn't work....anyone have any other ideas?
 
If you remained with your original post, then others would know what was
suggested, and what didn't satisfy you, and perhaps make other suggestions
without maybe repeating what was done yesterday.

What exactly "wouldn't work"?
No return - wrong return - error ... What?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

i have a list of names in column A. In column E I have a list of letter
codes to go with each name. I want to write a function to do the folllowing.
Look for the letter P or S in Column E. when an Instance occurs I want it to
copy the name and put it in a seperate worksheet.

Thank you for your time and effort,
Steve

PS I submitted this yesterday, however the INDEX Statement wouldn't
work....anyone have any other ideas?
 
It was only returning the first occurance and not a list of the names. Sorry for the confusion.
 
The easiest way to go is by using AutoFilter or code.

It starts to get complicated when you want multiple returns by using
formulas.
Check out this old post:

http://tinyurl.com/2lakm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


Steven said:
It was only returning the first occurance and not a list of the names.
Click to expand...
Sorry for the confusion.
 
Thank you sir

----- Ragdyer wrote: ----

The easiest way to go is by using AutoFilter or code

It starts to get complicated when you want multiple returns by usin
formulas
Check out this old post

http://tinyurl.com/2lak
--
HTH

R

--------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
--------------------------------------------------------------------------


Steven said:
It was only returning the first occurance and not a list of the names
Click to expand...
Sorry for the confusion
 
Back
Top