A
AMK4
I couldn't think of a better header, sorry. Anyway, I have data tha
comes in like this (via a plain text file)
Code
-------------------
1-Jan-06 Exploit.W32.MS05-039
1-Jan-06 HTML.Phishing.Auction-28
1-Jan-06 HTML.Phishing.Bank-1
1-Jan-06 HTML.Phishing.Bank-1
1-Jan-06 HTML.Phishing.Bank-1
1-Jan-06 HTML.Phishing.Bank-209
1-Jan-06 HTML.Phishing.Bank-28
1-Jan-06 HTML.Phishing.Pay-6
1-Jan-06 W32/Bagle.ai@MM
1-Jan-06 Worm.Sober.U-3
1-Jan-06 Worm.Sober.U-3
1-Jan-06 Worm.Sober.U-3
1-Jan-06 Worm.Sober.U-3
2-Jan-06 HTML.Phishing.Bank-1
2-Jan-06 HTML.Phishing.Bank-1
2-Jan-06 HTML.Phishing.Bank-1
2-Jan-06 HTML.Phishing.Bank-206
2-Jan-06 HTML.Phishing.Pay-25
2-Jan-06 HTML.Phishing.Pay-37
2-Jan-06 HTML.Phishing.Pay-43
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 W32/Bagle.ai@MM
2-Jan-06 Worm.Sober.U-3
2-Jan-06 Worm.Sober.U-3
2-Jan-06 Worm.Sober.U-3
2-Jan-06 Worm.Sober.U-3
3-Jan-06 HTML.Phishing.Auction-28
3-Jan-06 HTML.Phishing.Auction-28
3-Jan-06 HTML.Phishing.Auction-28
3-Jan-06 HTML.Phishing.Bank-1
3-Jan-06 HTML.Phishing.Bank-1
3-Jan-06 HTML.Phishing.Bank-28
3-Jan-06 HTML.Phishing.Pay-34
3-Jan-06 HTML.Phishing.Pay-37
3-Jan-06 W32/Bagle.ai@MM
3-Jan-06 W32/Bagle.ai@MM
3-Jan-06 W32/Bagle.ai@MM
3-Jan-06 W32/Netsky.p@MM
3-Jan-06 W32/Netsky.p@MM
3-Jan-06 W32/Netsky.p@MM
3-Jan-06 Worm.Sober.U-3
3-Jan-06 Worm.Sober.U-3
3-Jan-06 Worm.Sober.U-
-------------------
And what I'd like to accomplish is a sheet that looks like the attache
example, which reflects the month of February (as opposed to the abov
data which is from January.) Basically a listing of how many o
whatever virus came in on any particular day.
Any suggestions
+-------------------------------------------------------------------
|Filename: excel-virus.gif
|Download: http://www.excelforum.com/attachment.php?postid=4480
+-------------------------------------------------------------------
comes in like this (via a plain text file)
Code
-------------------
1-Jan-06 Exploit.W32.MS05-039
1-Jan-06 HTML.Phishing.Auction-28
1-Jan-06 HTML.Phishing.Bank-1
1-Jan-06 HTML.Phishing.Bank-1
1-Jan-06 HTML.Phishing.Bank-1
1-Jan-06 HTML.Phishing.Bank-209
1-Jan-06 HTML.Phishing.Bank-28
1-Jan-06 HTML.Phishing.Pay-6
1-Jan-06 W32/Bagle.ai@MM
1-Jan-06 Worm.Sober.U-3
1-Jan-06 Worm.Sober.U-3
1-Jan-06 Worm.Sober.U-3
1-Jan-06 Worm.Sober.U-3
2-Jan-06 HTML.Phishing.Bank-1
2-Jan-06 HTML.Phishing.Bank-1
2-Jan-06 HTML.Phishing.Bank-1
2-Jan-06 HTML.Phishing.Bank-206
2-Jan-06 HTML.Phishing.Pay-25
2-Jan-06 HTML.Phishing.Pay-37
2-Jan-06 HTML.Phishing.Pay-43
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 HTML.Phishing.Pay-6
2-Jan-06 W32/Bagle.ai@MM
2-Jan-06 Worm.Sober.U-3
2-Jan-06 Worm.Sober.U-3
2-Jan-06 Worm.Sober.U-3
2-Jan-06 Worm.Sober.U-3
3-Jan-06 HTML.Phishing.Auction-28
3-Jan-06 HTML.Phishing.Auction-28
3-Jan-06 HTML.Phishing.Auction-28
3-Jan-06 HTML.Phishing.Bank-1
3-Jan-06 HTML.Phishing.Bank-1
3-Jan-06 HTML.Phishing.Bank-28
3-Jan-06 HTML.Phishing.Pay-34
3-Jan-06 HTML.Phishing.Pay-37
3-Jan-06 W32/Bagle.ai@MM
3-Jan-06 W32/Bagle.ai@MM
3-Jan-06 W32/Bagle.ai@MM
3-Jan-06 W32/Netsky.p@MM
3-Jan-06 W32/Netsky.p@MM
3-Jan-06 W32/Netsky.p@MM
3-Jan-06 Worm.Sober.U-3
3-Jan-06 Worm.Sober.U-3
3-Jan-06 Worm.Sober.U-
-------------------
And what I'd like to accomplish is a sheet that looks like the attache
example, which reflects the month of February (as opposed to the abov
data which is from January.) Basically a listing of how many o
whatever virus came in on any particular day.
Any suggestions
+-------------------------------------------------------------------
|Filename: excel-virus.gif
|Download: http://www.excelforum.com/attachment.php?postid=4480
+-------------------------------------------------------------------