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.

Comments

Post a Comment

Popular posts from this blog

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...
Read more