Search results

Thank you so much for your help. I really appreciate you help and support. Thank you once again.

I really appreciate your efforts. But my revised sheet is in perfectly working condition as per my requirements except only one thing. When my pdf is generated, it just have values fetched from duty sheet. My pdf format must be as per the individual_duty sheet. Only that thing is missing...

I found the solution of generating single pdf in place of multiple pdf. But the display format of my Individual_Duty sheet is not preserved in my output pdf. Refer my revised excel file.

There can be one slot for some days. There can be 2 slot for some days. These data will be as per the duty_list sheet. This sheet is manual entry by super visor. List sheet is also manual entered by supervisor. Do only the duty list's values which are 1 show in ... Individual_Duty-sheet? Yes...

Hello Helpers, I have an excel file which contains 3 sheets - list, duty_list and individual_duty. list sheet contains serial no., code and name of employees. (column A, B and C). This sheet contains a button - Generate slips. This sheet contains a table F3 to I9. It contains code of...

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