band

  1. M

    Lookup across multiple columns

    Hello I'm new to the forum and look forward to your insights I have the weight band in column D and want to look up the prices in columns E to J how do I return the right price for each row? See below <tbody> Weight (lbs) Weight Band A B C D E F 167 A 156.53 126.79 107.98 90.78 78.94...
  2. M

    Sumif with index and match if two criteria are met

    Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...
  3. C

    Moving Match formula

    I've tried really hard to find an answer to this problem but cannot find it. Basically I have an table which is populated as below: <colgroup><col><col span="5"></colgroup><tbody> Band 1 Band 2 Band 3 Band 4 Band 5 Product Group A 10 25 40 55 60 Product Group B 15 20 25 35 40 Product...
  4. M

    Weighted salary by salary band

    Hi I'd like to calculated the average salary for employees based on salary bands. The table below shows salary bands and the number of employees in each band. What's the best way of working out the average salary by salary band? I thought about taking the mid-point of the range then...
  5. D

    Look up - while loop

    Hi all, I have a list of of employees with a unique number assigned to each one. Then i have a separate list with the entire list of employees and their 1Up manager as well as their 2 Up manager. I need a script that will look up that employee on the list, finds their 1 UP manager, checks...
  6. T

    IFS Greater Than & Less Than

    Hi, I've been working on a formula for this for a while but haven't been able to crack it, any help appreciated. The data I have is peoples ages, and I want a formula to be able to take the age and automatically assign it to the correct age band. So I need to combine the following into one...
  7. P

    Progressive Pricing Formula

    Hope you can help!! I have a progressive pricing formula I need help with, been tearing my hair out Each band gets individual earnings in steps apart from <10 that gets nothing. In the below example customer sells 35 baskets, so will reach the 4th band. Band 1 - Zero Band 2 - 10 * £1.15 =...
  8. T

    Band / Category assigning

    Hi there, I am wondering what the easiest way I can band values which are the closest to the actual values. Take the below example: Here are my bands: <colgroup><col><col></colgroup><tbody> Chargeband Exc VAT (pence per min) 1 4.5 2 4.5 3 4.5 4 13.5 5 13.5 6 13.5 7 13.5 8 36...
  9. D

    Calculate variance outside band of two rates of pay

    Hi Slightly weird question and I'm hoping Excel is not going to let me down. I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't - =IF(AND(R3>=T3,R3<=U3),"No","Yes") If I get back "NO" I then...
  10. S

    Dlookup and Comboboxes

    Hi Board, I have a form that recalls a product price from a table (tblFurniture), using a dlookup. As follows: UnitPrice: DLookUp("[1stBand]","tblFurniture","[ProductNameText]='" & [Element] & "'") This works fine, but I want to return the price based on the selected band (1st,2nd,3rd etc)...
  11. D

    Comma separated Rows

    <tbody> Question Col A Col B Col C Col D 1 Angry Birds , Gaming Android, IOS L1,L2,L3 2 Nirvana,Rock,Band Y,Z,A M1,M2,M3 Please find the question on the top and the expected result at the bottom There is no limit on the number of comma separated...
  12. A

    Different Banding for Different complexity

    Hi forum, I am working on a employee performance report. Usually the employee task complexity divided to three major categories like Easy, Average and Hard. For every complexity we give banding based on accuracy limits as per below table. Now I need to map this to my main fact table column...
  13. A

    Slightly harder/complicated Excel formula

    Hi there; I have a small problem, I need to condense this table of formulas into one calculation and this is beyond my meagre skills, I build the table to calculate some discount bands, basically applying a rate to the cell highlighted (red) taking the figure apart portioning it into bands and...
  14. V

    age band formula require..

    Based on below data, I need formula to get age band.. Values are in Col E. Output require in Col F. Col E Age band require.. (10-13,14-16,17-20)...
  15. J

    Band based on age

    I have a list of date of birth in col A and in Col B I need to allocate to them a band based on the table below (bands in bold); <tbody> 01/09/1997 31/08/1998 N 01/09/1998 31/08/1999 M 01/09/1999 31/08/2000 L 01/09/2000 31/08/2001 K 01/09/2001 31/08/2002 J 01/09/2002...
  16. E

    Chart Help - Multi chart type

    Hello, Looking for some help / advice please. I have the below table of data - which i have created into a stacked bar chart to show each band and the equivalent band widths (minimum-maximum). The chart then has a line chart over it to show the average at each band. <tbody> Band Average...
  17. S

    Creating a band quote calculator

    Hi I have some excel documents that calculate wages for band members depending on certain criteria and band cost. However I want to reverse it so I put in the criteria, enter the band member hourly rate and works out how much the total quote is. It’s difficult trying to explain without showing...
  18. S

    [VBA] adding a band to a line-chart programmatically

    Excel 2012ABCDEFGHIJKLM1Using 2 additional helper rows to set band2JanFebMarAprMayJunJulAugSepOctNovDec3Inventory71535829307817682714414Lower Band Value6060606060606060606060605Upper Band Value7070707070707070707070706789Without using 2 additional helper...
  19. max_max

    Formula insert cost band

    Hello to all, In the attached file I must include this formula: If the cost in E2 is in one of these bands: Band 1 (less than 400 €) Band 2 (from 400 € to less than 800 €) Band 3 (from 800 € to less than 1200 €) Band 4 (from 1200 € to less than € 1,500) Band 5 (from 1500 € and beyond) Put in...
  20. D

    vlookup value in band of values

    Hi, How would I vlookup numbers within ranges of numbers? For example, I have the following ranges of numbers 50000 100000 100001 200000 What I want to do is be able to lookup my number (say 105000) within those two ranges and do so in a formula. Separately (and I believe this would...

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