Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data
Hope you can help me.
I have data from two months. June & July. I have already reported June's and don't want to report the same data in July. How can I extract only the "new" information? Data1 Data2 a a b c d d e e f g h h The new spreadsheet (column, whatever) would yield: Data3 b c f g |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data
See site for ways to generate a unique list of data:
http://www.cpearson.com/excel/ListFunctions.aspx About half way down, section titles "Extracting Elements From One List Not On Another List" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "debinnyc" wrote: Hope you can help me. I have data from two months. June & July. I have already reported June's and don't want to report the same data in July. How can I extract only the "new" information? Data1 Data2 a a b c d d e e f g h h The new spreadsheet (column, whatever) would yield: Data3 b c f g |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data
One way
Sub nodupcol() r = 2 mc = 4 'col D For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row If Cells(i, mc) < Cells(i, mc + 1) Then Cells(r, mc + 2) = Cells(i, mc) r = r + 1 Cells(r, mc + 2) = Cells(i, mc + 1) r = r + 1 End If Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "debinnyc" wrote in message ... Hope you can help me. I have data from two months. June & July. I have already reported June's and don't want to report the same data in July. How can I extract only the "new" information? Data1 Data2 a a b c d d e e f g h h The new spreadsheet (column, whatever) would yield: Data3 b c f g |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Data | Excel Worksheet Functions | |||
extracting data from one sheet based on data in another - VLookup? | Excel Worksheet Functions | |||
extracting data | Excel Discussion (Misc queries) | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
extracting data | Excel Worksheet Functions |