Question description:
This user has given permission to use the problem statement for this
blog.
I want to show in Cell E1 YES if Cells B6-B16,B21-31,B34-38,B41-B44,B47-B58 is YES and NO if Blank or No
Solved by G. B. in 38 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
23/07/2018 - 02:00
Hi
Excelchat Expert
23/07/2018 - 02:00
Hello!
Excelchat Expert
23/07/2018 - 02:00
Welcome to Got It Pro-Excel.
User
23/07/2018 - 02:00
Just have a quick question on a formula
User
23/07/2018 - 02:00
do you see the doc preview?
Excelchat Expert
23/07/2018 - 02:00
Yes, Got it
Excelchat Expert
23/07/2018 - 02:01
Yes, checking on it now
User
23/07/2018 - 02:01
awesome
User
23/07/2018 - 02:01
thanks
Excelchat Expert
23/07/2018 - 02:01
You're welcome
Excelchat Expert
23/07/2018 - 02:03
By the way, I will create the formula at your E1 as "yes" if all are yes and "no" if there's any "no" or blank value in any place of the ranges, right?
User
23/07/2018 - 02:03
yes correct
Excelchat Expert
23/07/2018 - 02:03
Thanks for the confirmation
User
23/07/2018 - 02:03
:)
Excelchat Expert
23/07/2018 - 02:03
A moment please :)
User
23/07/2018 - 02:03
sure
User
23/07/2018 - 02:07
you there? just checking as my page refreshed
Excelchat Expert
23/07/2018 - 02:07
Yes
User
23/07/2018 - 02:08
ahh good thing
Excelchat Expert
23/07/2018 - 02:08
Please give me more minutes to create the formula for you
Excelchat Expert
23/07/2018 - 02:08
Thank you :)
User
23/07/2018 - 02:08
sure no worries
Excelchat Expert
23/07/2018 - 02:16
Hi there,
User
23/07/2018 - 02:16
hi
Excelchat Expert
23/07/2018 - 02:17
A bit more time for testing
User
23/07/2018 - 02:17
will the session be cut off in 3 mins?
Excelchat Expert
23/07/2018 - 02:17
Please bear with me more time, we can extend 'till done
User
23/07/2018 - 02:17
oh perfect
User
23/07/2018 - 02:17
ah there
Excelchat Expert
23/07/2018 - 02:17
Thanks :)
User
23/07/2018 - 02:17
so the free exstension
User
23/07/2018 - 02:17
*saw
Excelchat Expert
23/07/2018 - 02:17
Yes, don't worry
User
23/07/2018 - 02:18
thank you
Excelchat Expert
23/07/2018 - 02:18
You're welcome
Excelchat Expert
23/07/2018 - 02:34
=if(or(countif(B6:B16,"No")>0,countif(B6:B16,"")>0,countif(B21:B31,"No")>0,countif(B21:B31,"")>0,countif(B34:B38,"No")>0,countif(B34:B38,"")>0,countif(B41:B44,"No")>0,countif(B41:B44,"")>0,countif(B47:B58,"No")>0,countif(B47:B58,"")>0),"No","Yes")
Excelchat Expert
23/07/2018 - 02:34
Finally, the formula above had been created
User
23/07/2018 - 02:34
perfect
Excelchat Expert
23/07/2018 - 02:34
Thank you
User
23/07/2018 - 02:34
thank you
Excelchat Expert
23/07/2018 - 02:34
By the way, you can put some data for testing
User
23/07/2018 - 02:34
this will be for all ranges I noted right?
Excelchat Expert
23/07/2018 - 02:35
Yes
Excelchat Expert
23/07/2018 - 02:35
The ranges mentioned above
User
23/07/2018 - 02:35
great
Excelchat Expert
23/07/2018 - 02:35
Thank you
User
23/07/2018 - 02:35
thank you so much for your help
User
23/07/2018 - 02:35
i think it was quite hard
User
23/07/2018 - 02:35
so really thank you
User
23/07/2018 - 02:35
:)
Excelchat Expert
23/07/2018 - 02:35
No, it's simple
Excelchat Expert
23/07/2018 - 02:36
just need the repitions of the formula use by the logical thinking of yes or no
User
23/07/2018 - 02:36
just tried it
User
23/07/2018 - 02:36
works like a charm
Excelchat Expert
23/07/2018 - 02:36
So, first, we've checked the existence of "no" and blank data on the ranges by using COUNTIF formula
Excelchat Expert
23/07/2018 - 02:37
Thank you :)
Excelchat Expert
23/07/2018 - 02:37
Any more concern regarding the formula created?
User
23/07/2018 - 02:37
No I'm good
User
23/07/2018 - 02:37
I will just review your formula
User
23/07/2018 - 02:37
for future use
User
23/07/2018 - 02:37
thank you!
Excelchat Expert
23/07/2018 - 02:38
Oh, I love to hear your feedback with us.
Excelchat Expert
23/07/2018 - 02:38
Thank you too :)
User
23/07/2018 - 02:38
:)
Excelchat Expert
23/07/2018 - 02:38
For any other Excel issues, please don't hesitate to come again. We will be glad to support you anytime.
User
23/07/2018 - 02:38
Will sure do
User
23/07/2018 - 02:38
bye for now
Excelchat Expert
23/07/2018 - 02:38
Thank you for coming at Got It Pro-Excel!
Excelchat Expert
23/07/2018 - 02:38
Have a nice day ahead
User
23/07/2018 - 02:38
you too
Excelchat Expert
23/07/2018 - 02:38
Cheers!!!
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.