Link to home
Create AccountLog in
Avatar of Steve Eckerman
Steve Eckerman

asked on

Excel Data Adjustments

Attached is the Excel file that I need help with. I was wondering if anyone could make me a formula that could sort the data that is in Columns E through K, Rows 2 through 422. I need the formula to analyze Column D "Date Due" and then move the data that is in the columns/rows stated in the previous sentence. I need it to move the data into the right column (E-K) based on the dates that head those columns. For example, if the Date Due in cell D2 was less than the heading in Column E (7/12/13) then I need it to move the data in that row (found anywhere from Columns E-K) into Column E. However, if the Date Due in cell D2 was greater than the heading in Column E but less than the heading in Column F, I would need the data in that row (again found anywhere in E-K) moved under Column F. And so on and so forth..

I'm not sure if it is possible to make a formula like this but I thought I'd ask. If it's not possible please let me know.

Thanks in advance. =)
Sample-Book.xls
Avatar of NBVC
NBVC
Flag of Canada image

Are you just looking to move the numbers in E:K around and place the numbers under different headers based on column D dates?

If so, then you would need to keep or move the current E:K columns for reference, then add 7 new columns that contain formulas.

is that what you mean?

Maybe a few example results would help to understand.
Avatar of Steve Eckerman
Steve Eckerman

ASKER

Yes I need them to be placed under the headers based on column D dates. If adding 7 new columns is necessary then that is fine. I just need it to sort them based on column D.  I attached two sheets. One is an example of how I want the data sorted and the other is the sheet I'm trying to put the formulas on. I want it so I can copy and paste data into it and it will sort it automatically. If you need to add 7 more columns to the right of column K then please do so.

Thank you for your help, it is much appreciated.
Example-book.xls
Project-Book.xls
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Here is the workbook back for your review.
Copy-of-Example-book.xls
Thanks, works great!