ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Help
Reload this Page Excel help ( Advanced Filtering )
Reply
 
Thread Tools
(#1)
Old
lk-maare's Avatar
lk-maare lk-maare is offline
Senior Member
lk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nice
 
Posts: 2,390
Join Date: Nov 2014
Location: මහනුවර
Excel help ( Advanced Filtering ) - 07-19-2018, 04:20 PM

USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT


me wage series ekaka anthima wachane filter karaganne kohomada ?

series eke search wenna oni last word eke starting eka TJW eeta passe any series of characters.
dan methana widihata mata anthima eka ayin wenna oni mokada eke enne knit kiyala hinda.
anthima wachane kohomada filter karaganne hithanna bari.


ekama series ekak nan TJW?? dammanan enawa. methana awula smahara welawata TJW2222 wage awoth result eken ayin wenwa.


mata oni mokak hari awulak na anthiama wachane witharak TJW thiyenawanan filter wenna.
Reply With Quote
(#2)
Old
wolvoring wolvoring is offline
Senior Member
wolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the rough
 
Posts: 762
Join Date: Apr 2017
Location: www.rumansala.com & 127.0.0.1
Send a message via AIM to wolvoring
07-19-2018, 04:28 PM

Simpal ban uba pavichi karana excel version eka mokakda
Reply With Quote
(#3)
Old
bonji's Avatar
bonji bonji is offline
Senior Member
bonji will become famous soon enoughbonji will become famous soon enough
 
Posts: 3,126
Join Date: Jan 2008
Location: E=382959.743, N=2844423.290
Send a message via MSN to bonji Send a message via Yahoo to bonji Send a message via Skype™ to bonji
07-19-2018, 04:28 PM

Quote:
Originally Posted by lk-maare View Post
USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT


me wage series ekaka anthima wachane filter karaganne kohomada ?

series eke search wenna oni last word eke starting eka TJW eeta passe any series of characters.
dan methana widihata mata anthima eka ayin wenna oni mokada eke enne knit kiyala hinda.
anthima wachane kohomada filter karaganne hithanna bar


ekama series ekak nan TJW?? dammanan enawa. methana awula smahara welawata TJW2222 wage awoth result eken ayin wenwa.


mata oni mokak hari awulak na anthiama wachane witharak TJW thiyenawanan filter wenna.


anthima 4 letters walatada filter karanna one
Reply With Quote
(#4)
Old
csaranga46's Avatar
csaranga46 csaranga46 is offline
Senior Member
csaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to allcsaranga46 is a name known to all
 
Posts: 8,672
Join Date: May 2010
Location: SL
07-19-2018, 04:29 PM

bump
Reply With Quote
(#5)
Old
bonji's Avatar
bonji bonji is offline
Senior Member
bonji will become famous soon enoughbonji will become famous soon enough
 
Posts: 3,126
Join Date: Jan 2008
Location: E=382959.743, N=2844423.290
Send a message via MSN to bonji Send a message via Yahoo to bonji Send a message via Skype™ to bonji
07-19-2018, 04:29 PM

Quote:
Originally Posted by lk-maare View Post
USD- KNIT M TJW18
USD-HOODIE M TJW
USD-HOODIE M TJW
USD- KNIT M TJW18
USD- TJW18 KNIT


me wage series ekaka anthima wachane filter karaganne kohomada ?

series eke search wenna oni last word eke starting eka TJW eeta passe any series of characters.
dan methana widihata mata anthima eka ayin wenna oni mokada eke enne knit kiyala hinda.
anthima wachane kohomada filter karaganne hithanna bari.


ekama series ekak nan TJW?? dammanan enawa. methana awula smahara welawata TJW2222 wage awoth result eken ayin wenwa.


mata oni mokak hari awulak na anthiama wachane witharak TJW thiyenawanan filter wenna.

Thawa column 1 add karala data extract karaganna then ubata filter karaganna puluwan


Reply With Quote
(#6)
Old
mtmadushanka's Avatar
mtmadushanka mtmadushanka is offline
Senior Member
mtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of lightmtmadushanka is a glorious beacon of light
 
Posts: 3,389
Join Date: Apr 2018
Location: Hogwarts 🏰
07-19-2018, 04:31 PM

Reply With Quote
(#7)
Old
soldierthilina's Avatar
soldierthilina soldierthilina is offline
Senior Member
soldierthilina has a spectacular aura aboutsoldierthilina has a spectacular aura about
 
Posts: 274
Join Date: Feb 2011
laugh ;) - 07-19-2018, 04:35 PM

Step 01 :Column eka select karala..CTR+F..Replace TAB..Find what:Space ekak thiyapan..Replace with:Monawath karana epa..Replace All..

Step 02 :Column eka select karala..Data TAB..Text to Column..Fixed with..Next..Ona thanakata thiyala split karaganin
Reply With Quote
(#8)
Old
lk-maare's Avatar
lk-maare lk-maare is offline
Senior Member
lk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nicelk-maare is just really nice
 
Posts: 2,390
Join Date: Nov 2014
Location: මහනුවර
07-20-2018, 10:26 AM

Quote:
Originally Posted by wolvoring View Post
Simpal ban uba pavichi karana excel version eka mokakda

2016
eeye hadissiyata anthima wachane trim karala manually filter karan giya




Quote:
Originally Posted by bonji View Post
anthima 4 letters walatada filter karanna one

lettersma newei machan.meke akuru gaana hariyatama kiyanna ba. sequence ekak thamai bn ganna wenne.
mam ara filter eke contains gihin TJW* diila baluwa hari giye na. characters gaana hariyatama hari nan TJW?? dipuhama hari. meka ehemama na bn ekai awula giye.


Quote:
Originally Posted by csaranga46 View Post
bump
Quote:
Originally Posted by bonji View Post
Thawa column 1 add karala data extract karaganna then ubata filter karaganna puluwan



meka balanna oni. mam eeye trim kara bn anthima wachane allala.


Quote:
Originally Posted by mtmadushanka View Post
Quote:
Originally Posted by soldierthilina View Post
Step 01 :Column eka select karala..CTR+F..Replace TAB..Find what:Space ekak thiyapan..Replace with:Monawath karana epa..Replace All..

Step 02 :Column eka select karala..Data TAB..Text to Column..Fixed with..Next..Ona thanakata thiyala split karaganin

=TRIM(RIGHT(SUBSTITUTE(E2," ",REPT(" ",100)),100))
meken karana eka ne bn oye
anthimata oke thamai kare bn
Reply With Quote
(#9)
Old
wolvoring wolvoring is offline
Senior Member
wolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the roughwolvoring is a jewel in the rough
 
Posts: 762
Join Date: Apr 2017
Location: www.rumansala.com & 127.0.0.1
Send a message via AIM to wolvoring
07-20-2018, 12:15 PM

Oya reddawal oni naha ban ehenm filter ekata gihin uba anthima akuru 4ra type karapan etha kota lassanata filter wei
Reply With Quote
(#10)
Old
jsandun's Avatar
jsandun jsandun is offline
Senior Member
jsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to beholdjsandun is a splendid one to behold
 
Posts: 4,807
Join Date: May 2010
Location: ශ්‍රී ලංකාව
07-20-2018, 12:47 PM

bump
Reply With Quote
Reply

Bookmarks

Tags
excel, filter

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright © 2006 - 2011 ElaKiri™ Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.02382 seconds with 11 queries