Search results

Got the answer. Following is general formula =SUMPRODUCT((1/COUNTIF($E$4:$AM$4,$E$4:$AM$4&""))*($E6:$AM6="Y"))

For ID 1 (column B is ID column. ) there are 6 IDs. Calculation is required to be done for all 6 IDs. Row 6 to Row 11. Column C contains manual calculation for all 6 rows. Calculation will be done based on Row 4 and Respective ID row ( 6 to 11). There can be one or more cells in row 4 having...

Hello Helpers, Kindly refer attached sample file. Row 4 contains subject name. Row 5 contains teacher name. Same Subject name may appear more than once as the subject may be shared by multiple teachers. Row 6 to row 11 contains student data (there can be more rows of student data). Column B...

Hi I have attached file. Sorry for inconvinience

I even wonder why my file size is so big while I have only test data in it

Hello Helpers, I want to count total no. of entries from a tabular data based on multiple criteria. I tried many formula like countif, sumproduct but it is not working. I have an excel file containing total 5 sheets. Original_data, Attendance_data, register, temp and final. Original_data...

It worked. Thank you so much sir for your help and explanation. Thank you again.

Sir, total time column is based on subtraction of To minus From column. And I checked the format. It is not text. It is in hh:mm format. In the data sheet, it calculates the time difference correctly. But in pivot table for few entries correct answer showing and for few entries wrong answer. I...

Sir, I copied pivot table suggested by p45cal and applied on my actual data. Last column is sum of total time column. It gives wired answer for some rows. Say for example, 17-06-2024 - 9:40 to 10:30 it gives 00:50 which is correct. But for 24-06-2024, 27-06-2024, 28-06-2024 and 01-07-2024 -...

Thank you for your help. I followed your steps. Everything works fine but when I am adding from and to column, it is not preserving the format in which I have entered the data. It attach AM or PM with time. Kindly suggest how to preserve time format as per original data in pivot table. Also it...

I explored the method of creating pivot table and I tried creating pivot table but I am not getting format like you have created. First, when I add head column in pivot table it shows the column label as "Row labels". Next when I add the column date2, from, to and topic, it shows them in the...

Not able to use power query. Any suggestion? Formula based solution or VBA code is preferred for my problem.

Excel 2010. Also total time of each head is missing

Hello helpers, I have one excel file containing 2 sheets - Data and Report. Data sheet has multiple rows having date wise tasks performed by one teacher. Each task is included under some heads (section) like exam, activity, seminar etc. Teacher will keep on adding data in rows date wise. There...

Thank you so much. I changed settings and it works fine now. Thanks again.

Hi Helpers, I am entering dates in dd/mm/yyyy format in column B. Format of this column is text. I am using text function to display day in column C. So, far it was working perfectly. But today, when I entered date 02/06/2024, it has started showing TUE in place of SUN. I found the reason...

got the solution. uploading here. hope it helps someone.

Hi Helpers. I have an excel sheet to get faculty wise timetable (Monday to Saturday). In this sheet, I enter faculty code and based on this short code, data will be filled in the table. I can then save this excel sheet as pdf and give it to respective faculty. But this is time consuming because...

Thank you for your help. I tried and got solution for point 2 and 3. Thank you again.

Dear Helpers, I have used following array formula for calculation in my excel sheet and it works fine. cell e3 has formula {=IF($B3<>"",IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$101:$A$120&"'!$b$127:$b$132"),$B3))>0,E$2,""),"")} cell f3 has formula...

Thank you so much helper. It worked perfectly. Thanks again.

>>> How many times have to give same note? <<< >>> use code - tags <<< Application.CopyObjectsWithCells = False 'copy your sheet ActiveSheet.Copy Application.CopyObjectsWithCells = True 'reset With this lines of code, my 2 shape button and one picture image will not be copied in new...

I have written below code to copy current worksheet to another workbook at desired location. This VBA code works perfectly. My current worksheet has 2 buttons and one image. I have used Application.CopyObjectsWithCells = False and Application.CopyObjectsWithCells = True for not copying objects...