You could use this to make it dynamic: top 5 =TAKE(SORT($E$3:$F$26,2,-1),5) bottom 5 =TAKE(SORT($E$3:$F$26,2,-1),-5) that works on the latest version, not sure about the earlier ones
@AA7860
10 ай бұрын
ur Every video is awesome... keep growing 💗!
@krnrajan
Жыл бұрын
can you explain the criteria range and copy to list range. how it works. understood the formula. normally you mention the fields in the criteria range and condition under fields. Did not understand that part
@natozeleo7579
7 ай бұрын
Vera level 😂❤❤
@jianluo-kh9me
10 ай бұрын
vrer clever
@LearnExceltoexcel
10 ай бұрын
Glad you liked it :)
@MohdnawazQureshi-o7w
Ай бұрын
Can you send file for practice please
@debasischatterjee1328
Жыл бұрын
Pls make a video how to copy a data set single time but paste same data set multiple times in same sheet
@farooqtahir538
11 ай бұрын
Conditional formating can high light this thing very easily
@BigL-h7p
Жыл бұрын
Where is the description?
@real5731
Жыл бұрын
What song it is?
@AA7860
10 ай бұрын
background song?
@johnx2686
Жыл бұрын
Can we use in 2007???
@LearnExceltoexcel
Жыл бұрын
I think you can. I don't have access to 2007 version but advanced filter is available for some time now. Give it a try and let us know if you have 2007
@johnx2686
Жыл бұрын
@@LearnExceltoexcel Thanks bro
@debasischatterjee1328
Жыл бұрын
Pls make a video how to copy a data set single time but paste same data set multiple times in same sheet
@debasischatterjee1328
Жыл бұрын
Pls make a video how to copy a data set single time but paste same data set multiple times in same sheet
@aliheiba100
Жыл бұрын
Press Windows + v
@debasischatterjee1328
Жыл бұрын
@@aliheiba100 windows + v not working
@aliheiba100
Жыл бұрын
@@debasischatterjee1328 go to setting >system >clipboard and turn on clipboard after this Windows+V will be working
Пікірлер: 20