a50

  1. B

    index with match function -two columns and one row

    Hi all, i am new to this forum. I have tried functions index and match to fetch a value but could not get success. my query is : I have to match two columns and one row to fetch a value, but i am getting error. after using below function. for example: A50, 3X1.5X10, Mys Max===>569...
  2. I

    Finding the next non-empty cell in a column

    This has probably been asked a million times before, but... given a specific cell, how do you search down to find the next non empty cell in that column. For example, if A10 has contents "dog", A50 has contents "cat" and A60 has contents "horse", how would you search from A10 to the next...
  3. H

    logical formula without using =IF

    I am trying to create a formula in excel 2007 without using =IF and I am struggling to come up with a solution. Cell A1 is the input cell and cell b1 is another input cell. I am creating a table from A5 to a50 starting with A5=1 The formula I am looking for in row B1:B50 is equal to cell A...

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