UPDATE: problem was many typo errors that occured for unknown reason.....thanks for everyone's help!
UPDATE: problem was many typo errors that occured for unknown reason.....thanks for everyone's help!
Last edited by StiefBijer; 10-01-2011 at 02:59 PM.
B56: There is no 9/7/1970 in Column C. Why should it return sqr?
B64: 1/5/1971 occurs in C23 so why should it be blank?
B70: 1/11/1971 occurs in C22...
B82: 1/23/1971 occurs in C25...
B88: 1/29/1971 occurs in C24...
Am I misunderstanding your intent?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Your ranges did not cover all the data.
Try:
Cheers,Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Thanks ChemistB & ConneXionLost !
Yes, sorry, the example has a typo error.....the correct, original date 9/7/1970 changed to 9/7/1971 when I deleted the 400+ superfluous dates to make the example easier to understand.
I am now double-checking all the other dates before I upload a corrected example version. Gosh darn, that is frustrating, I triple checked before uploading....NEVER meant to exercise you at all. ;-(
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks