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

    A number between the range

    Hi Kchiba, Could you suggest any other formula with the logic Faseeh and sirJB7. I would request Faseeh and SirJB7 to explain the logic of the formula.
  2. C

    A number between the range

    Please find attached the file for your reference. Kindly suggest the formula (if possible with logic so that I can understand and apply to other area as well)
  3. C

    A number between the range

    Hi, I have a number like 50 and there are certain range like... 0-50 : 10% 50-100 : 20% 100-150 : 30% How could I formulate to define under which range the said number is fall? Post confirming the range, I require to multiply the percentage with the said number? Kindly...
  4. C

    The cell contain formula as blank

    Is there any way to consider the cell as blank in which formula is there. The formula derive data from the excel shet (Name: DD-MM-YY)under the colum name (DD-MM-YY). I have not updated the data in the sheet named as 23-Feb-13 and hence the sheet where I have applied the formula to derived the...
  5. C

    Ignore #NA while extracting date

    I could not replace #NA with 0. Any other way....
  6. C

    Ignore #NA while extracting date

    I have the data table as follow: A B C D 1 Dates 31-Jan-2013, 30-Jan-2013, 29-Jan-2013, 2 A 200, 220.5, 0, 3 B #NA, 0, 20, 4 C 354, 365, #NA, I am using...
  7. C

    MS-Word Chart Formatting

    Hi, MS Office 2010 I have more than 200 charts to paste and format in word from excel with the same formatting. I want to record macro for the formatting which will be applied to subsequent charts. Please let me know how (or other way to work in fastr manner) Chart: Centralised, H...
  8. C

    Copy of formula with changing its cell reference

    I have put a formula in A1 as follow: =if(A2>1,"Yes","No") I want the same formula in B1 as =if(A2>1,"Yes","No"). I have more than 1000 of different formulas which needs to be pasted without changing cell reference as mentioned above. How I can do it? I have already put the...
  9. C

    Data Extraction?

    How can I upload the file? I don't Know Sirji. We have rating scale like that.. AAA AA+ AA AA- A+ A A- BBB+ BBB BBB- BB+ BB BB- B+ B B- C D I want that only in required data column
  10. C

    Data Extraction?

    Please let me know I can extract the data from column "Rating assigned" without filtering the data. (Suggest the formulas) as I have almost more than 6890 raw lines. Sr No Name of Entity Rating Assigned Required Result 1 ABC...
Back
Top