Good afternoon all,
After searching these forums for a couple of hours I have finally plucked up the courage to make a thread asking for some much needed help.
So what I need is for in the order start date column, I need a formula to pick out the first year where the value is inserted into the column and then insert the year into the order start date column. I would do this manually, but with thousands of rows a formula would prove to be most beneficial.
I have attempted to explain this as best I can but have now attached a spreadsheet that will be much more informative than me.
Any help would be very much appreciated and hopefully with a bit more usage of this forum I will one day be helping other new comers
Many thanks,
Andy
ExcelForum.xls
Last edited by TheMailman; 01-04-2012 at 10:14 AM. Reason: Did not comply with forum rules
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
This has now been amended and any help would be much appreciated. Thanks
Pl see the file attached.Formula is in O column.If satisfied mark the thread SOLVED.
Re: Vlookup or the if rule?
Hi,
Use the below Non Array formula.
=--INDEX($A$1:$M$1,MATCH(TRUE,INDEX(($A2:$M2<>0),0),0))
To ignore the error when there is no non blank cell is found then try the below one
=IF(ISNA(MATCH(TRUE,INDEX(($A2:$M2<>0),0),0)),"",--INDEX($A$1:$M$1,MATCH(TRUE,INDEX(($A2:$M2<>0),0),0)))
Hope that helps!
---
Sixthsense
Originally Posted by TheMailman
Good afternoon all,
After searching these forums for a couple of hours I have finally plucked up the courage to make a thread asking for some much needed help.
So what I need is for in the order start date column, I need a formula to pick out the first year where the value is inserted into the column and then insert the year into the order start date column. I would do this manually, but with thousands of rows a formula would prove to be most beneficial.
I have attempted to explain this as best I can but have now attached a spreadsheet that will be much more informative than me.
Any help would be very much appreciated and hopefully with a bit more usage of this forum I will one day be helping other new comers
Many thanks,
Andy
Attachment 134880
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks