Sort/filter/index formula...

valmir

Active Member
Joined
Feb 10, 2021
Messages
267
Office Version
  1. 365
Platform
  1. Windows
Hello folks!
I have this table here:
Stats 2001 - Copy.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCO
128/31/46/415/418/421/428/413/519/527/520/624/64/77/710/715/718/721/74/811/82/98/919/93/107/1014/1023/1028/1024/119/1216/12
22PR¹3PR²145R1¹7R1²910611812R16⁸1314151617182021222324192526
3SAGMANSONMANBMQBLDPRMGOLFCCGOLBLBPROINTACAPHUPRIFCCPETBMQSAGSONBLDPRMFCCPHUBLBPROACAINTPRIPET
41-00-15-14-16-20-15-10-13-02-22-16-01-20-0Ď-02-11(4)-1(2)1-13-21-10-02-60-12-13-01-00-25-12-10-11-1
5
6s
7DᴄDᴄDᴄDᴄDDDDDDD
8cՁFᴄFᴄ
9DᴄDᴄDᴄDᴄDDD
10DᴄDᴄcDDMDD
11MᴄMᴄΙMsD
12cs
13FᴄՏFᴄFЧРFFРFFMF
14F
15ՁFՁFMFFFF
16GGGGGG
17MᴄcDDDD
18DᴄMᴄMMDDMMM
19ccMssss
20GᴄGᴄGᴄGᴄG
21MᴄMᴄMᴄss
22MᴄMᴄԶFᴄFᴄDMsM
23MᴄMᴄMᴄDᴄMMMsM
24FᴄFᴄΙՁMMFMs
25MMM
26MᴄMᴄMᴄMᴄMMDMMF
27DᴄDᴄΙDᴄDᴄDDDDD
28
29Ď
30
ASA (2)


And this is my intended result:
Stats 2001 - Copy.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZ
128/36/418/421/428/419/520/624/64/77/710/715/721/74/811/82/98/919/93/107/1014/1023/1028/1024/119/1216/12
22314579106118121314151617182021222324192526
3SAGSONBMQBLDPRMFCCBLBPROINTACAPHUPRIPETBMQSAGSONBLDPRMFCCPHUBLBPROACAINTPRIPET
41-05-16-20-15-13-02-16-01-20-0Ď-02-11-13-21-10-02-60-12-13-01-00-25-12-10-11-1
5
6s
7DDDDDDD
8Ձ
9DDD
10DDMDD
11MsD
12s
13ՏFЧРFFРFFMF
14F
15ՁFՁFMFFFF
16GGGGGG
17DDDD
18MMDDMMM
19Mssss
20G
21ss
22DMsM
23MMMsM
24ՁMMFMs
25MMM
26MMDMMF
27DDDDD
28
29Ď
30
ASA (3)


So, basically, in the next cell, for example, CP1, I would like to have that formula "sort/filter/index" or whichever formula works in this case to show just the sets of 3 columns based on 1 to 26 in the same order as they originally appear. The results can be with one formula or with 26 formulas, whatever works or is easier!
Thanks!
Thanks a lot!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top