x
Solved

# Excel copy column to new sheet

Posted on 2011-09-26
Medium Priority
239 Views
Hi,

I have an excel file that contains about 10 columns.
I need to create three new columns on a new sheet based on the date range.

ID      col1                  col2           col3
1         9/1/2011     9/1/2011     9/1/2011
2         9/2/2011
3         9/3/2011     9/6/2011
4         9/4/2011     9/3/2011
5         9/5/2011

let's say, date range is 9/1-9/5

new sheet

col1   col2   col3
1       1       1
2       4
3
4
5
0
Question by:mcrmg
• 3
• 2

LVL 5

Expert Comment

ID: 36598446
Hi,

could you please attach the sample excel workbook what you are expecting

KK.
0

Author Comment

ID: 36598458
Book1.xls
0

LVL 5

Expert Comment

ID: 36598497
Hi,

What is the expected output, which logic has applied to get the results,

col1   col2   col3
1       1       1
2       4
3
4
5

Where these above values will get filled, is it a count? or sum? etc.,

KK,
0

Author Comment

ID: 36598505
hi,

The logic is to get any row that within 9/1-9/5

and place the ID column into the new sheet..thx
0

LVL 5

Accepted Solution

Kannan K earned 1000 total points
ID: 36599072
Hi,

the formula used - =IF(AND(Sheet1!B2>=\$B\$1, Sheet1!B2<=\$B\$2),Sheet1!\$A2,"")

KK,
Book1.xlsx
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.