# technical

1. ### Get first argument for INDEX from calculated column plus one other question

I use a formula such as =IF(ROWS(\$1:1)>COUNT(\$A\$5:\$A\$1840),"",INDEX(Games!E:E,SMALL(\$A\$5:\$A\$1840,ROWS(\$1:1))+4)) to retrieve the value for a given column/row based on the selection from =IF('Analysis Data'!\$GU5>0,ROWS(\$1:1),"") This compresses a list down to only those that have a non-zero...
2. ### What is the correct measure?

I'll be grateful for any assistance, I feel that I'm close to a solution, but need help in properly defining the measure [EffortAssigned] - either that or I'm trying to do something that is not possible. I apologize for the length of this post, but I hope I've described the situation clearly...
3. ### VBA to Filter Before a Date using Formula

Hi Experts Got another problem to resolve I want to filter my records for dates before 10 yrs from today. So I have written following code, which is not working. There must be some technical thing, I'm missing upon. Further, my system use date as dd/mm/yyyy Please help Thanks...
4. ### Multiple Rows with Same Values - Isolate to one

Looking to solve the following: When column CLAIM_NUM and CLAIM_BAL match BUT in Column DENIAL_TYPE, the row equals "Technical Denial", input CLAIM_BALANCE into the Adjusted Claim Balance column BUT only one time, all other cells should remain zero. This will give me an accurate claim balance...
5. ### Time Conversion Question

Hello everyone, I just had a question on what the technical name of changing time into decimals is called. For example 1 hour 15 mins is 1.25, 1 hour 30 mins is 1.50, 1 hour 45 mins is 1.75. So on and so forth. 2 hours 32 mins is 2.53. The formula in excel from two cells (one with Hours and...
6. ### going to a new pay system

we are going to a new pay system. Instead of just a standard hourly wage, employees will be able to make a higher wage based on the production of the plant they work at. I am looking for help with a formula that will assign the new wage per hour based on the level of the employee and the amount...
7. ### Relatively Technical Question

This might be difficult to type out but I'll do my best. I am trying to convert some financial documents to the current fiscal year, and in order to do so I need to change file names. No matter how many times I duplicate the files, they are still sourced to the original document, which we need...
8. ### Is excel even the right solution? Technical reports.

I have been trying to use excel to generate quarterly TECHNICAL report printouts related to preventative equipment maintenance. We use a specialized program to generate the actual data for each individual report, so there is no accuracy nightmare with the actual data. The program generates a...
9. ### Data transpose from row's to columns - HELP PLEASE

Hey I need some help with some data reformatting via excel. I believe I need to create a set of macros and IF statements for this, but I definitely need some help and do not know where to start. Here is my situation: I have a excel document 521,165 Rows in it, all in column A. The issue with...

### This Week's Hot Topics

• Use Filter function with 2 criteria to return a specific value
I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
• Loop stopping at row 10
Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
• Numerical Order Code for Macro
I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
• Calculate time in excel
I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
• VBA
Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
• Help with formula to sum numbers prior to date
Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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