• 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

    Thanks AliGW :)
  2. 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
  3. 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...
  4. 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...
  5. Y

    Vlookup not working large numbers

    SirJB7, i got it. thanks for help
  6. Y

    Vlookup not working large numbers

    actually this my requirement for large value data comparison. so that y i posted here. i am using vlookup, which perform compare the the data into diff columns. but its not working as same in my data. sorry for irritating.
  7. Y

    Vlookup not working large numbers

    hi Faseeh, in column F and M data not in sequnce but some of data are same in two columns. i need to compared M data into F column using vlookup or any other function.please provide the formula with same excel sheet if possible. thanks for advance
  8. Y

    Vlookup not working large numbers

    hi sirJB7, in F and M column data are not in sequence. i have to search M column data into F column data using vlookup. i tried this way. just tell me how to search M value into F column data using vlookup. please send me update excel sheet if possible. thanks for advance
  9. Y

    Vlookup not working large numbers

    hi 3G, iam getting all A,B,C,D,E column data into F column and h,i,j,k,l values into M colums. i have comparision columns F and M in excel sheet. pls look into excel sheet. thanks for advance for you help
  10. Y

    Vlookup not working large numbers

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

    dependent filter

    many thanks Debraj.
  12. 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
  13. Y

    Data selection

    Hi Hui, i got error is N/A.
  14. Y

    Add criteria filters to an Array formula

    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.
  15. 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
  16. Y

    MID function

    Hi Narayan, i got clear idea. thank for ur help..............
  17. Y

    MID function

    Thanks for reply, but if i using same If function (=IF(G2-A2=0,"Equal","not Equal") it gives correct value. here also i am using same tex
  18. Y

    MID function

    Thanks for reply, but if i using same If function (=IF(G2-A2=0,"Equal","not Equal") it gives correct value. here also i am using same text
  19. 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...
  20. Y

    multiple dependent validation

    Hi Smallman, thank for your answer, but i am looking this one. please find below my query and sheet. Hi, i have a data in list tab, using this data i have to prepare report in validation sheet. in validation, 1.if i am selecting B2 cell as A1(it should dropdown and display all A1,A2,A3,A4)...
  21. Y

    multiple dependent validation

    Hi bobch, thanks for reply, but i need to fill the data other cells. please go through my attached sheet. u will get my question.
  22. 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...
  23. 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...
  24. 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...
Back
Top