Importing Data & using Formulas

[Quinton]

Hello my friends (I'm using 2007 version)

I currently import data into a sheet. It always has the same columns etc. 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 have another sheet that links to the data and shows just the date/s. Below is an example:

Column A = The Gables
Column B = Plot 1
Column C = 16.02.11

Therefore the above result will simply show 16.02.11.

Could someone show me the formula I need to do this please?

Many thanks in advance!

 

[yogeshmaney]

U need to extract just dates or other data also?

 

[Quinton]

Thanks for you help. I need all the columns as the dates alone will not help me as I will not be able to tie the date to the "other data".

Cheers,

 

[Quinton]

Can anyone else help PLEASE????

Cheers,

 

[yogeshmaney]

buddy its done almost... busy with some other chores

 

[Quinton]

Sincere apologies - Hopefully no love lost!

 

[yogeshmaney]

formula for col A: =LEFT(A2,(FIND("Plot",A2)-2))
formula for col B: =RIGHT((LEFT(A2,(SEARCH("??.??.??",A2)-2))),LEN(LEFT(A2,(SEARCH("??.??.??",A2)-2)))-LEN(A5)-1)

form for col c = LEFT(RIGHT(A2,17),8)

form for col D = RIGHT(A2,8)

 

[Quinton]

Many thanks. However I think perhaps I have not explained myself well?

To conclude I wanted just 1 formula as shown below:

Data

A B C
The Gables Plot 1 13.03.11

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 3 i.e. 13.03.11

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

Hope this helps?

Cheers,

 

[yogeshmaney]

You can put the address of that cell. (type "=" and click on the cell from where u taking the data). What kind of questoion is this?

 

[Quinton]

Because as I said before - the next time i import the data it will be on a different line. Therefore I need it to first identify The Site name (column A) then the plot Number (column B) so it can use the correct date (column C or D).

Does this help you?