• 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.

Recent content by razaas

  1. R

    Need help to auto populate cells based on a number in an input cell

    You have not given any formula for 3rd row. Because I am not expert like you. I knew my solution might not be perfect that is the reason I asked for your comments and suggestions, you gave only comments but no suggestions. Highly appreciate your comments, your formulas for first two rows...
  2. R

    Need help to auto populate cells based on a number in an input cell

    Hi Narayan, Don't be so arrogant please, I did not ask you for another formula, appreciating your super skills I just asked your comments and suggestions on the formula in the attached file, few of my comments which I think you ignored what I meant was for all cells in each row which I...
  3. R

    Need help to auto populate cells based on a number in an input cell

    Hi Narayan, I think you didn't read my previous reply and not checked the attached file. Thanks
  4. R

    Need help to auto populate cells based on a number in an input cell

    Hi Narayan, Thanks a lot, it works well, but you missed the 3rd highlighted row, in the mean time i tried myself and succeeded with very long IF formula and first row with hard coded numbers, i wanted one formula for all cells, sample attached for your comments and suggestions. Please check...
  5. R

    Need help to auto populate cells based on a number in an input cell

    Thanks a lot NarayanK991 for looking into my query, yes the number of columns will be 8 only, max input value cell K5 can be 2500 and all other Qs "yes" you guessed them correctly. Thanks, Raza
  6. R

    Need help to auto populate cells based on a number in an input cell

    Please help with 3 formulas to auto populate the numbers, sample highlighted in yellow, in the attached excel file. Cell K5 is the input number, based on K5 all yellow highlighted cells shall auto populate in the pattern shown in Table 1 and if the assigned formulas working fine then the result...
  7. R

    An alternative formula

    Thanks Hui, Your 1st formula is really good and I am very happy with it as I compare it with my crude and layman kind of formula. You are so kind to provide another formula which seems not working as I desired, the reason might be that you are not aware of the actual dates I have which are now...
  8. R

    An alternative formula

    Thanks again Hui, I needed to get the anniversary dates if the month and day already passed then in that case the result should be next years' date. If the month and day yet to pass then current year, for which your second formula fails as you can see below the dates on right side. Also the...
  9. R

    An alternative formula

    Awesome! Thanks a lot, it is highly sophisticated than my formula. Have great day.
  10. R

    An alternative formula

    Hi all, I have dates in column D and I am using this formula “=IF(DATE(YEAR(TODAY()),MONTH(D3),DAY(D3))>DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),DATE(YEAR(TODAY()),MONTH(D3),DAY(D3)),DATE(YEAR(TODAY())+1,MONTH(D3),DAY(D3)))” in next column to determine the anniversary dates, the formula...
  11. R

    Match names and dates from source data

    Sorry the file was not attached to my previous post.
  12. R

    Match names and dates from source data

    HI, I need further help, Sam's "ISNUMBER, MATCH, OFFSET" formula working fine on attached file but as an improvement I am trying to export calender from sharepoint to my data input (sheet1, row 28 onwards). The exported dates have time included, therefore need help to alter the existing...
  13. R

    Match names and dates from source data

    Sam, Thanks a lot, it works perfectly and your help highly appreciated. Have a great day.
  14. R

    Match names and dates from source data

    Hi Sam, Thanks and it is almost as I wanted, but if you look at my sample formula, it is excluding weekend and holidays. I want weekend and holidays to be blank, for that I used NETWORKDAYS.INTL function into my formula, so if you can modify your formula to give blank cells on weekend and...
  15. R

    Match names and dates from source data

    Please see the attached file, what I want is match the selected month and name in sheet "view", cells B2 and A4 with the names and dates listed in sheet 2. The sample shown in "view" sheet is data matched from sheet 1. I want the same kind of output but with selected month and name and you may...
Top