Recent content by yaparala

Thanks AliGW :)

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

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

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

SirJB7, i got it. thanks for help

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.

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

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

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

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

many thanks Debraj.

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

Hi Hui, i got error is N/A.

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.

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