dryer

  1. L

    dynamic assigning cell to another cell

    Hi I have table like below. Cell B2 = B9. I want store location to be shown in B2 after I filter the main table. So if I filter South, then I want B2= South, if I filter North, then I want B2= North Right now, it does not work, it always shows "East". Any idea how I can solve this? Thank you so...
  2. L

    structural table columns advantage

    Hi I have a table like the one below. I inserted a table (Insert-->Table). Now I understand (thanks for you help). This table have these ranges Table1[name] Table1[store] Table1[item] Table1[price] What is the benefit of using these ranges rather than I create my own ranges for example I...
  3. L

    subtotal() function doing Data-->subtotal job

    Hi I have a table like the one below. I sorted "Store" column. I want to find the subtotal of east store or subtotal of north store or north store etc. using subtotal() function. I know after sorting, I can go to Data tab-->subtotal, that is an option another option maybe I can use SumIf()...
  4. M

    What function to find the most common values based off certain criteria?

    Good Afternoon All, This might seem easy to some, I just cant figure it out and I am not sure what keywords to enter if this was answered already. I am the manager of an appliance retail store and I have a lot of new employees who are making simple errors. I was hoping there was a function I...
    • miken54
    • Thread
    • common common values within list dryer function washer
    • Replies: 7
    • Forum: Excel Questions

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