Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Maximize 0s to be flipped in a given Binary array such that there are at least K 0s between two 1s
A Binary Array is a special type of array that only contains the numbers 0 and 1. In this problem, we have given a binary array and integer K. Our task is to count the maximum number of 0’s that can be flipped to 1 in a given binary array such that there are at least K 0’s between two 1s. Sample Examples Input 1: arr[] = { 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0 }, K = 2 Output 1: yes Explanation The 3rd and 6th indexes of the above ...
Read MorePrint all Balanced Brackets Strings that can be formed by replacing wild card ‘?’
Balanced Brackets mean if we have a string of brackets then each open bracket has a corresponding close bracket and the pair of brackets is properly nested. The size of the string should be ab even number. In this problem we have given a string of the brackets that also contain the character ‘?’ and our task is to form every possible balanced bracket string by replacing the ‘?’ to appropriate brackets. In our given string only parentheses ‘(‘ and ‘)’ brackets are used. Sample Examples Input 1: str = “()(?)?” Output 1: ()(()) Explanation Only one balanced ...
Read MoreCheck if the end of the given Binary string can be reached by choosing the jump value in between the given range
A binary string is a string that contains only two different types of characters that are 0 and 1. We are given a binary string and two integers L and the R. We can make the jump of size between ‘L’ and ‘R’ length both inclusive and only from the index where the value of the string is ‘0’. We have to start from the Zeroth index and find out whether we can reach the last index or not. Sample Examples Input1: string str = “01001110010” int L = 2, R = 4 Output: Yes, we can reach the ...
Read MoreHow to insert numbers or rows for missing sequential number in Excel?
Inserting the number for the missing sequential number in Excel means that the user wants to complete the missing number in Excel by using the available Excel feature. This article will understand two basic ways to perform this task. The first example, guide the proper way to use VBA code to complete the missing sequence numbers in Excel. This example can be a little tedious as here, users need to learn the way to code and use proper code indentation to solve the task. Another example available in the sheet describes the method to use kutools, to fill up the ...
Read MoreHow to highlight/conditional formatting unique/duplicate values in Excel?
In Excel, conditional formatting is a feature that allows users to apply formatting to cells based on specific conditions or criteria. By using conditional formatting, the user can color, highlight, or format cells dynamically, that depends upon the values, formulas, or rules the user defines. Unique values are the ones that do not have any exact matching value in the Excel sheet. While the duplicate value is the one that has the same values available in the list. This article illustrates two common examples of the same. The first example allows the user to determine the duplicate value. In this ...
Read MoreHow to highlight/conditional formatting top n values in Excel
In Excel, conditional formatting is a feature that allows users to apply formatting to cells based on specific conditions or criteria. By using conditional formatting, the user can color, highlight, or format cells dynamically, that depends upon the values, formulas, or rules the user defines. This feature is useful for some data points, patterns, or trends in the Excel worksheets, this makes the data easier to interpret and analyze the data. Instead of manually scanning through cells or applying to format individually. This feature allows the user to automate the process and apply formatting dynamically as the data changes. Benefits ...
Read MoreHow to highlight/conditional formatting dates older than 30 days in Excel?
By using conditional formatting, the user can color, highlight, or format cells dynamically, that depends upon the values, formulas, or rules the user defines. This feature is useful for some data points, patterns, or trends in the Excel worksheets, this makes the data easier to interpret and analyze the data. Instead of manually scanning through cells or applying to format individually. This feature allows the user to automate the process and apply formatting dynamically as the data changes. In this article, users will learn the process of determining the number of dates older than 30 days in Excel. The ...
Read MoreHow to Import / Copy Data From Closed Workbook into Current Workbook?
Importing or copying data from a closed workbook into the current workbook is a valuable capability in Excel that allows you to extract and work with data from various sources. When seeking to collate details from numerous workbooks or access unavailable records, having an effective instrument is invaluable. With that in mind, this article explores various tactics for importing and copying data from closed workbooks into your current Excel file seamlessly. Whether your source files are open or closed, these methods empower you to transfer information efficiently. By utilizing these techniques, you can enhance your data manipulation and analysis capabilities ...
Read MoreHow to insert image control in Excel?
In Excel, adding an image control generally refers to the process of adding an interactive image to a user form or a worksheet. The image control allows users to interact with the image, such as clicking, viewing, zooming, or performing other actions based on its presence. In this article, the user will understand the process of inserting image control in the Excel sheet. This allows the user to insert any control to an image. For example, a macro can be assigned to the inserted image. So, whenever the user clicks on this image the macro will activate itself automatically, without ...
Read MoreHow to Insert file Name or Path into cell/header or Footer in Excel?
In this article, the user will understand the process of inserting a file name or path into the cell/header or footer. This article briefs two examples. Here, the first example allows the user to insert the file name, path, and complete details with the help of the formula in a stepwise manner, while the second example, allows the user to use the header or footer option, to perform the same task. All the guided steps are detailed and thorough. Refer to both examples to understand the working of the provided examples, and to master the process of inserting file name ...
Read More