• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    help adjust code show the data on listbox

    Hi Marc , The code is not mine. All I did was change the last parameter of the Search function from 0 , which is an invalid value , to 1. Narayan
  2. N

    help adjust code show the data on listbox

    Hi , See whether the problem is still present in this uploaded file. Narayan
  3. N

    help adjust code show the data on listbox

    Hi , Why don't you try it first ? Narayan
  4. N

    help adjust code show the data on listbox

    Hi , Did you try this ? Narayan
  5. N

    Putting a colour in each row?

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

    Putting a colour in each row?

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

    Formulas Not Working for Different Years

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

    Putting a colour in each row?

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

    VBA / Excel sorts text with numbers in wrong order

    Hi , Use the DataOption setting : DataOption:=xlSortNormal Narayan
  10. N

    help adjust code show the data on listbox

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

    animated infographics

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

    Putting a colour in each row?

    Hi , Is this what you want ? Narayan
  13. N

    Using array formula to help with a networkdays holidays issue

    Hi , See the attached file. Narayan
  14. N

    I need your help to build a function in Excel!

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

    Using array formula to help with a networkdays holidays issue

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

    I need your help to build a function in Excel!

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

    I need your help to build a function in Excel!

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

    I need your help to build a function in Excel!

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

    Using array formula to help with a networkdays holidays issue

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

    I need your help to build a function in Excel!

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

    I need your help to build a function in Excel!

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

    Calculating no of events

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

    Calculating no of events

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

    Calculated field and calculated item into a pivot table

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

    HELP, Summary formula

    Hi , Another method. Narayan
Top