Hi,
I have excel sheet containing 1Lakhs of record ,with 40 columns,which contains blank records as well.The sheet which i have sent is just a out view of the requirement
In a result sheet,i have a drop down,on changing a buisness name, the data has to get updated in each cell based on the criteria,for each cell conditions are differnt
say,first sheet of my data has buisness name in 3rd column-china,India,US etc,5th column contains status-active,new,reopen and 13th column contains-windows,unix(multiple windows and unix with difrnt names,ex-windows123 etc),
9th column contains host names (with lot of repetations in it)
say example for any cell :
for the cell c3 of a result sheet : on selcting buisness,drop down buisness has to match offcrse,then condtion is contains all windows(*win*),then contains active,new,reopen,after this i need to get the count of unique host names in C3..
for the cell C4
n selcting buisness,drop down buisness has to match offcrse,then contains active,new,reopen,after this i need to get the count of unique host names in c2..
likwise for each cell the conditions are different,If u can give me a solution for 2 cells,then i will be able to do it for rest of the cells...unique part is where i am not able to get the soution,For specfic conditions i used to get count dirctly with the help of countifs..
In a result sheet just on changing buisness name,I need to get the count of Unique Host names based on conditions ,Nothng else i have to select in result sheet.
This is the link :https://drive.google.com/file/d/0B5hoRY28rrSFN1BYVEhjMzNEV2c/view?usp=sharing
I have excel sheet containing 1Lakhs of record ,with 40 columns,which contains blank records as well.The sheet which i have sent is just a out view of the requirement
In a result sheet,i have a drop down,on changing a buisness name, the data has to get updated in each cell based on the criteria,for each cell conditions are differnt
say,first sheet of my data has buisness name in 3rd column-china,India,US etc,5th column contains status-active,new,reopen and 13th column contains-windows,unix(multiple windows and unix with difrnt names,ex-windows123 etc),
9th column contains host names (with lot of repetations in it)
say example for any cell :
for the cell c3 of a result sheet : on selcting buisness,drop down buisness has to match offcrse,then condtion is contains all windows(*win*),then contains active,new,reopen,after this i need to get the count of unique host names in C3..
for the cell C4
n selcting buisness,drop down buisness has to match offcrse,then contains active,new,reopen,after this i need to get the count of unique host names in c2..likwise for each cell the conditions are different,If u can give me a solution for 2 cells,then i will be able to do it for rest of the cells...unique part is where i am not able to get the soution,For specfic conditions i used to get count dirctly with the help of countifs..
In a result sheet just on changing buisness name,I need to get the count of Unique Host names based on conditions ,Nothng else i have to select in result sheet.
This is the link :https://drive.google.com/file/d/0B5hoRY28rrSFN1BYVEhjMzNEV2c/view?usp=sharing
