• 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

    Is it possible to open excel from outlook.

    Hi, Is it possible to open excel from outlook. Thanks, SK
  2. S

    find out the names alone from a line

    Hi, How to find out the names alone from a line. Ex: 1. Senthil Kannan Ram working in abc company 2. vinoth kumar working in xyz company Now i want a formula to extract the names only for 1. Senthil Kannan Ram 2. vinoth kumar Any help. Thanks, SK
  3. S

    How to add or run Add-in file

    Hi, I have created a macro and saved it as 2007 Add-in file now. how i will add that add-in the activeworkbook or how i will run that particular macro. Thanks, Suresh Kumar S
  4. S

    how to adjust print title in macro

    Hi, I have a data where the header may move from 35 to 45 (after running the report may be first time it will be in 35 and second time will come down to 45 )how do i can declare the title in code. By default the recorded macro code taken it as.PrintTitleRows = "$35:$40". Now i want to find...
  5. S

    Sum row values with column header

    Hi, I have data in column A with header called Income below that lot of numbers there. i want to add those numbers. i tried sumif and sumifs also but no use. please help me Thanks, Suresh Kumar S
  6. S

    How to find out linked (reference) worksheet with activeworksheet

    Hi, I have workbook of 5 worksheets and all worksheets contains some formulas. I want to highlight if any other worksheet is linked with active sheet. Example in Sheet1.A1 =B1+Sheet2!B1 in this case is it possible to highlight either by macro or conditional format or some other tricks...
  7. S

    Trace Precedents

    Hi, I have a set of data in sheet1 and sheet2 by using Trace Precedents is it possible to figure out all the cells in both the sheets. Example i have formula in sheet1 on E4 = E3+Sheet2!E3. Now by using Trace Precedents i am able to find out the E3 (sheets1) cells but it is not selecting...
  8. S

    Formula without $ string function

    Hi, I have some formula without String ($) now i want replace the formula with string function. Suppose A1 =C1+D1 i want A1 = $C$1+$D$1 Thanks, Suresh Kumar S
  9. S

    Compare 2 formulas

    Hi, I want to compare 2 formulas and if there is mismatch it should highlight(Conditional format) Example: A3 AA3 - No Changes $A4 $A4 - Highlight ( It suppose to be $AA4) Thanks, Suresh Kumar S
  10. S

    Filter-macro

    Hi, I want a code if the active sheet as filter then it should msg "Filter available" otherwise it should apply filter. Thanks, Suresh Kumar S
  11. S

    sum

    Hi, Please refer the below below sheet and give me a solution. (I want the result column to be filled by formula) http://www.2shared.com/file/AICNqcSJ/Book7.html Thanks, Suresh Kumar S
  12. S

    Sumifs Formula

    Hi, I have a source sheet and I want the result in the below file. I have explained what I want. Excel hero please suggest a formula and give an idea to overcome this issue. http://www.2shared.com/file/U5J2eaGa/Book1.html Thanks, Suresh Kumar S
  13. S

    CheckBox value is null then skip the macro

    Hi, I have create 4 CheckBoxes if all the four CheckBoxes are not checked then the macro(already i have) should not run and it should through error message "Please select the above option". Please provide a code of me. Thanks, Suresh Kumar S
  14. S

    Sum Different dates

    Hi, I have the following dates and i want the sum of each months. 24-Jan-13 28-Jan-13 31-Jan-13 01-Feb-13 05-Feb-13 Output: Jan-13 3 Feb-13 2 Thanks, Suresh Kumar S
  15. S

    Print Out for entire workbook

    Hi, I have workbook with different sheets with different range (in each sheet) i want to print out all the sheets with all the different range in one page for each sheet. Any Macro is there? Thanks, Suresh Kumar S
  16. S

    Conditional format

    Hi, Is it possible to refer the next workhseet in conditional format. Thanks, Suresh Kumar S
  17. S

    Comparing 2 dates (in different format)

    Hi, How do I will compare 2 different format dates? A1 = 13/02/2012 (DD/MM/YYY/) B2 = 20100213 (YYYYMMDD) C2 = TRUE ( I need formula) Thanks in advance, Suresh Kumar S
  18. S

    CONCATENATE FORMULA

    Hi, Suppose I have data from A1:A14 as shown below 1 2 3 4 5 6 7 8 9 10 11 12 13 14 I want a formula to combine all the numbers to one like 1,2,3,4,5,6,7,8,9,10,11,12,13,14 Thanks, Suresh Kumar S
  19. S

    Number Format

    Hi, Suppose i have a set of number 1.100 1.208 1.098 and i want to add text " done" to the list with extact value like 1.100 done 1.208 done 1.098 done How it can be combined using formula. Thanks, Suresh Kumar S
  20. S

    Excel Format - like ticket booking

    Hi, I am looking for blocking a seat for different shifts in excel format (similar to movie ticket booking.....Select date,select # of seats,showtime & Price). Does any body have or help on this. Thanks in advance, Suresh Kumar S
  21. S

    sum of production hours depends on the months

    Hi, I want to sum all the production hours, present days and no of working days for a particular month. I have briefly explained in attachment. http://www.2shared.com/document/9cTqJACO/1_online.html Thanks, Suresh Kumar S
  22. S

    Huge File Size

    Hi, I have sheet of file size 34 mb. As per the request I have to copy 70 cells and paste for 2,00,000 cells.(I am able to perform the copy and paste the formula for max of 1000 rows only - due to some restriction in excel). After pasting formulas in all the 2,00,000 cells the file size has...
  23. S

    How to remove *

    Hi, I have list of years and i want to remove * special character alone from the list. Source: 2009 2010* 2011* 2012 Output: 2009 2010 2011 2012 Thanks, Suresh Kumar S
  24. S

    unique list

    Hi, I have list on Column A say 1 5 1 4 2 I want output as 1 5 4 2 Thanks, Suresh Kumar S
  25. S

    Filter

    Hi, Suppose in A COLUMN contains both text as well as number how I can filter only text (without using multiple option from dropdown). Thanks, Suresh Kumar S
Back
Top