AutoFilter group by text values?

[DashboardNovice]

In the attached file on sheet 3, I have an AutoFilter on the dates. In the AutoFilter, all dates are grouped into years. Each year can be expanded to show individual months. Then each month can be expanded to show individual days.

I am trying to accomplish the same thing on sheet1, except I am not using dates. I am using text values. The values have various "levels" which are separated by a period. The lowest level is the 4th level.

I am trying to find a way to make the AutoFilter rollup everything into level 1. Initially I would see 10000, 12000, 14000, 50000 as choices with a + sign next to each one.

Then if I expanded 12000, I should see 12000.01.

Then if I expanded 12000.01, I should see 12000.01.02.

Then if I expanded 12000.01.02, I should see 120000.01.02.0001, 120000.01.02.0002, 120000.01.02.0003 and 120000.01.02.0004.

Is there a way to make this happen with an AutoFilter?

 

[vletm]

DashboardNovice
Case 'sheet 3' - yes, as below...
Unselect all and after that select needed month


Case 'Sheet1':
> autofilter do not have [+]
... this filters, do You mean 'group'?
> You can 'filter' those only value rows, but
... You would take care that You use point or comma for separator - not mixed or both

 

[DashboardNovice]

DashboardNovice
Case 'sheet 3' - yes, as below...
Unselect all and after that select needed month
View attachment 58380

Case 'Sheet1':
> autofilter do not have [+]
... this filters, do You mean 'group'?
> You can 'filter' those only value rows, but
... You would take care that You use point or comma for separator - not mixed or both

I don't want to group the dates. I am trying to group the text values. I'm just using the dates with Autofilter as an example of what I want the groupings of text to look like.

 

[Nebu]

Hi:

You may have to rearrange your data in a certain way and draw a pivot to get what you are looking for, again without knowing the full scope of your work it is hard to give a customised solution.

Thanks

 

[vletm]

DashboardNovice
... to which file/case did You reply something?
Did You read next?
Case 'Sheet1':
You can 'filter' those only value rows, but
... You would take care that You use point or comma for separator - not mixed or both
Even with 'Sheet1' will be possible to do something, but
there should be same format for those datas (as I wrote).