Filter and show rows

[Mr.Karr]

Hello,

I have a requirement is filter a column & extract/show activities from other columns in a sequence. Is there a way we can do this with excel formula ?

Appreciate your help. Please see the same file attached.

BR,
K

 

[vletm]

Mr.Karr
Is there always fixed number of rows per CAN?
If NO,
then You could check these two ways:
a) Filter by cell B1
b) Filter by cell J1

 

[Mr.Karr]

Mr.Karr
Is there always fixed number of rows per CAN?
If NO,
then You could check these two ways:
a) Filter by cell B1
b) Filter by cell J1

@vletm : thanks for responding.
No, for CAN, total number of rows may vary depends on customer.
This data is for visualization & storytelling purposes. Also, I need to sort data by date latest.

Any thoughts ?

 

[vletm]

Mr.Karr
Both of those versions can sort with any of those columns...

 

[Mr.Karr]

Mr.Karr
Both of those versions can sort with any of those columns...

@vletm , Yes but the main intention is to sort them down by date & track the events. When they called call center & after that what follows in a sequential order.

your thoughts ?

 

[vletm]

Mr.Karr
Your original case has been:
I have a requirement is filter a column & extract/show activities from other columns in a sequence.
Show me
what do You would like to see
with any data
which is as real as possible...

Create some sample sheets from Your needed layouts.

Those are my thoughts...

 

[bosco_yip]

Or, try this formula solution.................

1] In C20, formula copied across and down :

=IFERROR(INDEX(C$1:C$16,AGGREGATE(15,6,ROW(C$1:C$16)/($B$1:$B$16=$B$20),ROWS($1:1))),"")

2] Using Format Painter, copy from F2 date format to F20:F31

3] Select B20 dropdown list, in change to other name for testing purpose

Regards
Bosco

 

[Mr.Karr]

Or, try this formula solution.................

1] In C20, formula copied across and down :

=IFERROR(INDEX(C$1:C$16,AGGREGATE(15,6,ROW(C$1:C$16)/($B$1:$B$16=$B$20),ROWS($1:1))),"")

2] Using Format Painter, copy from F2 date format to F20:F31

3] Select B20 dropdown list in change to other name for testing purpose

Regards
Bosco

Thank you @bosco_yip I can utilize this.

 

[Peter Bartholomew]

If you use Office 365 you will, sometime over the next few months be able to use
= FILTER( log, logCAN=CAN )

 

[vletm]

Mr.Karr
You've written that:
the main intention is to sort them down by date & track the events.
When they called call center & after that what follows in a sequential order.Do You have needed layout for that?
... your thoughts ?