Ask Experts Questions for FREE Help !
Ask
    tejutej's Avatar
    tejutej Posts: 4, Reputation: 1
    New Member
    		  
    #1

    Jul 3, 2009, 10:03 AM
    compare multiple cells
    Dear Supporting Team,

    I am reconciling the spreadsheet and need to find out the mismatch between column C(X-VISITDT) and column F (Y-VISITDT), where the subject ID(Column A & D) and CPE Event (column B&E) are same.

    Could you please provide me the formula, which gives the mismatch between visit dates, if Subject and CPEVENT are same. Please find the below table foe example.


    Subject CPEVENT X-VISITDT Subject CPEVENT Y-VISITDT
    283001001 W5D29 15 NOV 2007 283001001 W1D1 18 OCT 2007
    283001001 W1D1 18 OCT 2007 283001001 W5D29 15 NOV 2007
    283001002 W1D1 10 OCT 2007 283001002 W1D1 10 OCT 2007
    283001002 W5D29 07 NOV 2007 283001002 W5D29 07 NOV 2007
    283001002 W9D57 06 DEC 2007 283001002 W9D57 06 DEC 2007
    283001002 W17 31 JAN 2008 283001003 W1D1 11 APR 2008
    283001003 W1D1 11 APR 2008 283001004 W1D1 08 OCT 2008
    283001004 W1D1 08 OCT 2008 283001005 W1D1 14 JAN 2009
    283001005 W1D1 14 JAN 2009 283001005 W5D29 11 FEB 2009
    283001005 W5D29 11 FEB 2009 283001005 W9D57 11 MAR 2009
    283001005 EOT 06 MAY 2009 283002001 W1D1 03 SEP 2008



    Kind regards,
    Tejaswi
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 3, 2009, 03:22 PM
    Code:
    Subject  	CPEVENT	  X-VISITDT 	Subject   	CPEVENT	  Y-VISITDT
283001001	W5D29	15 NOV 2007	283001001	W1D1	18 OCT 2007
283001001	W1D1	18 OCT 2007	283001001	W5D29	15 NOV 2007
283001002	W1D1	10 OCT 2007	283001002	W1D1	10 OCT 2007
283001002	W5D29	07 NOV 2007	283001002	W5D29	07 NOV 2007
283001002	W9D57	06 DEC 2007	283001002	W9D57	06 DEC 2007
283001002	W17	31 JAN 2008	283001003	W1D1	11 APR 2008
283001003	W1D1	11 APR 2008	283001004	W1D1	08 OCT 2008
283001004	W1D1	08 OCT 2008	283001005	W1D1	14 JAN 2009
283001005	W1D1	14 JAN 2009	283001005	W5D29	11 FEB 2009
283001005	W5D29	11 FEB 2009	283001005	W9D57	11 MAR 2009
283001005	EOT	06 MAY 2009	283002001	W1D1	03 SEP 2008
    Put this formula in G2 and copy down. If the events are the same, you will get a MATCH/MISMATCH on the values in C & F, if the events are not the same, the cell will be blank.

    =IF(A2&B2=D2&E2,IF(C2=F2,"Match", "MisMatch"),"")
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Counting multiple cells in Excel [ 4 Answers ]

Hello, I wish to be able to count multiple cells which are not in a row or column adjacent to each other. If know you can use the IF formula to reference any cells you wish without them having to be in a range. How can I count cells specifying a criteria that has to be true which are not in a...

Counting blank cells with multiple criteria [ 1 Answers ]

Hello, I need some help with counting blank cells. Here's my data: Name Feb 07 Roger x Lisa Bob x Lisa Lisa x Lisa

Compare a [ 1 Answers ]

Compare and contrast thomas hobbes and john lockes theory of social contract of government?

Clicking differnet cells and it selecting all cells [ 2 Answers ]

Just wondered if anyone knew what I did to get ms excel to select all cells from A1 to what ever cell I clicked on. Thought it was sticky keys but it was turned off. Clicked left mouse button and it moved cells then when I clicked other cells it started using that as a new ref point and selecting...

View more questions Search