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.