Recent content by zeal7619

Thank you

I use off 365 sir. I would like to get the Minimum date from Column D (Start Date) and Max date from the Stop date column E.

Hello helpers, Could you please let me know the formula to figure out the minimum date and max date per subject in the attached spreadsheet.

Hi Peter, Thanks much for multiple solutions. I do have XLOOKUP option. Thank you soooooo much.

Hi vletm, ohh...I don't know that we have a separate solutions for .csv and .xls format.. Thanks so much for your quick help. I appreciate it.

Hi Peter, Thanks much for your response. Yes, you are correct. these are the dates I'm looking for. Could you please let me know the formula or send the file as an attachment?

Thanks much for looking into this. No I am not manipulating .csv file. I can convert it into excel file too. If just want to have a formula to have a projected date in a separate column. I attached a file and provided expected date for couple of the subjects.

Hello, I am not super expert in excel. I hope I get some help to resolve my issue. I have subject data where each subject will have a different Cycle 1 Day 1 date. Based on this C1D1 (cycle 1 day 1) date for each subject, I would like to generate projected date for Cycle 2 day 1 and Cycle 3 day...

Thanks so much. this is perfect bro.. I really appreciate it.

Hi, It may be simple for many, but not me. I have numbers and alphabets in a column. Each cell will have different set of numbers and alphabets. I would like to separate alphabets from numbers in a cell. If anyone help me with the formula. I know i can do it with "=Left (A2,8)" but i have...

Hi Xld, Thanks a ton man. It works for me. I really appreciate your help...It saves lot of my time. Thanks.. thanks.. thanks..

Hi Hui, Thanks for the reply. However; it is not working for me. It is giving me '0'. If I drag it gives me all "0". I would appreciate if anyone gives me good suggestion. I want to sum result if date is same and testcode may be A13+A14+A15+A16 or A13+A14+A15. Date Test Result...

I have huge data in excel sheet. I have 3 columns. Date in column 1 and Test column 2 and Result in column 3. I want to get the total of A13+A14+A15+A16+A17 if date is same.Sometimes they may have A13+A14+A15 or Less only for certain dates. Could you please suggest one formula. I really...