Recent content by jb

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