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

    Regarding Minimum Value

    Dear Sir,s I want to find minimum value for each year . Please support on attached Sample data :- Year Min 2002 Result shown in excel sheet 2003
  2. R

    Dates count to be done which are 65 yrs older than refence cell

    Thanks a lot for the nice support.
  3. R

    Dates count to be done which are 65 yrs older than refence cell

    Actually i want to count that how many dates are available in the data which are 65 years older than the date which are provided as “Effective Date” . please help me anyone.
  4. R

    Interest to be received for everyday but compound interval is "yearly"

    Greetings ! Exact amount not receiving when i changing the compound interval from "yearly" to "monthly". Detail is shown below:- Total days-422 Rate-21% Formula result-127182 Result needed-127215
  5. R

    Interest to be received for everyday but compound interval is "yearly"

    I i pasted it in excel but "#Name?"Error is coming
  6. R

    Interest to be received for everyday but compound interval is "yearly"

    Thanking a lot to everyone for the needful supports. please suggest the formula to receive the result i.e 123088 yes it is to be done.
  7. R

    Interest to be received for everyday but compound interval is "yearly"

    Greetings ! interest to be calculated for everyday but compound interval is "yearly" therefore i have calculated in excel but result is not correct. Compound formula Result in excel sheet is 22911 but result shall be 23088. Required result -23088 Please find the attached excel sheet and...
  8. R

    How to Use OR function with Match Function

    Greetings and thanks a Ton for helping me . Formula is working properly after sorting the data into A to Z manner.
  9. R

    How to Use OR function with Match Function

    Greetings to All ! i am using the following formula but it is not providing the correct answer. INDEX($J$17:$J$20,MATCH(1,INDEX(($H$17:$H$20=A7)*(OR(($I$17:$I$20=B7),($I$17:$I$20=B7+1))),),0)) Formula is not working at highlighted area and giving incorrect answer therefore please find the...
  10. R

    Validity period to be fetched from DB for a transaction

    Thanks sir it is working fine
  11. R

    Validity period to be fetched from DB for a transaction

    Recharge Validty to be fetched from DATa Base for a person if Transaction time is between the validtity. Please find the attached sheet for necessary support . Thanks in advance for the nice support.
  12. R

    count total vehicles registered on an individual name

    i have name in column A and vehicle no in column B then i am getting total trips of each individual through pivot table but i need following also in front of pivot table:- i would like to know that how many vehicles are listed on individual name . please find the attached and help me
  13. R

    I want to Look up a value from data if this value is happened within 5 minute

    Good Morning freinds! Please help on the attached sheet.
  14. R

    Help needed to complete if(and formula

    Sir If previous transaction status found rejected then Latest transaction to be checked from 2nd last transaction instead of previous transaction. My formula is working correct if all transaction status is accepted
  15. R

    Help needed to complete if(and formula

    Dear Friends A very simple things is not solving therefore i need help in attached sheet.
  16. R

    As i shall enter the heading name then his previous results should reflect in another column

    De Also formula is providing "blank" result if numeric value is inserted in column B
  17. R

    As i shall enter the heading name then his previous results should reflect in another column

    Dear Dear Friend Thanks a lot for nice cooperation. Absolute reference is assigned therefore formula is not working in downward cells.
  18. R

    As i shall enter the heading name then his previous results should reflect in another column

    Dear Friends Greetings ! As I shall enter the duplicate entry for a name then all his previous results should reflect in another column. Detail sheet is attached for reference.
  19. R

    How can fetch column heading for each row

    Dear Friend May u please guide what is the use of 1 to 8 in your index formula
  20. R

    How can fetch column heading for each row

    thanks f thanks friend
  21. R

    How can fetch column heading for each row

    Dear friend Thanks a lot for providing support. May u pls explain how formula working
Back
Top