Formula & moving data

[Quinton]

Hello my friends (I'm using 2007 version)

I currently import data into a sheet. It always has the same columns etc. However the data grows every time I import i.e. more lines appear and the data is never on the same line.

Below is an example of the data:

A B C D
Site Name Plot Planned Date Actual Date
The Gables Plot 1 16.02.11 13.03.11
The Gables Plot 2 19.02.11 18.03.11
And so on!!

I would like to - In another sheet - do the following:

If a row in column "A" has "the Gables" & the same row in the next column "B" has "plot 1" then show the data in column "C".

All I want to do is show 13.03.11 in a cell in another sheet.

Many thanks in advance!
<!-- / message -->

 

[Quinton]

Many thanks!

Data as requested!
Column 1 Column 2 Column 3
Site Name Plot Planned Date
The Gables Plot 1 16.02.11
The Gables Plot 2 19.02.11
The Gables Plot 3 27.04.11
The Gables Plot 4 16.02.11

Can't space the data out, but you should get the drift!

Cheers,

 

[Quinton]

To help further here are 2 set of data. For example 1 set 1 month & 1 set the second month:

Month 1
.........Column 1 Column 2 Column 3
Line 1Site Name Plot... Planned Date
Line 2 The Gables Plot 1 16.02.11
Line 3 The Gables Plot 2 19.02.11
Line 4 The Gables Plot 3 27.04.11
Line 5 The Gables Plot 4 16.02.11

Month 2 (copied & pasted over Month 1
.........Column 1 Column 2 Column 3
Line 1Site Name Plot... Planned Date
Line 2 The Gables Plot 3 19.02.11
Line 3 The Gables Plot 4 16.02.11
Line 4 The Gables Plot 1 21.04.11
Line 5 The Gables Plot 2 19.02.11

 

[dvananthan]

hi

tks

as per your sample, the site name is always same (the Gables)is it so?

as soon as you paste the current data please choose the heading row.
then click on data/filter/autofilter.

you will get drop down arrows on each column heading of site name, plotno and date.

from plot no dropdown choose the plot no you want and the data will be filtered only for that plot number. just copy and paste it in the sheet you want

regards

ananth