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...
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...
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...
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 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.