Search results

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

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

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

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

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

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

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.

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

Hi Sam, yes.

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

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