# Archive List for June 2017

## Text search (including ~), compare, count (length, cell number)

Search for specific text/FIND, SEARCH =FIND(find_text, within_text, [start_num]) [find_text] = Identify text to search for. [within_text] = Identify search range. [start_num] = Not obligatory. Select location of letter (character) implying the beginning of search. If nothing is written here, it will search from the 1st letter. Definition of function A function to search for a・・・

## Functions that combine, extract・divide, and replace texts

Combine texts together/’&’, CONCATENATE To combine words/texts, we use the following formula, function. =text1 & text2 & [text3]… [text1] = Identify 1st word to combine. [text2] = Identify 2nd word to combine. Definition of formula A formula to combine specified words. EXCEL version Excel2003 ・ Excel2007 ・ Excel2010 ・ Excel2013・ Excel2016 =CONCATENATE(text1, text2, [text3]…) [text1]・・・

## INDEX, MATCH function/Finding the value through conditions in rows and columns

Extract value where the row, column intersects (INDEX, MATCH function) As data in Excel can be large, it is difficult and time consuming for us to find the cell or value wanted. There are 2 functions that help us extract the information we need using the row, column, or heading of the table as reference. =INDEX(array, row_num, [column_num]) [array]・・・

## Find the sum, upon multiple conditions/not ・or condition, wildcard

Calculating the sum/SUM, SUBTOTAL, sum of multiple columns To calculate the sum of numbers in cells, we can use the SUM function and the SUBTOTAL function. =SUM(number1, [number2…]) [number1] = Select cell range to find the sum for. [number2] = Not obligatory. Select when there is another cell range to find the sum for. Definition・・・

## Change outcome based on one and multiple conditions/IF function

Setting up conditions to change outcome/IF function To change the outcome or result of data according to certain conditions like ‘If ○○, then A, if not ○○, B’, we use the following function. =ＩF(logical_test, [value_if_true], [value_if_false]) [logical_test] = Input formula describing the condition. [value_if_true] = Input result when the [logical_test] is ‘TRUE’. [value_if_false] = Input・・・

## Counting/Multiple conditions, not empty, duplication, words etc.

Counting the number of data To count the number of cells in an Excel data, we use the following function. =COUNT(range) [range] = Select the corresponding range in calculating cell number. Definition of function A function to count the number of cells of a number EXCEL version Excel2003 ・ Excel2007 ・ Excel2010 ・ Excel2013・ Excel2016・・・

## Maximum, minimum values/Conditional/MAX, MIN functions etc.

Find the maximum, minimum value (MAX, MIN function) To find the maximum (max.), minimum (min.) value from a specific data in Excel, we use the following function. =MAX(number 1,[number 2],…) [number 1] = Select cell range or the first number in finding the max. value. [number 2] = Select cell range or the second number in・・・