Archive List for June 2017

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

Basic Course

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

Basic Course

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]・・・

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

Basic Course

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

Basic Course

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. =IF(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.

Basic Course

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.

Basic Course

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・・・

To the top