Hello all hope someone can assist. I have a spreadsheet that has employee name and average hours worked.. The employee is listed multiple times because each row represents a pay period with number of hours worked. the last column I used to average the hours worked. So what I need is whenever there is a value greater than 30 in column g, I need to copy the row where column G has a value. It can be copied on the same sheet or on another. Any help would be appreciated.
Please see attached file.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
In case I misread the requirements ( I think you want the records where values in G are greater than 30) use this (adjusted) formula
=IFERROR(INDEX(A:A,SMALL(IF($G$2:$G$4910>30,ROW($G$2:$G$4910)),ROWS($I$1:I1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
AlKey:
Thank you so much in getting right back to me. Ill Look at it
Yea, it is in Post3. Sorry about that
no problem..... for whatever reason, it is not working... I am not familiar at all with array and such.. I keep getting the same result as you sent to me. I assume I am doing something wrong.
THanks
Here is the file with corrected formula.
I hate to ask but I removed the names of the employees in order to upload to the forum page. I want to use the formula you supplied and apply it to my original excel spreadsheet. How can I do this and achieve the exact results in the correct formula post. Again, I can't thank you enough.
Signed, excel dummy
Never mind... I figured it out.... BTW - You Da Man
The employee name shows up a 0 because there are not listed. Once you applied formula to your real data the formula will find them. You just have to make sure that you transplant formula correctly and enter it with Ctrl+Shift+Enter key combination. Unfortunately, I don't know the ranges for your real data so, I can't make changes to the formula.
Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks