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

    Total count of numbers in each cell

    Hi All, In attached excel B2 cell having some values with contain special characters like "," and space. i want total count each cell wise Number 1,2,3,4,5 1,2, ,3, ,4 , , 6,, , , , output should be like 5 2 1 2 0 Please refer attached excel sheet. Thanks, Sreeni
  2. Y

    working day details- Month wise diff kind of days details

    Hi I have uploaded a sheet where you find date and holiday. i know how to get data month wise for all columns , but my requirement is i want select a month in drop down then all other column details should be updated automatically. Month- drop down (Jan,Feb,Mar..) Total Days No of working...
  3. Y

    project work

    Hi, i have attached my project work sheet and i want retrieve xref,rqst sheet and populated in target sheet(see attached sheet) as per below condition 1. if sem_cin=cin then get ip_ip related sem_cin 2. if sem_cin is null or other than number then use cin=cdkey then get ip_id 3. if...
  4. Y

    Vlookup not working large numbers

    vlookup not working with largenumbers. is there any other way to compare large number
  5. Y

    dependent filter

    in sheet1 having account number,type and group columns. my query is: 1. E1 get count of d1 value. ex if d1 is 121 then e1 is 16 2. g3,g4 get count of d1 value with respect of f3,f4. ex is d1 is 121 then f1 is 0 then g3 value is 15. thank for advance sreenu
  6. Y

    Data selection

    sheet2 having data sheet1:- when i enter B1 cell is 121 or 122 or 123 then under name(a3),number(b3) fileds need to fill 121 data. example. B1 is 121 Name Number 1 a1 2 a2 3 a3 4 a4 like this. Thanks for advance sreenu
  7. Y

    MID function

    1.A1 having 1 and A2 having 1 comparing A1,A2 using IF function(=IF(A1=A2,"Y","N"). it gives correct result like 'Y'. same as above 2. G1 having 23456 applied G2=MID(G1,1,1) it gives value is 2 in G2. now i compare values G2 and A2 using IF function(=IF(G2=A2,"Y","N") gives incorret result...
  8. Y

    multiple dependent validation

    Hi, i have data(List) and i want report like (validation). my query is: in validation sheet:- when i am selecting A1,A2,A3,A4 IN ACCOUNT TYPE column in B2,B5,B8,B11 cell and other all relevant data for A1,A2,A3,A4 data should be filled automatically in other cells. please find the attached...
  9. Y

    all other cells data filled with single dropdown select

    Hi, i have data(List) and i want report like (validation). my query is: in validation sheet:- when i am selecting A1,A2,A3,A4 IN ACCOUNT TYPE column in B2,B5,B8,B11 cell and other all relevant data for A1,A2,A3,A4 data should be filled automatically in other cells. please find the attached...
  10. Y

    dependendent Data validation

    Hi All, I have data in sheet 1 "country,State,District'. in sheet one A1 column having dropdown and should be display as "country,state,district" and B1 column should be displayed relevant field data. ex. if A1 column select country then B1 displayed ind,us,uk..... if A1 column select state...
  11. Y

    Compare Two Sheets in excel workbook

    look into my data in sheet1- A column-1,2,3,4,5,6 sheet2 A column-2,4,7,8,9 compare the data get result like sheet2 B column: 2-yes(present in sheet1) 4(present in sheet1) 7(not present in sheet2) 8(not present in sheet2) 9(not present in sheet2)
Back
Top