Return values only if they have changed

[EC3]

I have a COLUMN of prices in COLUMN C (C2:C11,C13:C22,...), the prices may be static or may change. I am wanting to return only the value of the original price (C2,C13...) into COLUMN A (A2,A13...), no problem there. But in the subsequent cells in COLUMN A (A3:A11,A14:A22...), I only want to return a value the next ROW down if it differs from the previous ROW and not have any gaps in ROWS in COLUMN A. I have attached a sheet showing the output that I am trying to achieve in COLUMN A. Any ideas?

example4.xlsx

Thanks

[xladept]

Try this:

Please Login or Register  to view this content.

[EC3]

That worked perfectly, unfortunately I have to share this sheet out and the folks that use are less than technically adept. Anything possible without VBA?

[xladept]

I'm inept with formulas. You could put it in a double-click event for your sheet:EC3.xlsm

[EC3]

Ha, I'm inept with code!

[xladept]

Thanks for the rep!

[EC3]

If you don't mind take a look at this, I got everything wired and working but for some reason the code is hanging up on some unrelated content in ROW C, specifically C21:C23, C39:C41, etc (all highlighted yellow). It's simply text but anytime the macro runs and data exists in those cell groups it takes at least 10x as long to run then spits out the '400' error. When I remove the data from those specific groups the macro runs in a snap and no errors. I have no clue why this is affecting the code.

I put a button on the sheet to run the macro also, it will propagate data to COLUMN H. example4a.xlsm

thanks

[xladept]

Looks like it was overflow:

Please Login or Register  to view this content.

[EC3]

Awesome, now I can work on something else.

So I don't pound my head against the desk for the rest of the night, what would be your suggestion to populate the dates from COLUMN R into COLUMN F tied to the corresponding price from COLUMN S that is put into COLUMN H. Just as with the prices the date would be populated if there is a price change in COLUMN H and blank if there is no change.

See attached and I highlighted the matches.

Last question, I promise.

example4b.xlsm

[xladept]

Probably:

Please Login or Register  to view this content.

[EC3]

Good to go, thanks for all the help. It works!

[xladept]

You're welcome!