• 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 Arun , Not working !! - It is taking the corresponding row data not the filtered - unable to paste
  2. S

    Help required : Copy and Paste - from sheet to sheet

    Dear Arun, Need to paste the data - final remarks column from data 2 to the sheet 1 data Since in sheet 1 data - some rows are hided as it is filtered - Data 2 sheet not filtered and the corresponding line item is same if we use Visible cells option from 1 to 19 row it is pasting whereas...
  3. 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 -...
  4. 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
  5. 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
  6. 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 ??
  7. S

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

    Can u please explain the formula i dont understand -- infront of mod
  8. 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
  9. 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
  10. S

    Min value in Vlookup

    Thanks Roy But i have data of whole list , I need it on Vlookup
  11. 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 #)
  12. 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
  13. 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...
  14. 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...
  15. 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
  16. S

    Solve this text retrieve query

    thanks understood clearly
  17. S

    Solve this text retrieve query

    Thanks It is working can u explain "ZZ" term here !!
  18. S

    Solve this text retrieve query

    Thanks for formula solution ... but issue is little different I have data as C5 = text1 D6 = text2 E7 = Text3 F8 = text4 c9 = text 5 D10 = text 6 E11 = text 7 F12 = text 8 i need the output as G5 = Text1 (= C5) G6 = text2 (= D6) G7 = text3 (= E7) G8 = text4 (= F8) G9 = text5 (=...
  19. 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
  20. 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...
  21. S

    Why it is reflecting Zero ?

    Thanks !! chandoo Now i understood
  22. 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...
  23. S

    Auto fill : Need Help

    Great and thanks
  24. 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
  25. S

    Best way to format/setup spreadsheet

    Use dashboard with control box
Back
Top