**Question description:**

*This user has given permission to use the problem statement for this blog.*

I am trying to develop a program that will provide a 1 value if a column of numbers has one cell that is less than all the others, uniquely less, if it is equal to any other number it is a 0 value. I have come up with this forumula =IF(AND(D10

Solved by F. C. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
18/08/2017 - 02:16

I think that is all

Excelchat Expert
18/08/2017 - 02:16

Welcome, Thanks for choosing Got It Pro-Excel.

Excelchat Expert
18/08/2017 - 02:17

I understand that you need help with dynamic formulas.

User
18/08/2017 - 02:17

i'm very much a novice. I hope you can help

User
18/08/2017 - 02:17

yes this is my idea for a golf tournament.

Excelchat Expert
18/08/2017 - 02:18

Are you currently working on MS Excel or Google Sheets?

User
18/08/2017 - 02:18

ms excel

Excelchat Expert
18/08/2017 - 02:18

Can you copy and paste what you've done from excel into this sheet?

User
18/08/2017 - 02:21

it's not pasting formula

Excelchat Expert
18/08/2017 - 02:21

I believe you need to learn about locking cells.

User
18/08/2017 - 02:22

yes

Excelchat Expert
18/08/2017 - 02:22

So if you copy the formula down it will still cover what you needed

User
18/08/2017 - 02:22

ok now the formula is in e10

Excelchat Expert
18/08/2017 - 02:22

Got it.

User
18/08/2017 - 02:23

yes now in e11 it does not include d10 in the comparison

Excelchat Expert
18/08/2017 - 02:24

Wait, I don't understand the logic. If I can understand it completely we can simplify the process.

Excelchat Expert
18/08/2017 - 02:26

Your goal is to have E10 to check if D10 is lower than everything else, is that correct?

User
18/08/2017 - 02:28

if any people in column c have the lowest number they get a 1 value in column 3

Excelchat Expert
18/08/2017 - 02:29

Can you try the formula that I applied on column F?

User
18/08/2017 - 02:30

sure will this ingnore blanks?

Excelchat Expert
18/08/2017 - 02:30

I see one flaw. If it has a same value then it should be 0, right?

User
18/08/2017 - 02:31

yes

Excelchat Expert
18/08/2017 - 02:32

Yes, it should ignore blanks.

Excelchat Expert
18/08/2017 - 02:32

You can experiment

Excelchat Expert
18/08/2017 - 02:33

https://docs.google.com/spreadsheets/d/1Qqm4Y0mLyLsOPjKMQpzYi0EJt4xSea0tGHN-dGII3ZM/edit?usp=sharing

Excelchat Expert
18/08/2017 - 02:33

We are running out of time. Please click this link where we can continue chatting for a few minutes after the timer runs out.

Excelchat Expert
18/08/2017 - 02:33

Reply to the chat bubble located in the upper-right corner of that page.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*