Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I compare the stored data in micro
Hi,
I got four columns of stored list of addresses and dates (two for address and two for dates) which I want to match against each other. The formats of those columns are in example below Column A 10 V Street Colum B 12/16/2009 Column C 12 DEC:PTD:DEC 2009 Column D 10 V Street I want column A and D matched as is and the column Bs first two digits (12) and last four digits (2009) should be matched with column Cs first two digits (12) and the last four digits (2009). If they are not the same it should appear differently (may be red text). Any help on this will greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum data with criteria stored in row and column | Excel Worksheet Functions | |||
Data return from SQL Stored procedure... | Excel Discussion (Misc queries) | |||
Explain how data is stored in excel in your own | Excel Discussion (Misc queries) | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Extract data from Stored procedure | Excel Discussion (Misc queries) |