Search results

I have two sample tables table-1 and table-2 on sheet1 (sample file attached). Table-1 a4 to c6 and table2 a10 to c12. I want to combine two tables in single column and blank cells are to be removed in output. I have 4 solutions for creating seperate list for table-1 and table-2. 3 solutions...

Solution worked perfectly for normal situation. But if a particular task is alloted n times and done < or > n times then what to do? For example, for a particular worker task B5 is alloted say 2 times in slot-1 and slot-4. Situation-1: task b5 done by the worker say 1 time in slot-2 so either...

OWESOME solution helpers. last thing, if a particular task is alloted n times and done < or > n times then what to do? For example, for a particular worker task B5 is alloted say 2 times and done 1 or 3 or 5 times, then how to get them in not done table if done lesser number of times and how to...

Well your excel file worked perfectly. When I tried to replace named range with actual cell address range then it is not giving accurate anser for "work not done" table. I think I have done some silly mistake but not able to find it out. I am attaching my sheet with array formula given by you...

there are 2 sheets in my excel file - data and report. Data sheet contains 2 tables - work alloted (k2:s8) and work done (a2:i8). Both tables has same format. Work alloted table contains worker id, worker initial and 7 slots. Each row mentions id, short name of worker and different tasks...

Sorry for this but I felt that my old question was little bit lengthy and confusing. So I made it shorter and clear. Also I observerd that many viewd my question but no reply due to confusion. That's the only reason. Sorry for inconvinience.

I have written following VBA code to repaint borders for my table. I have also added small testing code to apply conditional formatting on cell B11 and B12 based on value of B84. If value of B84=1 then I want to fill yellow color in B11 and B12. But it is not working. Private Sub...

Hi Helpers, I have prepared my college timetable in excel and I have attached sample sheet here. My file contains 2 sheets - timetable and formula. I am pasting daily timetable in "timetable" sheet. There are 14 classes. 2 classes are hidden as no students are there. Now, I applied 3...

I have an excel file with data in a table. There are some cells with value and some cells are empty. Whenever I am trying to drag the data one cell to another, it shows me a dialog box "Do you want to replace the contents of the destination cells?" Well, I want to deal with this issue. When the...

Thanks. I created one button and assigned macro to it. Now it works. Thanks again. But just few questions: 1. After running a macro, the day sheet from which data is copied, shows the table marked in a copy status. I found the solution to add "Application.CutCopyMode = False". Is it ok? It...

Well, I received your reply. I downloaded updated excel file. but when i am trying to change day from combo box to monday or tuesday, the content on tt sheet does not change. Code doesn't run automatically on changing day. Help.

Hi Helpers, I have a excel file table testing with 3 worksheets - tt, mon and tue All worksheet has same table format. Now tt sheet's table is empty. I have created mon and tue sheets with data in table. As it is a sample, I have two sheets otherwise there will be 6 sheets for 6 days. I want...

Thanks a lot Luke M. Working perfectly. Thanks again.

I don't know whether I can write here to you directly or not. But want to say thank you for your help. But still a small problem is there. I have explained problem in same post. Can you please help?

Well a small problem arised Luke M. If I type YP in a1 column of s1 sheet, then it gives me wrong output. For slot 1 - YP value will be searched from table on s2 sheet - a1 to L7. YP is not found. So it must display blank in b3 and b4. For slot 2 - YP value will be searched from table on s2...

Thanks. It worked.

I have an excel file with 2 sheets - s1 and s2. In s1 shhet I am entering a value in a1 cell for e.g. HM I have a table on s1 sheet from a3 to i6. a3 contains value 1 i.e. slot no. 1 and a5 contains value 2 means slot no. 2. I want values FA and 12 in cells B3 and B4 respectively. I want...

Hi Helpers, I have an excel sheet with around 50 rows containing my students data like roll number, name and other information. Now column C, F, I and L contains task number assigned to the students. Number of tasks per day will be equal to number of students. Requirement is no task must be...

How to find time difference in no. of hours and minutes by subtracting two cells containing two time values? For e.g. 11.30 and 12.00 answer is : 0 and 30 (0 hour and 30 min) 10.15 and 11.30 answer is: 1 and 15 (1 hour and 15 min) 1.50 and 2.05 answer is: 0...

How can I close the thread to indicate other users that I got the correct solution for my thread.

Sir, I used indirect function. And it worked. =COUNTIF(INDIRECT("C2"):INDIRECT("G7"),I2) Also I got reply from one member bosco_yip. His solution also worked perfectly. =COUNTIF(OFFSET($A$1,1,2,6,5),I2) Now I am trying to keep table on sheet b and calculation on sheet a. For that I am trying...

Thanks a lot. It worked.

Now, dragging a2:g2 to outside table say a9:g9 changes the range and gives incorrect calculation in j column.

Sir, I am uploading file once again. If I drag the data a2:g2 to say for example a9:g9, then it is not changing the range of countif. But If I drag the data a7:g7 to say for example a9:g9, then it is changing the range of countif. Is there any way to prevent this? I mean dragging data out of...

I have used $ in formula madam.