technical

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

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

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

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

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

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

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

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

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