Skip to main content

Posts

Showing posts from October, 2013

Responsive Text Size

HTML Design: Responsive Text Size Tested: Bootstrap Framework 1vw = 1% of viewport width 1vh = 1% of viewport height 1vmin = 1vw or 1vh, if smaller  1vmax = 1vw or 1vh, if larger  Example:   h1 { font-size: 5.9vw; }  h2 { font-size: 3.0vh; }  p { font-size: 2vmin; }

Unable to setup Default Printer, error message: 0X00000709

Unable to setup Default Printer, error message: 0X00000709 Open Registry Editor Goto  HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Right-Click Windows->Permission Checked Allow Full Control Delete Device Key Restart Computer

Search Value from the list (Excel VLOOKUP Function)

Excel VLOOKUP Function Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Scenario: You want to check if a certain word exists from the list and get the corresponding  row value. Procedure: Select the array of data.In below image I selected  A1 to C4 .   So, if you want to get the address of Toshiba. we can do it like this. =VLOOKUP("Toshiba",A1:C4,2,FALSE) Note: lookup_value is not case sensitive. if you want to get the price of Toshiba. we can do it like this. =VLOOKUP("Toshiba",A1:C4,3,FALSE) We only change the col_index_num into 3.