Search results

Hi , Did you try this ? Narayan

Hi , On the Home tab , click on the Conditional Formatting button and select New Rule. Click on the last option : Use a formula to determine which cells to format. The formula entry box will be displayed beneath the label : Format values where this formula is true: Narayan

Hi , If there are no blank cells in your range , you can select the entire data range and format it for a particular color. Then have only one CF rule for the second color. You cannot have two colors with only one CF rule. If you want to have both colors using CF rules , then you need two CF...

Hi , I think there is a problem with the forum ; I am facing a similar problem when trying to upload a file. Just wait till the problem is resolved. Narayan

Hi , The reference in the Conditional Formatting formula has to be relative , and it has to be the top left cell in the range. Thus , if your data range is J17:M33 , select this range first. In the CF formula box , enter the formula =J17 = "Sun" , and select the desired color. Add a second...

Hi , Use the DataOption setting : DataOption:=xlSortNormal Narayan

Hi , Regarding your problem of not being able to upload your workbook , this forum has a file size limitation ; only files which are less than 1 MB in size can be uploaded. To upload larger files , you will have to use some public file sharing service such as DropBox. However , before you...

Hi , This link shows the chart in the OP , I think : http://www.stampamedia.net/it/notizie/altro/il-mercato-dei-quotidiani-in-italia-l-inchiesta-del-poligrafico-infografica-animata- https://public.flourish.studio/visualisation/966147/ Narayan

Hi , Is this what you want ? Narayan

Hi , See the attached file. Narayan

Hi , See if this is correct. https://www.dropbox.com/s/oi6pukhm4zdvn20/SampleData%20%281%29.xlsx?dl=0 Narayan

Hi , Are you looking for something like this ? What happens in cases where the employee has taken half the day off ? Narayan

Hi , If you confirm that these intervals have been marked correctly , then can we take the first interval and discuss what is required ? The first interval is the period from 06.11.19 00:00 to 06.11.19 01:59. In this interval if we see how many times the value in column B was less than...

Hi , I am uploading a part of your full workbook , with only the relevant 4 columns of data , sorted in ascending order on the date and time. I have highlighted the start and end of each 120 minute interval ; can you confirm that this is correct ? Narayan

Hi , Where is the attachment please ? I downloaded the most recent upload , and the data appears to be in descending order , from the latest date and time downwards to the earliest date and time. Anyway , can I sort the data in ascending order , from the earliest date and time to the latest...

Hi , I am not clear on what is required. First , what is the table on the tab named Off days ? Which employee does it refer to ? Second , you have 31 staff members ; will you have 31 tabs for them , one for each staff member ? Third , you have created a tab for employee Sam ; will what ever...

Hi , Thanks for the upload. I assume that we need to look at only columns A , B , C and D. First , the times in column A are in descending order ; can we sort the data so that these times are in ascending order ? Narayan

Hi , Can you upload a workbook which has enough data , say a few hundred rows , so that the time span of 120 minutes and more is covered ? Narayan

Hi , Correct that to this : =IF(A2 = 0, 1, 0) + SUMPRODUCT(($A$2:$A$20=1) * ($A$3:$A$21=0)) This is to take care if the range starts with a 0. Narayan

Hi , Try this : =SUMPRODUCT(($A$2:$A$20=1) * ($A$3:$A$21=0)) Narayan

Hi , No , it does not mean that. What it means is that if you post your question in more than one forum , then post links to all the forums where you have posted your question in every forum. Thus , if you have posted your question in forums A , B and C , in forum A where you have posted your...

Hi , Another method. Narayan

Hi , Matrix multiplication is mathematics , and Excel is only implementing what the mathematics specifies. Mathematics specifies that in matrix multiplication , when a matrix m x n is multiplied by another matrix a x b , the matrix multiplication is possible only if n and a are the same. If n...

Hi , What is the logic to output two values based on the input data ? Which input data will result in one output value , and which input data will result in the other output value ? Narayan