corn

  1. D

    Index/Match With Multiple Criteria Giving #NA

    <tbody> <tbody> =LEFT(C1,4) 2012/2013 DEC Montana =INDEX('Sep Corn Stocks'!$A$2:$T$53,MATCH(1,'Sep Corn Stocks'!$F$2:$F$53=Corn!B3)*('Sep Corn Stocks'!$B$2:$B$53=VALUE(TRIM(CLEAN($B$1)))),20) North Dakota =INDEX('Sep Corn Stocks'!$A$2:$T$53,MATCH(1,'Sep Corn...
  2. D

    Index Match with wildcards

    Hi All, I'm having a problem getting index/match to work with wild cards, and I haven't come across a solution to my particular issue. Here's a simplified version: <tbody> A B 1 Apples Fruit 2 Pears Fruit 3 Bananas Fruit 4 Grapes Fruit 5 Corn Veg 6 Beets Veg...
  3. C

    Find a value in a table

    I've done this before, but it is amazing how you can draw a blank and also not find the file where the formula was used years earlier...I have a sheet where I would like to update a bin list in column J and what is in the bin in column K. Columns A, C and E would be the table where I would...
  4. M

    Sort and separate data based on certain criteria

    Hello i'm trying to group the CODE values and get a total of the count based on certain instances. i cant use a pivot table when doing this so VBA code is preferred Then i would like to do the same but for "Coconut" only in the FRUIT2 Column using certain instances Then i would like to know...
  5. N

    Unique combinations where order does not matter but duplicates do

    I am trying to find unique crop rotations over 5 years. A scaled down version of what I have isA B C DJ North Corn Hay BarleyM North Hay Barley CornN North Barley Corn CornJ South Corn Corn CornM South Barley...

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