observation

  1. B

    Excel form to submit and collect the data then reuse the form

    Hi guys, I was wondering if you could help - I have an observation form that has input boxes for Y/N in them that once completed I would love to be able to hit submit and the data is moved to a master file then clears the data from the form to use again for the next submission. Therefore over...
  2. F

    Count the number of values having zero and below zero according the drop list text

    Sir, I have table containing Observation and Score. i made a drop down list according the text of observation column. I like to count number of scores comes zero and below zero according the text (observation) <tbody> Observation Score Health_Safety-Electrical<strike></strike> 2...
  3. B

    Contains Subarray

    I'm trying to figure out a formula to determine whether an occurrence contains a value with the data in this sort of format. In the example below, I'd like the formula to output TRUE if the occurence contains the number 2, and false if it doesn't. I've been trying SUMPRODUCT and INDEX with no...
  4. K

    Nest two IF statements

    I have the following IF statements in a spreadsheet for tracking observations. Cell C11 is the date of the observation. The nested IF statement is intended to go in a "next observation due" column. =IF(ISNUMBER(SEARCH("walkthrough",D11)),WORKDAY(C11,10),WORKDAY(C11,40))...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top