ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Talk!
Reload this Page Excel Vlookup එකෙන් වැරදියට date එක lookup වෙනවා
Reply
 
Thread Tools
(#1)
Old
madhustf's Avatar
madhustf madhustf is offline
Senior Member
madhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to all
 
Posts: 5,610
Join Date: May 2008
Location: Kurunegala
Angry Excel Vlookup එකෙන් වැරදියට date එක lookup වෙනවා - 08-30-2019, 10:38 AM


මචන් මගේ data file එකක් තියෙනවා, එකේ තියෙන්නේ වාහන in / out දින වේලාවන්, මං මාසෙන් මාසෙට වෙන වෙනම තමයි excel sheet හදන් update කරන්නේ. දැන් ලොක්ක ඉල්ලනවා මේ අවුරුද්දෙම වාහන heldup උන වෙලාවල summary එකක්. මන් මාසෙන් මාසේ වෙන වෙනම තියෙන details එක ශීට් එකකට අරන් date එක lookup කළා, ප්‍රශ්නේ තමයි lookup එකෙන් එන වෙලාව original sheet එකේ තියෙන දිනයට වඩා දවසක් අඩුයි, ඒ වගේම වෙලාව AM , PM මාරු වෙලා එන්නේ බන්. මේකට විසදුමක් කියපල්ලකෝ.

මං use කරන date format එක තමයි පළලින් තියෙන්නේ,


1/10/2019 6:39:00 PM

Format Cell වල Custom වල ( m/d/yyyy h:mm ) මෙන්න මේ format එක. මේකෙන්ම තමයි මට ගන්න ඕන

දන්නා කෙනෙක් කියපන්කො බන්


මේ format එකෙන් දිනය වෙන excel එකකට copy කරලා ගත්තත් දිනය දවස වෙලාව වෙනස් වෙනවා බන්

Last edited by madhustf; 08-30-2019 at 10:42 AM.
Reply With Quote
(#2)
Old
ThisaraMalintha's Avatar
ThisaraMalintha ThisaraMalintha is offline
Senior Member
ThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to beholdThisaraMalintha is a splendid one to behold
 
Posts: 6,747
Join Date: Nov 2015
Location: ගෙදර
08-30-2019, 10:40 AM

bump
Reply With Quote
(#3)
Old
ryandok's Avatar
ryandok ryandok is offline
Senior Member
ryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud ofryandok has much to be proud of
 
Posts: 15,962
Join Date: Oct 2011
Location: වලපල්ලේ
08-30-2019, 10:40 AM

bump
Reply With Quote
(#4)
Old
ArunaTelshan's Avatar
ArunaTelshan ArunaTelshan is offline
Senior Member
ArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to behold
 
Posts: 2,792
Join Date: Nov 2013
Location: Biyagama
Send a message via ICQ to ArunaTelshan Send a message via Skype™ to ArunaTelshan
08-30-2019, 10:41 AM

original sheet eke sample ekak danna puluwanda?
Reply With Quote
(#5)
Old
madhustf's Avatar
madhustf madhustf is offline
Senior Member
madhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to all
 
Posts: 5,610
Join Date: May 2008
Location: Kurunegala
08-30-2019, 10:42 AM

Quote:
Originally Posted by ArunaTelshan View Post
original sheet eke sample ekak danna puluwanda?
Puluwan machan Email eka daapanko
Reply With Quote
(#6)
Old
asknrk's Avatar
asknrk asknrk is offline
Senior Member
asknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of lightasknrk is a glorious beacon of light
 
Posts: 2,766
Join Date: Feb 2007
Location: @Thusithaya
08-30-2019, 10:46 AM

excel eka dapan
Reply With Quote
(#7)
Old
madhustf's Avatar
madhustf madhustf is offline
Senior Member
madhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to all
 
Posts: 5,610
Join Date: May 2008
Location: Kurunegala
08-30-2019, 11:14 AM

Quote:
Originally Posted by asknrk View Post
excel eka dapan
Email eka PM karapanko
Reply With Quote
(#8)
Old
madhustf's Avatar
madhustf madhustf is offline
Senior Member
madhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to all
 
Posts: 5,610
Join Date: May 2008
Location: Kurunegala
08-30-2019, 11:14 AM

Quote:
Originally Posted by ArunaTelshan View Post
original sheet eke sample ekak danna puluwanda?
Mail kala bro.
Reply With Quote
(#9)
Old
rmpuom's Avatar
rmpuom rmpuom is offline
Senior Member
rmpuom is a jewel in the roughrmpuom is a jewel in the roughrmpuom is a jewel in the roughrmpuom is a jewel in the roughrmpuom is a jewel in the roughrmpuom is a jewel in the rough
 
Posts: 643
Join Date: Jun 2008
08-30-2019, 11:20 AM

Quote:
Originally Posted by madhustf View Post

මචන් මගේ data file එකක් තියෙනවා, එකේ තියෙන්නේ වාහන in / out දින වේලාවන්, මං මාසෙන් මාසෙට වෙන වෙනම තමයි excel sheet හදන් update කරන්නේ. දැන් ලොක්ක ඉල්ලනවා මේ අවුරුද්දෙම වාහන heldup උන වෙලාවල summary එකක්. මන් මාසෙන් මාසේ වෙන වෙනම තියෙන details එක ශීට් එකකට අරන් date එක lookup කළා, ප්‍රශ්නේ තමයි lookup එකෙන් එන වෙලාව original sheet එකේ තියෙන දිනයට වඩා දවසක් අඩුයි, ඒ වගේම වෙලාව AM , PM මාරු වෙලා එන්නේ බන්. මේකට විසදුමක් කියපල්ලකෝ.

මං use කරන date format එක තමයි පළලින් තියෙන්නේ,


1/10/2019 6:39:00 PM

Format Cell වල Custom වල ( m/d/yyyy h:mm ) මෙන්න මේ format එක. මේකෙන්ම තමයි මට ගන්න ඕන

දන්නා කෙනෙක් කියපන්කො බන්


මේ format එකෙන් දිනය වෙන excel එකකට copy කරලා ගත්තත් දිනය දවස වෙලාව වෙනස් වෙනවා බන්

umbage data sheet ekaka sample ekak ekka daapan.. awul gihipu ekath ekkama..
Reply With Quote
(#10)
Old
madhustf's Avatar
madhustf madhustf is offline
Senior Member
madhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to allmadhustf is a name known to all
 
Posts: 5,610
Join Date: May 2008
Location: Kurunegala
08-30-2019, 11:23 AM

Quote:
Originally Posted by rmpuom View Post
umbage data sheet ekaka sample ekak ekka daapan.. awul gihipu ekath ekkama..
Email eka PM karapanko
Reply With Quote
Reply

Bookmarks

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.02486 seconds with 11 queries