Sorting as per Days Late & Days Early

[simran555]

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

[LJMetzger]

Hi simran555,

You can do what you want by:
a. Adding a Helper Column M that calculates the Days early or late:

=INT($K2-$I2)

b. Then sort using that column as the Key.

Lewis

[newdoverman]

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.

=H2-K2+1

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.

[simran555]

All Your replies helped me. Thank You

[newdoverman]

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.