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

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add an IF condition to a formula 9
how to show whether 3 cells within a row match 3 cells in another 3
Using IF to compare multiple cells to one another 1
copy cells in a row to another sheet 2
complex sort search and replace macro 2
IF formula 10
Find match between cells and copy data 7
Complicated If Function Question 2

Top