hi all..
i have appended file when new refreshing data the column and rows is change
how to make formula in PQ so that in column C "KPKNL" automatic keep alphabetic sort.
here my attachment picture
any one help me, greatly appreciated
.susanto
hi all..
i have appended file when new refreshing data the column and rows is change
how to make formula in PQ so that in column C "KPKNL" automatic keep alphabetic sort.
here my attachment picture
any one help me, greatly appreciated
.susanto
Is that end result on the picture?
the A-Z sort of this column works for you?
anyway you can extract first letter after first space and sort it
maybe if you attach excel file with your example it will help more
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316280#p316280
https://eileenslounge.com/viewtopic.php?p=315915#p315915
https://eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315744#p315744
https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315680#p315680
https://eileenslounge.com/viewtopic.php?p=315743#p315743
https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
https://eileenslounge.com/viewtopic.php?p=314950#p314950
https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
Last edited by DocAElstein; 04-16-2024 at 01:13 PM.
sandy
I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
here attached file, my target in cell C2
yes, A-Z sort that's i want
Last edited by muhammad susanto; 01-18-2022 at 02:20 PM.
that's all what I can do with your example
sort alphabetic.xlsx
sandy
I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
hi sandy666, thank you so much!!!
you are welcomeOriginally Posted by muhammad susanto
sandy
I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
hi Sandy666,
i found new problem and to modified like this with the same example before it
how to way or make formula to sort "name of city (in col C)" with sort list like this below, start from first sort order
1. KPKNL Padang
2. KPKNL Bukittinggi
3. KPKNL Pekanbaru
4. KPKNL Batam
5. KPKNL Dumai
would you help me out?
Last edited by muhammad susanto; 01-19-2022 at 09:24 AM.
hope it will help
sort alphabetic.xlsx
sandy
I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
hi sandy666, thanks again..
no problem, hth
sandy
I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
Posting Permissions
Reply With Quote
Bookmarks