ad3

  1. D

    Formula nesting help

    Hello Everyone, i have the following formula that compares 2 sheets and returns Yes Or NO. The formula is auto filled entire column. So if my data spans from AD3 to AD 80, i will have 8 rows of "No". iS there a way to blank this out? =IF(ISNA(VLOOKUP(A11, 'SP'!$AD$3:$AD$88,1,FALSE)), "No"...
  2. F

    Counting results from IF function over an entire data set

    So I have a list of numeric values in Column AD Basically, I want to count any time there is a value Greater than or EQUAL zero, and the next value is LESS than zero. So if AD3 = 0 and AD4 =-2 that counts as 1. Then I'd like to add the amount of occurrences up. Formulas Im using...

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