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

  • Thread starter Thread starter jmsith
  • Start date Start date
J

jmsith

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
 
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
 
Back
Top