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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top