1. "Yes" "No" Feedback

I'm creating a spreadsheet to detail the fire door ratings based on the fire strategy and a physical survey. A straight forward exercise where the door is not fire rated (NFR), fire rated for 30/60 minutes (FD30/FD60) or fire rated for 30/60 minutes with a smoke seal (FD30S/FD60S). I want to...

Hi, I'm currently developing a dashboard involving 6 questions with Yes or No answers, and there are three lots of these questions per month of the year. The dashboard is in relation to 6 call quality questions in a call centre, so the three lots means three calls a month. 6 questions per...
3. Chart with Yes/No answers across 6 questions & 12 months of the year

Hi, I'm currently developing a dashboard involving 6 questions with Yes or No answers, and there are three lots of these questions per month of the year. How best can I present this information in a graph or chart? Every attempt so far has failed & I hope someone can help me find a solution...
4. Help with vlookup formula

Hi Folks I'm trying to use the following formula but it keeps defaulting to the value if false i.e. "" =IF(ISNA(VLOOKUP(J8,\$A\$2:\$F\$14,6,FALSE))="CISTWE Reject","Rejected","") Basically, in the column that its looking up, there are three values. I only want it to show 'rejected' if the result...
5. Set Focus to Combo Box Based on Yes/No Message

I have a form to populate data/dates for testing. There are two sections for testing: Test Plan Development (TPD) and System Testing (ST). Each section can have one of four statuses: Upcoming, Active, On Hold, or Complete. Each section also has a Begin Date and an End Date. The fields on...
6. Yes and No values

I want to make a formula that says if cell B2 has the word "yes" typed in it then cell d10 will equal "5" and if cell B2 has the word "no" typed in it then cell d10 will equal "1". I am a novice. Help!:confused:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back