Excel - IF Function Problem - Expert Solution

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
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc