Want all the entries which starts with same letter

[Sudhakar Vashist]

Attached is a list, i want all the entries with starts with Unilever or Schlumberger

 

[Nebu]

Hi:

Something like this?

=IFERROR(INDEX($C$5:$C$29,AGGREGATE(15,6,(ROW($C$5:$C$29)-MIN(ROW($C$5:$C$29))+1)/ISTEXT(LOOKUP(2^15,SEARCH($F$5:$F$6,C5),$C$5:$C$29)),ROW(A1))),"")

Thanks

 

[Sudhakar Vashist]

Hi:

Nopes, i wanted 1 formula for both the entities (Unilever/Schlumberger).


Thank you

 

[Nebu]

Hi:

Its for both the entries range $F$5:$F$6 is Unilever/Schlumberger

Thanks

 

[Sudhakar Vashist]

Kindly help me understand this (Excel attached)


Thank you for your help!

 

[Nebu]

Hi:

Find the attached, the formula will give you all the names which contains either Unilever or Schlumberger, not necessarily in the start of the name but just anywhere in the name.

BTW you had used wrong reference in your formula


Thanks

 

[bosco_yip]

See attached file

Regards