Automatically Sorting Data

**Beh162** · 01-18-2017, 12:43 PM

Is there a formula that will take data and automatically sort it as the dates change.

In this Summary Sheet:
in A1 I have a list of Names, B1 List of dates. This data is reference from another sheets data, which is where the changed are actually made. I wanted to see if there is a formula that will automatically sort the data as I key changes to certain peoples dates. These changes happen throughout the year, and not all at the same time. I know I can re-sort the data, but if there is a formula I can use, I'd like to try it.

Joe 11/5/17
Mike 5/3/17
Bob 2/1/17
Jen 9/2/17

**avk** · 01-18-2017, 01:47 PM

If your data in sheet1. Name in column from "A2" & Date is in "B2"
In sheet2 same as above.
In Sheet1 create helper column in "C" & in "C2" cell formula is :

Formula:

Please Login or Register  to view this content.

Ensure Holp SHIFT+CTRL & ENTER (Array Formula)
If you change date in sheet2, It auto sorting in sheet1 in column "C"
Plz see attach file.

**Beh162** · 01-18-2017, 02:36 PM

Actually the data is just in one sheet that I want to sort. So from A1:A22 - B1:B22. Names in A, Dates in B

ETA:
The data in Summary reference 22 different sheets, that are named by the employee name. In B8 of every sheet is their annual review day.
So in summary sheet
A1 =Priscila!A5
B1=Priscila!B8

**avk** · 01-19-2017, 01:24 PM

Its better understand plz attach your sample file.

Automatically Sorting Data

LinkBack

Thread Tools

Rate This Thread

Display

Automatically Sorting Data

Re: Automatically Sorting Data

Re: Automatically Sorting Data

Re: Automatically Sorting Data

Thread Information

Users Browsing this Thread

Similar Threads

Automatically Sorting data

Excel 2007 : Automatically Sorting Data

automatically sorting data

Sorting Data automatically

Sorting Data & Updating Automatically

Sorting Data Automatically

Automatically sorting data

Sorting data automatically

Bookmarks

Bookmarks

Posting Permissions