Posts

Fill The Blank

-
Image
The request was to create analysis of a thousand data that's exported directly from a web/program. This kind of data use to be named as Raw Data. Data Reporting,. The process will be able to start when the data has been tidied. Tidy mean that all row or column has the complete description or identification of each information in the cell, like a database should be. So there's no header for identification. Example as below; To process this data, then we need to complete the detail of each blank cell with the category or the header mention. Then we will use IF. Logic formula to complete will be; The logic was; if the header cell is not blank, then we will call its description to fill in the cell. But if its blank, we will call the description above. =IF(A3<>0,A3,B2) The first started cell should be copy paste first, then start with the formula and drag it down. Then the result will be as below; Then you now can start analysis the data for reporting.
Post a Comment
Read more

Advanced Filter with Formula

-
Image
The request was to show all name of the doctor that match from 3 category of the filter. Category 1 : the name of insurance card that will be used. Category 2 : the age of the patient. Category 3 : the type specialty doctor required. Formula will be used is "FIND", "ISNUMBER" and "FILTER". 1. The idea was to get a "number" value if all category is match in doctor list, so will use "find". 2. As the match result should comes in number, all we need to check is whether its a number or not, so will use "isnumber" and will gives result of "True" or "False" 3. And the last, use filter to show up all doctor name that has "True" as a result. Sample in a simple way, let's assume the Age category has been divided to (Child, Teen, and Oldster) Sheet Filter And list of the sample doctor is as below; Sheet List Doctor and now, lets test the category from the  sheet filter to each doctor, the formula should...
Post a Comment
Read more

Look up Formula

-
There was this request to teach or explain how to use vlookup in 30 minutes,... oh well,... the time will be depend on how concentrate or focused you are,... Explanation: In the Excel Formula, there's 3 type of look up, the "vlook up", "lookup" and "hlook up". Through, all have the same function. it is to "look up" for something you want to "look for".   The V or H is mean for the direction of the data you want to "look up". If the data you want to look is in column or (Vertical) then use Vlookup and if the data is in row then use (Hlookup). Example, you want to look for the price of "shoes AR" in the list of "shoe price list" in other sheet. The "look up" data are in column, when all shoes name are detailed in Column A, and the price is on Column B. In manual way, you will need to find the name "shoes AR" in the "shoe price list" first, and then you will figure out the pri...
Post a Comment
Read more

Greetings

-
 Make wish,. "Secret",... as some says  "if you tell a wish, it wont comes true,.."  .... a dreaaam,,, is, a wish,... haha... nope2,.. not the song. anyway let my wish for myself. and for the Greeting,... the best way of learning is by teaching someone,... why? well, their question will become our knowledge. in that in mind,... let the blog begin.
Post a Comment
Read more