You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
COPY date from Sheet 1 to another 15 mins work sheet
- Thread starter Techtrend
- Start date
In the sheets provided by you, there is not even one row where date and symbol matches. Please check.we need to only match the date and symbol from one sheet to the other
with best regards
Arun N
as there was lots of data in the sheets and i was unable to attach it hear,
i had removed the data,might be bcas of this the data is not matching.
how ever can u u make a formula in the related sheets and give so that i can test.
I need to copy the ATR column from sheet 1 to 15 minus excel sheet, if Symbol and Date matches in both the sheets.
We can paste in 15 minus J Col
i had removed the data,might be bcas of this the data is not matching.
how ever can u u make a formula in the related sheets and give so that i can test.
I need to copy the ATR column from sheet 1 to 15 minus excel sheet, if Symbol and Date matches in both the sheets.
We can paste in 15 minus J Col
as there was lots of data in the sheets and i was unable to attach it hear,
i had removed the data,might be bcas of this the data is not matching.
how ever can u u make a formula in the related sheets and give so that i can test.
I need to copy the ATR column from sheet 1 to 15 minus excel sheet, if Symbol and Date matches in both the sheets.
We can paste in 15 minus J Col
Open both files. Type the following formula in J2 and copy it down.
=IFERROR(INDEX([Sheet1.xlsx]Sheet1!$M$2:$M$693,MATCH(A2&B2,[Sheet1.xlsx]Sheet1!$A$2:$A$693&[Sheet1.xlsx]Sheet1!$B$2:$B$693,0)),"") Control+Shift+Enter(CSE).
with best regards
Arun N