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

    Formula for Auto filter

    Hello Chihiro, I have attached my sample excel file for filtering option. In this excel, Range C4 has input dates and need to filter the output in H6 and same time no. of months should be displayed in H6. Kindly provide the suggestion as my requirement. Regards, Sampath.S
  2. S

    Formula for Auto filter

    Hello Chihiro, Thanks for your reply, Here when using filter / drop down list, which is shown all dates in the list, but I need to filter based on month and year. Please suggest how to filter as my requirement. Regards, Sampath.S
  3. S

    Formula for Auto filter

    Hello, Actual In my excel ( sheet1), range A1:A100 having date's in dd-Month-YYYY. Requirment In same workbook (Sheet2), Need formula in B6 to filter the Actual range(Sheet1!A1:A100) in Month and year based. Please clarify the same. Regards, Sampath.S
  4. S

    Clarification for COUNTIF statment

    Hello, Actual Data In my excel ( Sheet1 ), Range A1 to A1000 having different date's from 1-Apr-2011 to 25-Apr-2015. Required data In same workbook ( Sheet2 ), Range B5 need how many of cells having after 1-Apr-2015 in Sheet 1(Total cells). Please clarify the above requirement. Regards...
  5. S

    Please extract the particular data from list of data using filtering option.

    Hello, For project assignment, I need VB macro for extract the data's from data list, which was available in sheet 1. Particular data count only extracted and placed in sheet 2 based on filtering condition. Note: Sheet 2 had fruit name and company code already, Need only count based on...
  6. S

    Change the data properties using condition statement.

    Hello Nebu, I need macro coding for that, because i attached that code into another macro. Kindly provide the VB coding for that. Regards, Sampath
  7. S

    Change the data properties using condition statement.

    Hello, I have ennumber of data, which data file was attached here. In that file, I need to change the data properties based on condition. Required Coding. If there is no data in cell(empty), that cell was changed in blue color. If any cell having 7 and above, that cell was changed in red...
  8. S

    Data filtering from Ennumber of data's

    Hello, There is no coding in given attached file. could you provide the coding for that output. Regards, Sampath.S
  9. S

    Data filtering from Ennumber of data's

    Hello Chirayu, Thanks for your given coding, I have one more requirement for the same excel, I have enclosed this sample excel with this mail. Here, I need to filtering optioned based on company coding and quantity. Output will be shown in output sheet. Kindly provide the macro code for...
  10. S

    Data filtering from Ennumber of data's

    Hello, I have huge data's in sheet 1. Need to filter from huge data and delete the duplicate data's. Kindly provide the macro for that. Herewith I have enclosed the sample here. Regards, Sampath.S
  11. S

    open any MS application using macro

    Hello Deepak, What link to checking.....Pls. Regards, Sampath.S
  12. S

    open any MS application using macro

    Hello Deepak, Need macro coding for open MS Word (open application and not for particular word file)and close it after 15 seconds. Please provide the coding. Regards, Sampath.S
  13. S

    open any MS application using macro

    Hello, Need to open any MS application / PDF using macro coding. Please share the coding. Regards, Sampath.S
  14. S

    Ennumber of conditional IF statment

    I have a very long if condition for my dashboard. kindly help me for my requirement which was mentioned below. IF A1="CMO" and B1="S" then C1=12 IF A1="CMO" and B1="M" then C1=20 IF A1="CMO" and B1="C" then C1=40 IF A1="PDB" and B1="S" then C1=12 IF A1="PDB" and B1="M" then C1=24 IF...
  15. S

    Please help me for excel formula to our Dashboard.

    Thanks for your support. This is my requirement what I expected. Thanks once again!
  16. S

    Please help me for excel formula to our Dashboard.

    Hello, I have a tracking sheet for our production. Following requirement mentioned for this needed excel. If A1<="10" then B1 is "C4" If A1<="50" and >"10" then B1 is "C3" If A1<="65" and >"50" then B1 is "C2" If A1<="120" and >"65" then...
  17. S

    Ennumber of conditional IF statment

    Hello Deepak, Thanks for your clarification, I need to know some more clarification about this formula. Copied this formula and using in another cell, It is not working. When copied this formula, I am not able to copy with {} symbol. Kindly solve this issues. Regards, Sampath.S
  18. S

    Ennumber of conditional IF statment

    Hello Tiago MF, When used this formula with table in another workbook, It can't working. and during that formula copied that{} is hided. Hello Deepak, When using this formula in I2 cell and same time putting input data in G2 & H2. It shows like "0" only. Kindly solve such kind of...
  19. S

    Ennumber of conditional IF statment

    Hello Asheesh, Thanks for your reply, could you provide the nested if example formula. This is very helpful to customize for our requirement. Regards, Sampath.S
  20. S

    Ennumber of conditional IF statment

    Hello NARAYANK991, Thanks for your reply, I have attached the example condition list file, when I using below If statement, Limited condition only applicable. but need above 30 conditions. =IF(AND(A1="E",A1=S),"12",IF(AND(A1="E",A1="M"),"3",IF(AND(AH="C"),"6",IF(AND(AH=""),"")))) Please...
  21. S

    Ennumber of conditional IF statment

    Hello, I have to create tracking sheet for employee production, For that, can't create the above 32 condition of IF statement. I known only Limited conditional if statement. Kindly suggest me for this. Regards, Sampath.S
  22. S

    Please help me for excel formula/pivot table for our Dashboard.

    Hello Ratan Bhushan, Thanks for your reply, I have attached the sample file with this forum. In this example. Input area is A & B column. C is Output column(Needed formula column) For Example, If A2 & B2 is E & C respectively, C2 will come 40.
  23. S

    Please help me for excel formula/pivot table for our Dashboard.

    Hello, I have create the employee tracking sheet. In this sheet, I need following requirement for this dashboard. 1. If put category item in A1 cell and put Complexity item in B1 cell, C1 need formula for respective number. Note : that category, Complexity and numbers are mentioned in...
  24. S

    Please help me for excel formula to our Dashboard.

    Hello, I have an production tracking dashboard, In that dashboard, When i entered C1 in A1 cell automatically B1 will reflect 5 if C2 in A1 cell, B1 get 6 if C3 in A1 cell, B1 get 8 if C4 in A1 cell, B1 get 10. I am using below mentioned formula but can't get the output in B1 cell...
  25. S

    Help to change the lower case to upper case of character

    Hello, my request is when enter the character in a cell, which will automatically change in uppercase. could you help me for this request. Regards, Sampath.S
Back
Top