Creating a list from a list

[Hélio]

Hi there!! I´m back to this fantastic forum..

Today i have a new situation driving me crazy. Tried a lot of things but something is being missed.

I have a list and need to create a new list with some itens from this one. The criteria is the 2 first letters of System name of column A.

To better understand please see example attached.

my best regards to all.

 

[eibi]

Helio,

I've used this link in the past to do the type of thing you're asking:

http://www.get-digital-help.com/200...etically-sorted-list-extracted-from-a-column/

I think a variation on this array formula from that site would probably do the trick:

=INDEX($A$2:$A$14, MATCH(MIN(IF((COUNTIF($D$1:D1, $A$2:$A$14)=0)*($B$2:$B$14=0), 1, MAX((COUNTIF($A$2:$A$14, "<"&$A$2:$A$14)+1)*2))*(COUNTIF($A$2:$A$14, "<"&$A$2:$A$14)+1)), IF($B$2:$B$14=0,COUNTIF($A$2:$A$14, "<"&$A$2:$A$14)+1,""), 0))

Control+Shift+Enter

 

[tomas]

Hi there!! I´m back to this fantastic forum..

Today i have a new situation driving me crazy. Tried a lot of things but something is being missed.

I have a list and need to create a new list with some itens from this one. The criteria is the 2 first letters of System name of column A.

To better understand please see example attached.

my best regards to all.

Hi its done

 

[Deepak]

VBA or Formuale

 

[Deepak]

Hi,

Universal for all cells...

CSE

=INDEX(List_rng,SMALL(IF(LEFT(INDEX(List_rng,,1),2)="EU",ROW(List_rng)),ROW()-1),COLUMN())


Check attached.

 

[Hélio]

Hello team, sorry for late reply.. Both conditions work perfectly.. Eibi your formula is one of most complete i ever saw, you really knows it deeply..
Deepak, your way to prepare the formula is really a great in sign, and it´s even possible to create a variable field in witch i can choose what System name i want to drag down from the list... really Amazing that...

One more time thank you both..

 

[Deepak]

Hi,

Thnx for the feedback.

You might forget to like the same.