LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nicole D
 
Posts: n/a
Default What formulas are best for sorting by date?

I have a master spreadsheet that has a list of people with dates
corresponding to each person. I want to link all of the January dates to a
January sheet, Februaty dates to a February sheet, so and so forth. The
dates are not in order, and I am using an =IF formula to bring them over to
each corresponding sheet. The problem is that when they are in the
corresponding sheet, they are being brought over in the row number that they
are in on the master sheet, which leaves several spaces between entries based
on the number of people there are bewteen similar months. I'm sure I am
making this more confusing than it should be, but I need help with how I can
do this easier. Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i set up a formulas with an if date? Thunley Excel Worksheet Functions 3 February 24th 05 03:36 PM
Min/Max formulas using cells with date format WDS2000 Excel Worksheet Functions 1 February 7th 05 06:03 PM
Date Formulas Charlene Excel Discussion (Misc queries) 7 January 6th 05 11:46 PM
Excel 2002 date formulas problem Andrew Warren Excel Worksheet Functions 4 January 6th 05 11:35 AM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM


All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"