Hi Excelers!
I have exported a log list to Excel, containing a large amount of data
(about 10000 rows). The logs look like this:
30.05.2005 8:08:41 Log Entry Nr. 8610333 User CW_USER starting
SAP_SalOrd_G Create.
30.05.2005 8:08:41 I01: Calling method Z_XR_SALESORDER_C1
30.05.2005 8:08:42 Attribute Name: Z_XR_SALESORDER_C1 - Value: -
AppText:
30.05.2005 8:08:42 I03: returning to connector agent via RFC channel
30.05.2005 8:08:42 Regular Order pRegular Order p0000708204 a a
*0000708204* has been saved
30.05.2005 8:08:42 Log Entry Nr. 8610333 Ending SAP_SalOrd_G Create -
Runtime: 1.204 milliseconds.
There is more than a thousand logs like this! What I need to find is
possible double doc numbers (here in bold). Is there a way to make a
search for duplicates, but keeping in mind that I need only to compare
document numbers?
Thanks in advance! ;)
--
Ekser
------------------------------------------------------------------------
Ekser's Profile:
http://www.excelforum.com/member.php...o&userid=11400
View this thread:
http://www.excelforum.com/showthread...hreadid=375559