Skip to main content

Posts

Showing posts from May, 2025

Find duplicate or unique values in a column using Excel formula

Finding duplicate values in Excel can easily be done using Excel Formula. Manually find duplicate values in a single column with 100 or more rows is tedious and prone to errors. Thankfully, Excel formula can do this task with precision. Assuming, the data or values has no trailing white spaces. Trailing white spaces, will cause problem because even though its whitespace still treated as a character by Excel. Data must be sanitized before comparing. Excel fomula to find Unique values or duplicates can be done using the formula below. =IF(COUNTIF($A$1:$A$13,A1)>1, "Duplicate","Unique") $A$1:$A$13 ==> Range to check duplicate or unique values, adjust the range as required A1 ==> Check duplicate values at this row or start comparing at A1 >1 ==> If there is a duplicate or a similar value more than 1, if the value is 2. Then the 3rd value that is similar to the other two will be identified as duplicate "Duplicate","Unique...

AWS view instance store volume - ephemeral storage

Instance store volume in AWS is not like the EBS Volume (ebs - elastic block storage). The main difference between EBS and instance store volume, is EBS data or its contents will persist after reboot or shutdown. And for EBS volume you can take snapshot, create image do a backup or simply attached the EBS volume to another instance. Where as for instance store volume, which is physically attached to the host. It can't be search or can't be found on the "Volume" navigation pane. Thus, snapshot or taking backup is not possible. Instance store volume is some sort of a RAMDisk, in which it is indeed process data quite fast. However, if the instance is rebooted or shutdown all data is gone. Ideal only for dynamic data processing, that once data is process on the fly; data can be discarded or not needed anymore. How to view or check whether the instance you have got instance store volume? In a Linux instance, type the command below on a Terminal window: lsblk -o +...

Convert column data as single row with comma - excel

Converting column values to a single row separated by commas, is needed by some applications to iterate thru the values. Some automation tools, require such format. Example image below, shows A1 to A35 a list of Server Name. 35 rows is just an example or a demonstration it can easily become hundred of rows or more depending on the actual servers or data in the environment. To convert the rows to a single row separated by a comma, can easily be done using Excel. Excel 2019 and above is needed for the TEXTJOIN formula. Example image below, shows how to convert the Column values to a single row with comma as a delimiter. Formula is: =TEXTJOIN(",", TRUE, A1:A35) "," means separate the data with a comma "TRUE" means don't include empty spaces A1:A35 the range of values that will be converted to a single row with comma as a delimiter Image below shows the output after the formula process the data. Once you have the data as desired...