freq

  1. B

    Combine SUM FREQUENCY IF formula with multiple IFS

    How can I ensure that pending orders are set to 0 once all items of the same order from the same company have been delivered? As you can see I have marked all items as delivered in column F, but 1 order remains open as pending? Formula used in pending orders is...
  2. A

    Parsing data for operation in Excel

    Hi, I am using a circuit simulation program called LTSPICE. It has an option to export chart data to a text file. Unfortunately, the format is not directly compatible with Excel. A snippet of the file output is shown below: Freq. V(out) 1.00000000000000e-002...
  3. T

    SEARCH function

    Hi, I would like to search of repeating words in excel across multiple worksheets and display the results as sheet numbers and frequency table:: Eg: Voltaire Sheet 111 Freq: 3 Sheet 200 Freq: 6 Sheet 303 Freq: 1 Can somebody advise the formula for that? Thanks TJ

Watch MrExcel Video

This Week's Hot Topics

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
Top