output value

  1. R

    Output value/data only from multisheet workbook - exluding formulas / macros / Rand=() reformatting or changes etc

    Hello, I have a workbook with multiple worksheets - each containing the same format with data generated by Macro, Rand=() and Rand=() sorting colums by A to Z / Z to A. Effectively, the same data/content just randomly different on each work sheet. I have two questions I hope somebody can...
  2. A

    find and output relevent data

    Hi, I'm trying to find a medication displayed on sheet 1 within a list of medications (displayed on sheet 3) and output its relevant usage (relevant totals cell displayed on sheet 2) - for example if Allopurinol 100mg tabs is the medication displayed on sheet 1, then the quantity cell should...
    • amaanebrahim
    • Thread
    • if funcions combination ifnumber output value search and copy info tabs
    • Replies: 3
    • Forum: Excel Questions
  3. N

    Excel drop down selections x2 with outcome in third box.

    Hi, I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...
    • NZ990
    • Thread
    • drop down box output value selection values table variable data
    • Replies: 2
    • Forum: Excel Questions
  4. B

    VBA - Compare Two Lists on seperate sheets

    Hello everyone! :) Thank you for all the great solutions I could copy/paste from here to use for my own projects. Unfortunately I do now have a rather simple task, which I can figure out to work. I've tried several attempts, but did not get a satisfying result. The situation is the following: I...

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