I am looking for help in populating another column that will show a “1” based on the following…..
· The capdate2 is less than or equal to the Ship_or_Return_Date while · The Name is the same name as above, that have at least one “1” in their test column.
Another way of wording things….
Where name is the same as above, (Data is sorted by Names and Ship_or_Return_Date), and that the capdate2 is less than the ship date, and that there was at least one “1” in column test associated with the name. Test is where there was a sale, due to our outreach, (180 day widow from Note_Date)…..but trying to find all subsequent sales following, within one year of the ship date from that first sale after our outreach.
Another attempt at wording this
if test = 1 then result needs to be 1 as long as the name is the same if test is 0 and the name is the same but capdate2 is less than the ship or return date then it needs to be a 1
The results column shows the output that I am looking for.
[login to view URL] - Sample data in csv format results column is made up currently
[login to view URL] - Sample data in txt format results column is made up currently
Hello Sir,
I read your job post carefully understood your requirement very well.
I very responsible person.
Please sir discuss more.
So I am interest your job.
I am waiting your replay.
Thank you.
Suvash D
Hi,
I would be happy to be a virtual assistant and assist with all of your needs. My goal is to provide best services for my clients.
I Will Do Any Type Excel Data Entry.
I am a part/full time freelancer of data entry and I offer a wide range of data entry services designed to suit a wide range of business. Accurate results guaranteed. I am always determined to deliver only the best for clients and all are in timely manner and without errors.
1. Expert in creating data base on MS Excel.
2. Excellent written communication skills with editing and proofreading.
3. Able to use my skills in best way to achieve customers' goal.
4. Expert in MS Office( Excel, Word, Power point).
5. Good Behavior and can work under high pressure.
I ensure that I can understand the project needs. I have good typing skills and currently i have been working as a data entry operator for 4 years. Even I can manage my time to complete this project on time.