• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Z

    Need formula to find Minimum date and maximum date per each subject

    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.
  2. Z

    formula to generate projected date based on the c1day1 date

    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...
  3. Z

    Separate text from digits from a cell

    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...
  4. Z

    Looking for sum formula

    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...
Back
Top