Recent content by jb

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