Hey Everyone !!!!
Happy New year
I am working on a report for the All the Employees who went on leave and came back being late or early . The Problem is i am trying to sort out the data as per the Days Late and Days Early , and i can submit the leave report. If any anyone has any suggestion on how to sort the alphanumeric values , please let me know . PS - i tried the sort function in excel , it didn't work out in this scenario .
Thank You
Hi simran555,
You can do what you want by:
a. Adding a Helper Column M that calculates the Days early or late:
Formula:
Please Login or Register to view this content.
b. Then sort using that column as the Key.
Lewis
One method is to enter this formula in column L and fill down and format the column with a custom format of ##" Days Early";##" Days Late" This will give the text that you currently have in column L but the actual values are numbers that are either positive or negative.
Formula:Please Login or Register to view this content.
Click on a cell in the data and then click on the Data tab, Filter. All columns should now have filter buttons on the right side of the header cells. Click on the Variation column filter, click on Number Filters, choose Greater Than and enter 0. This filter will present you with all of the employees that returned early. If you had selected Less Than and entered 0 you would get all of the late returns.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
All Your replies helped me. Thank You
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks