Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Many professionals use Google Sheets to keep a record of time and date for HR and other purposes. While manually entering the values can take a lot of time, you can use the in-built features in Google Sheets to combine values in one cell. With this tutorial, we tell you how to combine date and time values in separate columns into just one with 2 very easy techniques. These methods provide flexibility and convenience, enabling you to merge date and time information into a single column quickly. Follow the steps to learn a new skill today! ... Read More
In Microsoft Excel, combining the contents of multiple cells into a single cell with separators like spaces, commas, or other characters can be a valuable data manipulation and analysis technique. This helps the user to create concatenated strings that bring together information from different cells in a structured manner. In this tutorial, we will explore two methods—the CONCATENATE function and the ampersand (&) operator—to combine cells with various separators. Using a simple example, we demonstrate how to combine multiple cells into one cell with space, commas, and other separators. Method 1: Using the CONCATENATE Function The ... Read More
A useful technique for organising and analysing data scattered in different columns is to combine them to just one column. Whether you want to merge related information or create a consolidated view, Google Sheets provides powerful tools to accomplish this task efficiently. In this tutorial we will explore two easy methods to combine multiple columns into one single column. Method 1: Using FILTER and LEN Formula You can use the combination of Google Sheets FILTER and LEN formula to return a filtered version of your data set with the specific condition of combining them in just one column. ... Read More
One of the key content inputs in Excel is strings. Strings refer to a sequence of characters or text like letters, numbers, symbols, and spaces. An Excel string can also represent a name, address, description, or any other textual information. Excel treats it as alphanumeric data rather than just numerical data, enabling it to perform manipulations and operations as the user requires. Looking for a particular text or word in Excel is very easy if you know how to use the right function and where. With the help of 2 examples, we demonstrate how to use the SEARCH and ... Read More
If you enter data from multiple sources in your Excel worksheet, you are likely to enter duplicate information. These duplicate entries of data sets would need to be consolidated in order to rectify the error. In a small dataset, duplicate values are easier to spot and correct; however, in a large dataset, the manual work becomes overwhelming and more prone to human error. Microsoft Excel has smart features which let you identify and sum the values of duplicate rows in a table. Read this easy tutorial to find out how to combine duplicate rows and add the values ... Read More
The article describes a method to calculate the closest power of 2 for the frequency of each digit in a given number. The term "frequencies" refers to the count of occurrences of each unique digit in the number. Problem Statement Determine the occurrence count of each digit in a positive integer N. Then, for each digit, find the nearest power of 2 to its frequency. If there are two nearest powers of 2 for any frequency, print the larger one. Example Input n = 677755 Output 5 -> 2 6 -> 1 7 -> 4 ... Read More
The following article discusses an approach to count the maximum occurrences of a string s2 in another string s1 after they have been concatenated N1 and N2 times respectively. This is an interesting type of pattern searching problem. In this article we have employed a relatively intuitive solution approach. Problem Statement The task is to determine the maximum number of non-overlapping occurrences of string s2 within string s1. The strings are concatenated multiple times: s1 is repeated n1 times, and s2 is repeated n2 times. Example Input s1 = “abc”, s2 = “ac”, n1 = 4, n2 ... Read More
A string is a period of K if and only if it repeats itself every K characters. For example, the string "abcabcabc" is a period of 3, because it repeats itself every 3 characters. The string "abcabc?abc" is not a period of 3, because the character '?' does not repeat itself every 3 characters. Problem Statement Given a string "str" containing N lowercase characters and a positive integer K, the objective is to replace every occurrence of the character '?' within the string "str" with a lowercase alphabet such that the resulting string forms a period of length ... Read More
Lexicographic ordering refers to a method of comparing sequences of elements, akin to the ordering of words in a dictionary. The comparison process involves evaluating the first element of each sequence. If the first element of the first sequence is considered smaller than the first element of the second sequence, the first sequence is considered lexicographically less than the second sequence. Conversely, if the first element of the first sequence is deemed larger than the first element of the second sequence, the first sequence is lexicographically greater than the second sequence. Problem Statement The objective is to generate ... Read More
Any number larger than 1 is said to be prime if it cannot be written as the product of two smaller natural numbers except 1 and the number itself. For instance, 5 is prime since its only product forms, 1 5 and 5 1, both involve 5. Primes play a crucial role in number theory as stated by the prime number theorem, which asserts that any natural number greater than 1 is either a prime itself or can be expressed as a unique product of prime numbers. This theorem highlights the significance of prime numbers in the realm of mathematics. ... Read More