Search results

Hi experts, I want to create self updating data table. I have a worksheet with 4 columns with title - serial number, name, code concatenated with name, and sorted list. Sorted list is generated using formula and it is self updating when code attached with name in column C changes. I want to...

Thanks Somendra sir.

Thanks Deepakji for the clarification. I understood it. Thanks a lot.

Hi Somendra sir, I gone thru your solution. But if I change attendance data, then the pivot table is showing changes.

Hi Deepak, Your solution was perfect. Thanks for that. But I do not understand the role of helper column as it generates same value as percentage column. Can you plz tell me about it?

An excel sheet contains data of few employees. Column A contains employee number, column b contains name of employee. Column C contains present days of employees. Column D presents attendance percentage. Column C is updated at end of every month. Now a list is required to be prepared which will...

Hi all experts, I have a data file with 1140 rows and 5 columns namely sr. no, T (means type), S (means gender), A (means area) and score. T column has only 2 possible values - G or P S column has only 2 possible values - M or F A column has only 2 possible values - U or R Now, I want to...

Yes sir. This is actually I want. Thanks a lot sir.

Hi all experts, I have an excel sheet with 5 columns with title - serial number, T (means type having only 2 possible values: G and P), S (means gender having only 2 possible values: M and F), A ((means area having only 2 possible values: R and U) and Score. Now, I want to extract rows based on...

Hi all experts, I need to calculate t value and standard error of mean for 2-sample in excel. Unfortunately I do not have original data. But I do have sample size, mean and standard deviation for both the sample. Sample file attached.

Always eager to learn

Is it possible to have different colors in my bar chart with normal distribution curve? I tried but "vary colors by point" option is not shown in fill option of format data series option of graph in excel 2007. I do not want to paint manually by selecting each bar. This option is available if...

Is it possible to have different colors in my bar chart with normal distribution curve? I tried but "vary colors by point" option is not shown in fill option of format data series option of graph in excel 2007. This option is available in normal bar chart to have different colors for different...

hi all experts, I have drawn a bar char with single series. But the look of the chart is very boring. all bars are in blue colors. I found from net that there is an option called "vary color by point" in format data series - fill option. But in excel 2010, this option is missing. How to...

Hi all experts, I have applied normdist function of excel in my workbook. Calculation formula is same for some number of rows. But the first row shows value in E format while others show decimal values. I applied format painter also. But it is not working. Help me to get all values in decimal...