Group Data

**2nice** · 01-06-2020, 12:53 PM

I have a data set in which users sign up for a program and I'm trying to group them based on how long they have been on the program for. I'd like to group them by if they've been signed up for the program for at least 4 Weeks, 8 Weeks, etc.

My challenge is I want it to be all in 1 column to be able to filter easily and a user can belong to more than one group.

For example, if a John signs up for the program on Oct 25 2019 he would be on the program for at least 4 Weeks and 8 Weeks. If Becky signs up for the program on Oct 26 2019 she would be on the program for at least 4 Weeks.

What I would like is to be able to Filter by 4 Weeks and it include results for John and Becky. If I filter by 8 Weeks it should only include results for Becky.

Sounds simple and I must be overthinking something but would appreciate some help on this.

Thanks!

**CARACALLA** · 01-06-2020, 04:47 PM

N2=IFERROR(INDEX($A$2:$A$100,SMALL(IF(INDEX($C$2:$E$100,,MATCH($N$1,$C$1:$E$1,0))=SUBSTITUTE($N$1,"WK","")+0,ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($A$2:A2))),"")

Control+shift+enter

copy down

select week in dropdownlist in N1

**2nice** · 01-06-2020, 09:22 PM

Thank So Much CARACALLA!!!!!

Group Data

LinkBack

Thread Tools

Rate This Thread

Display

Group Data

Re: Group Data

Re: Group Data

Thread Information

Users Browsing this Thread

Similar Threads

Group Weekly Data with Totals for that Week VBA - Group by Date

Data -> Group -> Group does not work on A Sheet

[SOLVED] forming group and finding total for each group and select all group scoring above benchmar

[SOLVED] Selecting a group of data from a larger group

group matching and insert group of relevant data

insert group header -- above a group of rows -- based on consistent value within the group

Macro that will swap data if I drag a group of cells on top of another group of cells

Bookmarks

Bookmarks

Posting Permissions