Search results

Hi xlstime, Your solution is perfect. Thanks a lot.

Hi Experts, I have an excel file consisting of many subject-wise sheets having marks of students of different class. Each sheet is given name based on subject. Each sheet may have different number of students but format of each sheet is same. First column is roll number and second column is...

Thank you all for your help. Thanks a lot.

I have an excel file which contains roll number, name, grade of semester-III, grade of semester-IV and average of 49 students in column A to E. Column G and H contains list of 57 students out of which 49 students are same. But roll numbers are different. Now in new 57 students list, I want...

Hi Hui and Narayank991, Answer-1 There will be maximum 16 cells out of which at a time randomly maximum 8 cells will be having values. It means that there will be maximum 8 values in a set. They can be at any 8 or less positions in range of 16 cells. Answer-2 There is no limit for variation...

Hui sir, according to your solution, 11, 6, 9, 15, 8, 17 becomes 14,11,13,16,12,17 I want to increase smaller values. so, 11, 6, 9, 15, 8, 17 should become 13, 12, 13, 15, 12, 17

Sorry helpers, I think I failed in explaining my problem. Sorry once again for that. Now I am uploading a file. Look at 2nd, 4th and 6th row with title original, adjustment and final. Original titled row shows actual data. Adjustment row B4 to G4 shows values to be added in B2 to G2 so that...

Sorry helpers, I think I failed in explaining my problem. Sorry once again for that. Now I am uploading a file. Look at 2nd, 4th and 6th row with title original, adjustment and final. Original titled row shows actual data. Adjustment row B4 to G4 shows values to be added in B2 to G2 so that...

Hi all, I have some values in 6 cell say a1 to f1. these values can be different. For e.g. 11 6 9 15 8 17 Now I want to add some number say 16 which is to be distributed in all the cells in such a way that all cell get almost same value. I want formula so that I will get...

Thanks Hui. Thanks a lot......... You don't know that what you have done for me. Thanks once again.

hi experts, i have two columns A and C with 100 entries in each. Column A represents score of odd statements of a questionnaire and Column C represents score of odd statements of a questionnaire. Column E is difference between column A and C. Column G is sum between column A and C. I have...

Hi experts, I have an excel sheet in which column A and B represents range of x. Column C and D represents range of y. For example A3 is 72 and B3 is 73. Means it is a range 72-73. Same way C3 is 100 and D3 is 109. Means it is a range 100-109. Data is given in column I and J. I want to...

I have an excel sheet which is a schedule sheet. This sheet has a table with almost 7 rows and 15 columns. Data in this table is copied manually from 7 different sheets named mon, tue.... upto sun depending upon current day. Schedule sheet contains a cell A5 which has date and next cell B5 is...

Thanks all. I got my error. Now it works.

I have one self updating table which is available in attached excel file with a yellow cell background. I want to know meaning of ROWS($A1:$A$1) used at end of formula. I have insert some rows before this calculation. Instead of of 5 to 49 rows now it is from 95 to 139. I have inserted some...

Thanks for reply. It worked. But I want to know meaning of ROWS($A1:$A$1) used at end of formula. I have insert some rows before this calculation. Instead of of 5 to 49 rows now it is from 95 to 139. I have inserted some column between B and C columns. Now C column went to Q column. I tried...

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