min max concatenate

  1. A

    List projects based on keyword in column headers, then return them and mark maximum minimum spent

    Hi there, This is my first post since I am lost. Thanks for setting up this site! I received this huge sheet with a list of projects in column A. Each Project uses Deliverables (Columns B to Z+). The goals are: - Find total $-amount spent on deliverables for each KEYWORD found in row 2. -...
    • Amb3rs
    • Thread
    • concatenate min max min max concatenate project name textjoin
    • Replies: 0
    • Forum: Excel Questions
  2. E

    Make min/max formulas read concatenated data?

    Hi everyone, How would I go about using min/max formulas with concatenated data? For example... I have two or more cells that are concatenated and I want to use min/max on formulas on them. There will be text as well as numerical values. "Owners" which would be text and and a "height" which...
    • Elihue
    • Thread
    • concaatenate concatenated data min max concatenate min/max
    • Replies: 4
    • Forum: Excel Questions
  3. K

    Finding Max and its corresponding min

    <tbody> Overs 3 4 1 5 6 Runs 10 100 7 123 56 Wickets 2 4 2 4 4 </tbody> I want get the max value from "Wickets" and corresponding min value from "Runs". For ex, in this table Max value in "Wickets" is 4. I want to find the corresponding min value for 4. So i want my result as 4 and...

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