# challenge

1. ### Help with if statement in VBA code!

Can somebody help me figure out the code below? I'm trying to insert rows as part of a macro. I have the code inserting lines working, but I need it only to insert lines where the value in column B is greater than 1000. Dim ws As Worksheet Dim rowsn As Integer, count2 As Integer...
2. ### Sort List in Ascending Order Using Only Excel Tokens [hard puzzle]

Somebody might be interested, this is not an easy task. It asks to sort a list using only excel formulas, but not a sort. So you have to use array calculation knowledge and so on. https://www.homeworkhelponline.net/blog/programming/excel-puzzle
3. ### Formula - distributing data over months

I am trying to create a formula that distributes the data in Y1-Y20 (these are years) by month over the Rebate Start and End Date Range. The challenge is the data changes year to year. Can anyone help...
4. ### Long greater than, less than formula

Hi All, I need a formula to work out payments based on performance, the challenge I'm facing is that there are various scales of payemnt depantdant on the formula. and I just cannot figure it out. So if A1 is greater than F1 but less than F2, I need it to show a bonus amount in H5. But then it...
5. ### Inflation formula with varying rates per year!

Hello, I am looking for a formula that properly pulls a Baseline Expense depending on location (this part is done) and then multiplies it by looking up the inflation rate for a given year. Second half of the formula is below. Inflation portion...
6. ### Excel Challenge from a friend - I failed can you solve it?

I hope one of you gurus can solve this. I was only able achieve right result using 2 helper columns but challenge requires only 1 helper column to be used (part 1) and no helper column at all for part 2 of challenge. I managed to get the correct answer of -111 using the following formulas in...
7. ### Disable all controls and menus except the "close", "minimize" and "maximize"

So I have been digging the web for a while now and I can't find the best way to handle the above challenge yet. Can it be possible to disable all the menus except the control box items as indicated in the header of this thread? Regards

Dear All, My colleague Paul Mireault has created a Multi-Dimensional Spreadsheet Challenge. It offers an interesting and demanding Excel implementation problem. The solutions he gets are intended to be used in preparing a research paper for the 2019 EuSpRIG (European Spreadsheet Risk Interest...
9. ### Excel challenge (INDEX formulas)

Can you deal with the comments in the attached? https://www.dropbox.com/s/uwuf9nht3snfva1/example%20-%20Copy%20%283%29.xlsx?dl=0
10. ### Need some guidance on a challenge

Dear Forum, I need some help as I have no idea how to tackle this challenge. I have data in the following format (about 7000 records): <tbody> User Project Code Transaction Date Hours Allocation Category </tbody> and need to do some calculations on it, and present it in this...
11. ### Lookup Value in Range and return nearest number (lowest) beween sets of numbers within the range

<tbody> Challenge 1: What you know: The employee is in pay grade 3 and rate is \$25.30 Challenge: write a formula that looks up the grade, and then returns the value on that range in which \$25.30 is nearest to (rounded down) Challenge 2: Write...
12. ### Pointing formula group to new references... I think that's what I want to do...

Hi all, It's my first time posting here, and I apologise for what will surely be a question full of incorrect vernacular and confusion. I will however be concise. So: I'm building a roster for event staff - it should be simple, but I got carried away. The first sheet (Schedule)is where start...
13. ### Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results

Hi I’m trying to find out if it is even possible to create a Vba code for Multiple Columns all Combinations and if exceeds limit for worksheet moves on to a new worksheet with the rest of the results I guess you can call this a excel VBA code challenge
14. ### Return text between dates challenge

Does anyone know how to calculate quarters in excel from a beg and end date where i am looking to seperate for Q1,Q2,Q3,Q4,Full Year? The challenge is the quarters fall between a specific range and not the usual Jan 1 to Mar 31. Every year has a different date range for Q1,Q2,etc...Then we...
15. ### OptionBox challenge

Hello All, I am having issues with how to select an optionbox when I change the content of a combobox. If there is a way out then let me know. Thanks. Kelly
16. ### This is a thinker: Sumproduct with Index/Match

Hi Everyone, So this is my equation {=IFERROR(SUMPRODUCT(--('1'!\$A\$5:\$A\$33='Monthly'!A2), INDEX('1'!\$N\$5:\$N\$33,,MATCH('Monthly'!A2, '1'!\$A\$5:\$A\$33, 0))),"")} {=IFERROR(SUMPRODUCT(--('1'!\$A\$5:\$A\$33='Monthly'!A3), INDEX('1'!\$N\$5:\$N\$33,,MATCH('Monthly'!A3, '1'!\$A\$5:\$A\$33, 0))),"")} It is taking...
17. ### help with an "If AND" formula

I'm running into a challenge with an "if And" formula. What I want to do: If BV4 = .46, then 0 else if BV4<.46 and AT4<5 then vlookup BV4 to the Rate table else 9 Can you help me figure out what's the issue? Its returning "False" =IF(BV4=0.46,0...
18. ### days of week list challenge

Here is a bit a of a challenge... Say I have some days of week marked in cells by an "X", and a cell where I am currently entering the days of service. I am looking for a formula in days of service cell that examines the cells to its left for an "X", and derives a concatenated list of the...
19. ### VBA select case

Hello All, I have this code for clearing data from certain range of some sheets in my workbook. What I want the case statement to do is to pick sheets that I want to exclude from the clearing. Sub ClearRange() Dim Wsheet As Worksheet For Each Wsheet In Worksheets Select Case...
20. ### Gantt Chart Formulas

Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...

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

### Which adblocker are you using?

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

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