Hi All,
I am try to use index match function with number of columns having daily values e.g 1990 to 2018 to get data into single column. The formula is INDEX($C$3:$BB$368,MATCH(DATE(YEAR(BD2),1),$C$2:$BB$2,0),MATCH(DAY(BD2),MONTH(BD2),$C$3:$BB$368))
Where Column C to BB having daily data for 365 or 366 values (leap years). C2 to BB row has year names e.g 1960 to 2010 and BD is the column where I need all the data in one column.
Can any body suggest me code?
Isn't this a repeat of the other threads that you have posted?
Anyway, your DATE function seems to be missing the month parameter, which has ended up in the second MATCH function.
Pete
Hi every body
I am using following index match function to convert data, however, it is not production results.
=INDEX($C$2:$BB$368,MATCH(YEAR(BD2),$A$3:$A$97,0),MATCH(Date(DAY(AJ2),$A$2:$A$368,0)))
Could you please suggest amendment ?
Please read the yellow banner at the top of the scree. Act on its guidelines and post a sample sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please find attached sheet with data and output required.
Regards
saleem
Cross-posted at: https://www.excelguru.ca/forums/show...index-function
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
chsaleem. Can I strongly suggest that you read the forum rules. You have had two infractions in the last few days. One for duplicate posting on this site and one for not telling us about asking the same question on other help forums.
If you do not adhere to the forum rules, there is a stong possibility that you will be banned.
I have absolutely no idea what you want.
You were asked to post a sample of 10-20 rows with some manually calculated results. You have posted almost 400 rows and have given us no idea of what you expect to see.
Please add some manually calculated expected results on a SMALL sample sheet. It is unreasonable of you to ask us to check almost 400 rows, manually, to ensure that the correct solution is provided.
In your duplicate thread there was a formula...
use this in BD3
=INDEX(a,MATCH(1,INDEX((DAY(BC3)=d)*(MONTH(BC3)=e),0),0),MATCH(YEAR(BC3),b,0))
But READ the rules and stick to them. Otherwise you WILL be banned. Permanently.
Please try at BD3
Regards.
Please Login or Register to view this content.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Thank you very much. It worked and solved my problem. I will stick to the rules.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks