Search results

Hi There, I'm using excel 2016 version. All 3 sheets are in the same workbook. regards Prakash S

Hi There, Hope this finds you well! I have 3 excel sheets with each containing around 6 lakh rows (the maximum row that excel can have is 1048576). How can I arrive at one pivot consolidating data from all 3 sheets. Thanks in advance. Regards Prakash

Hi Chihiro, This is awesome :) Regards SP

Hi, Thanks for your resolution. This formula doesn't work on columns A3 & A4. Regards SP

Hi Deepak, Below is the sample of data workings. I need to arrive total experience from the career start & end date. Pls refer the img attached for better understanding. Employee Career Start Date Career End Date Total experience (in months) 1 02.08.1988 08.06.1997 2 01.05.1995 28.06.1998 3...

Hi there, One of the system generated excel has given me an date column as dd.mm.yyyy(i.e 01.01.2001). My objective is to find the total experience of employees out of 2 columns with similar date format. Could someone help me on this. Thanks in advance. Regards SP

Noted sir, thanks a lot. Is it possible to lock the cells, once after entering data? Kindly suggest on this. Prakash S

Sir, I used to maintain an excel book of records, in which previous month's data are saved. I want to ensure that, a data should remain unaltered after its entry in the cell(i.e) once after the data entery, the cell should be locked/uneditable. Someone kindly suggest on this pls. Regards...

Sir, Greetings of the day! I have a clarification in copying only the values in an excel file, (without opening that) to another excel file. Eg. I have uploaded 3 files viz. Salary, Bonus and Incentive. In all the 3 files, colum B is with same values (i.e input parameters). Each of the Excel...

Dear Mr.Narayan. Thanks for ur instant supports. I am willing to use form control option buttons for similar case. Looking for ur support in this regard. I have mailed the document to U, with details. Prakash S

Sir, Thanks a lot. Prakash

Sir, I need one more small clarification. Can I assume an text value in cells based on the selection made in the above case. Example: Selecting Option1 in the second question should display "Option1 selected" in a cell A1 and vice versa. Pls help on this. Prakash S

Dear Mr.Narayan, Thanks a million, for ur support Prakash

Mr.Deb, thanks a lot. My clarification is; how to disable the option buttons of question2 and question3 in the case, if option NO is selected in question1. Prakash

Sir, I have send the file to the email u mentioned. pls help on this. Prakash

Sir, Those websites are blocked in my server. Kindly suggest me an email, so that I can send my file to ur good-self pls. Prakash S

Dear Mr.Suresh. Thanks for ur propmt and quick reply. I need some more clarification on this. I want u to view my sample file and I need the following clarifications: 1) I am unable to select more than 1 option button in the entire sheet (I want to select 1 option button in one group(i.e in...

Sir, Good evening. I am designing a survey questionnaire thro' Excel 2007, in which option buttons are used for selecting an option from list of options (ActiveX controls in excel 2007). I want particular option buttons to be disabled for selection, if one particular option button is selected...