• 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

    Help required : Copy and Paste - from sheet to sheet

    Dear Excel experts , I have a excel file with 2 sheets - From Sheet 2 need to paste data to sheet 1 which is filtered ; whereas sheet 2 is not filtered See uploaded file for same - Need to fill the column A " Final remarks " from DATA 2 sheet DATA - sheet 1 - Filtered DATA 2 - Sheet 2 -...
  2. S

    Countif on Colour filter

    Dear Solvers, I have data from A column to E column ,In Which E column(Status) has conditional formatting to Red Green Yellow Need no.of red, green , yellow items
  3. S

    Datas in different columns into one

    dear solvers I have details of employee as A B C Senthil Quality 5, MGR street, Tambaram I need as (Please note i want below like in a single cell) Senthil Quality 5,MGR Street
  4. S

    =SUMPRODUCT(--(MOD(A1:A26,2)=0),A1:A26)

    Dear Solvers, i got the answer for summing up of only even numbers in a series of data but solver has used -- infront of MOD formula can u please explain why the solver has put -- what is this ??
  5. S

    Summing up only even numbers in a series of data !!

    Dear Solvers, I have a series of data where it consists of Odd and even numbers in A column I would like to add(Sum) only the even numbers using a formula
  6. S

    Adding blank rows in between available in one shot

    Dear Experts, I have the data as below Column A Row 1 23 Row 2 45 Row 3 46 ... Like i have data upto row # 566 - I Need to add a blank row in between each row , suggest me some short cut to add the blank rows in single one shot / easy Thanks
  7. S

    Min value in Vlookup

    Hi Solvers, Suppose i have data like this A B Type Value Part 1 3.62 Part 1 2.63 Part 1 3.65 Part 1 2.00 When i tried to put a vlookup for part 1 it retrieves only the first value whereas i want the min value answer retrieved is 3.62 but i need 2.00 (Min value of same part #)
  8. S

    Copy Insert comment

    Hi solvers I have a data in a cell A1 = 23456 with insert comment as north want to provide a link to another sheet ,where i need both insert comment and data thanks Senthilkumar RM
  9. S

    Is it Possible - Live chart

    Dear Expert solvers, We had a scenario where needs to fulfill as when data as Data A B C D E row1 12 23 44 55 65 Requirement When i place my cursor in B1 it has to show graph(trend) by fetching A1 & B1 whreas when i place at column E it has to show graph upto E by...
  10. S

    Value calculation with criteria

    Hi solvers I have scenario where i want to get values by looking up the value in other cells find below is criteria, i need a formula which looks the value in cell C3 and displays the corresponding value A column B Column Criteria Value C1 = 99.4 100 25...
  11. S

    Print no.of copies with macro - fetch data from a cell

    Dear solvers, I have an excel which need to be printed as many copies, No.of copies has to be fetched from a cell in that file( say = D4) what can be the macro code Senthilkumar RM
  12. S

    Solve this text retrieve query

    I have data as C5 = text1 D6 = text2 E7 = Text3 F8 = text4 i need the output as G5 = Text1 (= C5) G6 = text2 (= D6) G7 = text3 (= E7) G8 = text4 (= F8) I have tried what i know, please help me in solving this
  13. S

    Query on sumif

    Region Customer Name Sales East Mahesh 3300 East Shahul 2300 East Prabakar 1400 East Samsu 2345 East Perumal 1234 West Mahesh 889.7 West Shahul 481 West Prabakar 72.3 West Samsu 7300 North Perumal 2344 North Mahesh 1323 North Shahul 6777 North Prabakar 6554 North Samsu 7773 South...
  14. S

    Why it is reflecting Zero ?

    Region Customer Name Sales East Mahesh 3300 East Shahul 2300 East Prabakar 1400 East Samsu 2345 East Perumal 1234 West Mahesh 889.7 West Shahul 481 West Prabakar 72.3 West Samsu 7300 North Perumal 2344 North Mahesh 1323 North Shahul 6777 North Prabakar 6554 North Samsu 7773 South...
  15. S

    Auto fill : Need Help

    Hi Solvers When i drag auto fill option is not visible ( That "+"sign usually appears in bottom right corner of cell and it is used for draging formulas and numbers ) Where can i found the option to sort it down - Ps : In 2003 & 2007
  16. S

    Issue with Insert comments

    Dear Solvers, I have a huge amount of data in an Excel sheet , Where almost all the cells have insert comments Problem encountered is that , Some of Insert comments are showing only the arrow mark not the inside comment , When i right clicked and showed comment it is showing somewhere else...
  17. S

    Help Needed : Data withdrawal with comments

    Dear Experts, Here i need the solution In an excel sheet 1 cell A1 with text "Senthil" and insert comment with "Quality Department" When i call the cell in sheet2 D5 cell (=sheet1!A1) i got the answer Senthil but not the comment Is there any method or technique to get the comment also
  18. S

    Help needed in pagesetup and Print

    Dear Solvers, I have a sheet which needs to be printed,I Have inserted two button for printing say Button -1 : A4 size print Button -2 : A3 Size Print Need to Write a macro for, If user chooses A4 print, Page has to align (fit) for A4 landscape and printed and if user chooses A3 Print...
  19. S

    What is the Simple Way to find Slash in Given Example

    Hi Solvers, I Have file name as D:DataPersonalsramasamdesktopExceldata.xls Want to find the 4th Slash() what is simple way Find Function looks big !! Thanks
  20. S

    Is it possible to get a picture using choose fn / vlookup

    Hi all, I have data as Column A Column B 1 Wallpaper some picture object 2 Logo Picture 3 Personalities Picture In Cell D1 , i have done data validation with list >source > A1 to A3 in cell E1, i need the corresponding picture when i choose D1
  21. S

    Formula - Match (What is the use)

    Hi Experts, What is the use of Match type in Match formula, For any Value/ Not given entered , It gives same result Thanks
  22. S

    How to Insert a calendar in Excel

    Hi Solvers, Greetings !! We are in phase of creating a form - Date is one of the field , User has to enter from and to date , For that i want to show a calendar with condition Past - 3 Years from today's date and upto present date, User is not allowed to choose beyond these dates Thanks
  23. S

    MOS Certification - Expert level

    Hi Helpers, We have completed "MOS Specialist" exam for Excel 2007, We would like to do more learning and get expertises with second level "MOS - Expert" We are unable to find Training Institute for learning !! We are In Chennai, India Thanks
  24. S

    To Fetch an E- Mail ID from address book and Send Mail

    Dear Solvers, Help Me in solving this !! I have an sheet, In which user will enter name of person whom he wants to send Mail for Eg; senthilkumar . The Lotus notes(what we are using) should open and search the address book or directory and show result in To"field automatically Thanks...
Back
Top