Excel formula question: if a cell is less or equal than...

[IvanMD]

Hello,

I'm creating a music chart in excel (similar to the Billboard Hot 100 chart) and I need a formula to detect a peak position. This is what I have in mind:

If A1 is less or equal than C1, replace value of C1 with A1.

I've tried a few formulas but I get a redundancy error every time, I realize I'm not an expert so help is much appreciated.

Thanks,

 

[mole999]

not sure I understand why you want to replace the value, just seem to me you want to identify the max position reached in the chart

 

[VoG]

In Tools > Options > Calculation you would need to set Iterations to 1 otherwise you will get a Circular Reference warning. You might be better off using VBA. What are you actually trying to do?

 

[IvanMD]

Thanks for responding so quickly,

Yes, I want identify the higher position, for example a song was in position 5 last week, in this week chart the song moves to position 3, I'd like to replace this value (A3) on the peak position column (C3). I hope that makes sense.

if A3 < C3, replace C3 with A3.

If a formula does not work, a macro suggestion would be nice.

Thanks again,

 

[VoG]

You'll need to post a small ample indicating the desired result http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[mole999]

Across rows

=MIN(C1:G1)

Down columns

=MIN(A2:A6)

The lower the number the higher the position

 

[IvanMD]

OMG, that's it! =MIN(C1:G1)

Thank you so much! You guys rock.