If the row count is really 60lac than I strongly suggest you to please use MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac only.)
-- On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda < malungotoms...@gmail.com> wrote: > I need help breaking a numerical data range. I have an excel worksheet > with over 6000000 rows of data of which I am interested in just two columns > that contain numerical information. > > Here is a sample. > > RCV Serial Start RCV Serial End > 801120206779111 801120206779111 > 105100851967111 105100851967111 > 808920143800 808920143999 > 808920143700 808920143729 > 808920143500 808920143599 > 808920143400 808920143499 > 808920143390 808920143399 > 808920143370 808920143389 > 808920143350 808920143369 > 808920143310 808920143349 > 808920143300 808920143309 > 808920143200 808920143299 > 808920143000 808920143199 > 808920136800 808920136999 > 808920136550 808920136559 > 808920136490 808920136499 > 808920136480 808920136489 > 808920136470 808920136479 > 808920136460 808920136469 > Kindly assist, > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
