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
Making zero array by decrementing pairs of adjacent
The problem statement includes making an array zero array by decrementing pairs of adjacent. The array will be given in the input and we can perform the operation on the array i.e. subtract 1 from ith and (i+1)th index where 0
Read MoreHoax Number
The problem statement includes checking if the given number N, which will be the user input, is a hoax number or not. A Hoax number is a composite number whose sum of digits of its distinct prime factors is equal to the sum of the digits of the composite number itself. Since 1 is not a prime number, we don’t consider 1 as a sum of digits of distinct prime numbers. If a prime number is a factor of the composite number more than once, it is just considered once while taking the sum of digits of prime factors. In ...
Read MoreHardy-Ramanujan Theorem
The Hardy−Ramanujan Theorem states that the number of distinct prime factors of any natural number N will be approximately equal to the value of $\mathrm{\log(\log N)}$ for most of the cases. For example, let’s consider N to be 1000. The number of distinct prime factors of 15 are 2 and 5 i.e. 2 distinct prime factors. The value of $\mathrm{\log_{e}(\log_{e}(1000))}$ is equal to 1.932 which is approximately equal to 2. The Hardy−Ramanujan theorem is proved in the above case. Since the theorem states that the number of distinct prime factors will be approximately equal to $\mathrm{\log(\log(N))}$ for most of ...
Read MoreGiven a Number N in Decimal Base, find Number of its Digits in any Base (base b)
The problem statement includes finding the number of digits in N when represented in any base b numeral system. Initially, N is given in the base−10 numeral system. In the problem, we will be provided with a positive integer N in the input which will be in the base−10 numeral system and a positive integer b greater than 1. Our task will be to find the number of digits when N is being represented in the base−b numeral system. Any number represented in any base number, every digit from right represents the number of times power of that base number ...
Read MoreCount Numbers formed by given two Digit with Sum having given Digits
The problem statement includes counting the numbers formed by the given two digits, x and y of size N with sum having given digits only i.e. x and y. We need to count the distinct numbers which can be formed by the digits, x and y which will be the user input of size N where N ranges from 1 to 10^6. The N will also be provided in the input. The numbers formed using the digits, x and y of size N must be such that the sum of digits of the numbers formed should have only digits ...
Read MoreHow to Look up the First Non-Zero Value and Return Corresponding Column Header in Excel?
In this article, users would easily look up the first non-zero value in a row and obtain the corresponding column header. One example is showcased in this article that facilitates efficient solutions for working with data in Excel. By using the combination of the INDEX and MATCH functions in Excel, the provided formula allows the user to determine the column header associated with the first non-zero value in a specific row. By adjusting the ranges to match the data, the user can apply this formula across multiple rows or ranges, helping the user to analyze and process data based on ...
Read MoreHow to Pull or Extract Characters from Right to Left in a Cell Until a Space is Reached in Excel?
Sometimes, in Excel the user wants to extract data for the provided task, the extraction will be from right to left. For example, if a cell contains data “Ana Ban” then the extracted string will be “Ban”. To demonstrate the formula used to accomplish this task will provide a simple example. All explanations are guided in a detailed stepwise manner. The first example guides the process of using the formula to perform the same task. Example 1: To pull or extract characters from right to left in a cell until a space is reached in excel by using the ...
Read MoreHow to Print Worksheets without Fill Color?
Printing worksheets without fill color in Excel ensures that the printed copies are clear and legible, without the distraction of background colors. Whether users have applied fill colors to cells or used conditional formatting, removing the fill color before printing can enhance the readability of the printed document. By following a few simple steps, the user can ensure that the available worksheets are printed without any background colors, allowing the data and content to take center stage. This helps maintain a professional and organized appearance when sharing or presenting your Excel worksheets in hard copy format. This explanation will allow ...
Read MoreHow to Print Worksheets without Blank Rows in Excel?
Worksheets without any blank rows mean an Excel sheet that does not contains any blank row. But while mapping any data to reality the same thing is not possible. So, it is better to remove the blank rows from Excel before printing the worksheets. The same task can be done in two ways, first method is to remove the blank rows, from the Excel sheet by using the VBA code, while the second method describes the process of using kutools to perform the same task. This article provides two general examples, to demonstrate the process of achieving the same task, ...
Read MoreHow to Print Worksheets with Displaying Formulas in Excel?
In Microsoft Excel, a formula can be defined as an expression that performs calculations, manipulates data, or returns a specific value based on the inputs provided. Formulas in Excel typically start with an equal sign (=) and can contain a combination of numbers, operators, functions, cell references, and constants. To understand more precisely consider the below given Excel formula elements: Numbers: these values can be directly written in a formula. An example includes any number such as 5, 1. 5, -3, etc. Operators: these can be defined as the mathematical symbols used to perform calculations. Examples include addition (+), ...
Read More