conduct

  1. J

    Countif function with a closed workbook

    I have a lot of data in a workbook that i want to archive. the issue is i need to determine how many times a specific number appears on that to conduct a trend analysis. Is there a way to conduct a search of how many times a value appears in a different closed workbook? I do know that Vlookup...
  2. J

    data search

    I have a very large spreadsheet consisting of 24 col. and 1000's of rows. I can conduct searches using the filter ( ie filter by dept, then by date); however, i want to take the data from what i filtered and extract it for data needed for audits. I know how to create and use countif, index...
  3. A

    Macro or Formula

    All I have a 2 sets of data in 2 different sheets. Data A is 639 rows and Data B is 24 rows. I want to take the each value in Data A and Multiply it by the 24 different values in Data B. Essentially ending up with 15336 (639*24) rows of new data. Should I conduct this via a macro or formula...

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