Question description:
This user has given permission to use the problem statement for this
blog.
If the values of two cells is the same then the result should be 1
Solved by K. L. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/04/2018 - 10:35
hi there!
User
06/04/2018 - 10:35
Hello
Excelchat Expert
06/04/2018 - 10:36
you need a formula that displays "1" if two cells have the same value?
User
06/04/2018 - 10:36
yes
Excelchat Expert
06/04/2018 - 10:36
ok perfect I can totally help with that
User
06/04/2018 - 10:36
the value can be numbers or names too
Excelchat Expert
06/04/2018 - 10:36
that was my next question :)
Excelchat Expert
06/04/2018 - 10:37
ok so check out this example in the Google Sheet window
Excelchat Expert
06/04/2018 - 10:37
actually one more thing
Excelchat Expert
06/04/2018 - 10:37
what would you want displayed if the cells are NOT the same?
User
06/04/2018 - 10:38
Zero
User
06/04/2018 - 10:38
How did you do that?
User
06/04/2018 - 10:38
This is exactly what im looking for
Excelchat Expert
06/04/2018 - 10:38
I used an IF statement - so IF the cells are the same, then put 1, if not, then put 0
Excelchat Expert
06/04/2018 - 10:38
oh amazing!
Excelchat Expert
06/04/2018 - 10:38
you can use that formula in your workbook
Excelchat Expert
06/04/2018 - 10:39
just might have to change the reference cells
Excelchat Expert
06/04/2018 - 10:39
you know what I mean?
User
06/04/2018 - 10:39
im trying the same but its not working...Im playing around with IF formula from 3 hrs
Excelchat Expert
06/04/2018 - 10:39
i'm happy to code it in your workbook directly if you'd like
User
06/04/2018 - 10:40
I want to learn it as i have quiet a few sheets where this can help...can you show me the formula on this screen--->
Excelchat Expert
06/04/2018 - 10:41
can you see the formula in the google sheet over there? ---------->
Excelchat Expert
06/04/2018 - 10:41
in the green cell
Excelchat Expert
06/04/2018 - 10:42
yeah you got it
User
06/04/2018 - 10:42
Gimme a min...let me try it on my sheet
Excelchat Expert
06/04/2018 - 10:42
take your time
User
06/04/2018 - 10:44
It worked, Damn...Now i feel like a fool, i'm not sure what i was doing wrong, I'm really surprised.
User
06/04/2018 - 10:44
Thank you for your help
Excelchat Expert
06/04/2018 - 10:44
oh glad to hear! naaa these functions can be tricky for sure
User
06/04/2018 - 10:44
Is this a free chat
Excelchat Expert
06/04/2018 - 10:44
anytime feel free to ping us back if you need more assistance
Excelchat Expert
06/04/2018 - 10:45
there is a cost to the service but I am not 100% certain if you've signed up, i believe the first one is free? but not sure if you've registered
User
06/04/2018 - 10:45
Yes this is a free trial
Excelchat Expert
06/04/2018 - 10:45
gotcha
User
06/04/2018 - 10:46
whats the cost?
User
06/04/2018 - 10:46
$9.99?
User
06/04/2018 - 10:46
Per month?
Excelchat Expert
06/04/2018 - 10:46
if you go to the Got It site the details are there for sure if you're looking to register
User
06/04/2018 - 10:46
Where are you based? US
Excelchat Expert
06/04/2018 - 10:46
I wish I could tell you!
Excelchat Expert
06/04/2018 - 10:47
no names, locations, etc.
Excelchat Expert
06/04/2018 - 10:47
typical for help desk :)
User
06/04/2018 - 10:47
Ok...No issues...Thank you once again.
Excelchat Expert
06/04/2018 - 10:47
anytime friend all the best
User
06/04/2018 - 10:47
You too...Have a great day ahead
Excelchat Expert
06/04/2018 - 10:47
you also
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.