LinkBack URL
About LinkBacks
don't know how to ask the question in words and I hope the attached file is making my question clear
don't know how to ask the question in words and I hope the attached file is making my question clear
Hello janvdallas and Welcome to Excel Forum.
Try pasting the following formula into cell C3 and copying down:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMC thank you for your quick reply. When pasting this formula I get an error #NAME? . Also column D, E, f and G must be filled same way as in the attachement.
Have you adjusted the function names for your Dutch locale?
http://dolf.trieschnigg.nl/excel/index.php
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi AliGW, good point. That helps. still I have the problem with the other columns. I will attach a new file with a macro that will almost do what I need but not perfect.
Here is a copy of the file from post #1 that has the formula applied.
Let us know if you have any questions.
Thank you JeteMC
You're Welcome. If your question has been answered, please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks