How do I create IF function that inserts cells when condition is m
 

In excell 2007 I trying to match up two columns of data. If certain cells in
the rows of either column dont equal each other I want to shift one side of
the row down until it matches the row in the other column. If anyone can
help I really appreciate it. Thanks

How do I create IF function that inserts cells when condition is m
 

A function can to one thing and one thing only: return a value (or if an
array function, return many values).
If cannot format, or restructure a worksheet. For that you will need to
enter the world of VBA
Start by looking a Chip's great notes on duplicates at:
http://www.cpearson.com/excel/Duplicates.aspx
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"jmsith" wrote in message
...
In excell 2007 I trying to match up two columns of data. If certain cells
in
the rows of either column dont equal each other I want to shift one side
of
the row down until it matches the row in the other column. If anyone can
help I really appreciate it. Thanks