a22

  1. M

    multiple fields on multiple sheets

    Not even sure if this is possible. I have a workbook with 31 sheet and want to st up an extra sheet that pulls all the data from A22 to h42 into a list to look like 1st A22 B22 C22 E22 F22 G22 H22 1st A23 B23 C23 E23 F23 G23 H23 and then so on that I can then drag to change the "1st" to...
  2. S

    Excel Formula - How Many Times a Value Appears

    Hi everyone, Have a request for a formula. In cell A10 I have a value of 1 Cell A15 I would have the formula that would do the following: I know the value 1 is in cell A20. I want to count how many times the value 1 repeated below cell A20 before the value changed. So in the example below...
  3. D

    Formula to get MAx value if the Columns comes with a string character before the value

    Hi and thanks in advance" Formula to get MAx value if the Columns comes with a string character before the value Please I do not want to use more columns, (Mandatory) I have in a Column in a Table with the following values: A22 A56 A89 A102 A1 A9 A21 I do know how to extract just the values...
  4. B

    Weekly data from a whole range

    Not sure how to explain this but here goes. I'm running a football score league and need to work out how to produce a league table for the individual week as an overall league. The overall league is sorted. But not sure how to get the information I need for the individual week as all data will...

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