number range

  1. E

    Help with number formatting on a cell with a number range (formula)

    Hi all, I have a formula which pulls in a number range (e.g. 1000 - 2000) based a lookup, as below: Salary: £15,000 Rating: 3 Recommended increase %: 1-3 (based on Lookup in table) Recommended amount: 150-450 (calculation as 1% and 3% of the salary field). Formula is...
  2. L

    Expanding a Range of Numbers using VBA

    Hello, I have a long list of numbers- see example 279.49 290.0 260-264.99 338-338.99 v27.9 v25.41 I am having difficulty creating a VBA script that can recognize where a dash is present, and then expand those numbers as follows to become 279.49 290.0 260 261 262 263 264 338 v27.9 v25.41 I...
  3. S

    Getting an average between a number range

    I have a column that stores hours that are worked on a job, they can range from between 0 hours and 15 hours, i want to be able to run anverage on this column but for it only to do the average for numbers greater than 0 and less than 10.................any ideas please?:confused:
  4. D

    Number Ranges/Series

    Hi All, I'm trying to get a set of data into a certain format, automatically: In Column A I have the following type of data - 3 4 5 6 9 11 14 15 16 17 33 37 1) I want to return the consecutive number series with less than 3 numbers like: 1,2 2) I also want to return the consecutive...

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