FloorManager
New Member
- Joined
- Aug 22, 2017
- Messages
- 3
Hi all,
My knowledge of Excel is pretty basic, and the things I am trying to do are above my level of knowledge thus far. Im working with Excel 2007 on a Macbook. Let me explain in detail~
On Sheet1 I have a table with columns from A to O. Each of them have filters engaged. If I toggle through those filters in columns A, B, and C, I can break it down to the level I want and I get the desired range of information displayed in Column O.
What I want is to export the consolidated range of information now found in Column O to Sheet3 and display the top three numerical values from Column O.
To specify with an example, Column A=Employee, Column B=Operation, Column C=Size. Column O would be the time it takes the employee to conduct the number of products in one hour on average. So when I filter out Columns A, B, and C, I can gauge this subset of information: Employee=Cody, Operation=Bending, Size=Small Rod. Evidently We can see in Column O that Cody bends 100 small rods per hour on average.
These performances are recorded over time and are updated in real time. Therefore, Whatever Fx is to be used to get the top three performances displayed on Sheet3 would have to be able to accomodate for these additions to Sheet1.
Im thinking that I need an IF statement to show that the array is contingent on what text is displayed in each column (specifying "CODY","BENDING","SMALL_ROD"). Since there are muliple congingencies for the range, they would probably have to incorporate an AND statement. I was thinking that the positive outcome of the IF statement could be a large statement, specifiying 1,2,or 3 for the kth value. It doesnt matter what the negative outcome of the IF statement is, so I've just been putting "FIX_IT". My Fx looks something like this right now: =IF(AND(SHEET1!A:A="CODY",SHEET1!B:B="BENDING",SHEET1!C:C="SMALL"),LARGE(SHEET1!0:0,1),"FIX_IT"). The cell is coming up with FIX_IT, what am I doing wrong?
It would be awesome for someone to help me write a Fx to solve my problem. Ive been looking at what other people have encountered and I cant find exactly what I need. Thanks for the help yall!
My knowledge of Excel is pretty basic, and the things I am trying to do are above my level of knowledge thus far. Im working with Excel 2007 on a Macbook. Let me explain in detail~
On Sheet1 I have a table with columns from A to O. Each of them have filters engaged. If I toggle through those filters in columns A, B, and C, I can break it down to the level I want and I get the desired range of information displayed in Column O.
What I want is to export the consolidated range of information now found in Column O to Sheet3 and display the top three numerical values from Column O.
To specify with an example, Column A=Employee, Column B=Operation, Column C=Size. Column O would be the time it takes the employee to conduct the number of products in one hour on average. So when I filter out Columns A, B, and C, I can gauge this subset of information: Employee=Cody, Operation=Bending, Size=Small Rod. Evidently We can see in Column O that Cody bends 100 small rods per hour on average.
These performances are recorded over time and are updated in real time. Therefore, Whatever Fx is to be used to get the top three performances displayed on Sheet3 would have to be able to accomodate for these additions to Sheet1.
Im thinking that I need an IF statement to show that the array is contingent on what text is displayed in each column (specifying "CODY","BENDING","SMALL_ROD"). Since there are muliple congingencies for the range, they would probably have to incorporate an AND statement. I was thinking that the positive outcome of the IF statement could be a large statement, specifiying 1,2,or 3 for the kth value. It doesnt matter what the negative outcome of the IF statement is, so I've just been putting "FIX_IT". My Fx looks something like this right now: =IF(AND(SHEET1!A:A="CODY",SHEET1!B:B="BENDING",SHEET1!C:C="SMALL"),LARGE(SHEET1!0:0,1),"FIX_IT"). The cell is coming up with FIX_IT, what am I doing wrong?
It would be awesome for someone to help me write a Fx to solve my problem. Ive been looking at what other people have encountered and I cant find exactly what I need. Thanks for the help yall!
