58
CHAPTER 3:
HancomMobileSheet
•
Select Customize
The Customize menu is composed of two
options. The 'Top 10 Filter' will select
requested data upper values to lower
values. The second option "Customize"
allows the user to set the conditions.
For example, If you have selected item,
up, 10, this means that 10 items will be
selected starting from the larger values.
In the case of the Top 10, character cells
will not be apparent. When "Percentage"
is selected, the cell values within the top
10% among the total numeric values will
be selected and displayed.
-
User Defined : Select "User Defined" in the "Autofilter" List and the
following dialog box will appear.
The data matching the value and condition in the quantity field will be
extracted.
- The definition of the condition list is as the following.
= Extracts data that equals the selected data value
<> Extracts data unequal to the selected data.
< Extracts data smaller than the selected data.
> Extracts data larger than the selected data.
<= Extracts data smaller or equal to the selected data.
>= Extracts data larger or equal to the selected data.
start Char Extracts the data starting with the input character.
excluded start Char Extracts data excluding the data starting with the input data.
end char Extracts the data that ends with the input character.
excluded end Char Extracts data excluding the data where the input character comes at the end.
included char Extracts the data including the input character.
excluded char Extracts only the data not including the input character.
The character mentioned above refers not only to one letter, but also to text
strings. Select "OR" and the data values that match more than one condition
will be selected. When "AND" is selected, only data matching the first and
second conditions will be extracted.
To Next Page
Loading...
Need help?
General
