nuts

  1. M

    Lists on two levels

    Im trying to have a the excel sheet pull in a list depending on what is selected in another list. The idea is to have a dropdown in D1 of two list depending on that value the information updates in D5 (roles).. Driving me nuts hope someone can understand what im trying to do and help. Fingers...
  2. C

    Excel Manufacturing inventory

    Recently got promoted at my job to start and manage inventory. We have a set up excel sheet but currently have to manually update inventory when a product leaves. To keep it short for example product one uses 5 screws, 2 nuts, and one hinge. How would I make it so that if I enter that we sold 5...
  3. E

    Return first value for each block in a range and count block size

    Hello Excel experts, I have a single yet very long column with several blocks. Each block has a header/category name and each block is separated from the next block with 1-3 new lines. My data is similar to: <tbody> Fruits Apple Banana Orange Grapes Pineapple Veggies Celery...
  4. R

    How to initialize base 1 array?

    Sorry, never mind. Found the answer in a different thread.
  5. J

    Fill in missing date with 2 conditions by copy paste

    Hi there, I'm trying to fill in missing dates on my "B" Column by searching empty cells within the column and comparing those empty cells with their parallel "C" Column cells for data. Upon meeting the 2 conditions, the formula would copy the date immediately above the empty "B" cell and paste...

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