Neil's Blogs

TUTORIAL FOR FILLING OF DATA IN E-VIDYA VAHINI FOR TEACHERS OF JUSCO SCHOOL, KADMA

Open Ms-Excel Move the cursor to the sheet name "Sheet1" or whatever you have renamed your sheet and right click, then click on view code. A new Visual Basic window will open. In the left corner double click on "This workbook" and type  or copy/paste the following codes in the blank space. Sub DelStrikethroughText()     Dim xRg As Range, xCell As Range     Dim xStr As String     Dim I As Long     On Error Resume Next     Set xRg = Application.InputBox("Please select range:", "KuTools For Excel", Selection.Address, , , , , 8)     If xRg Is Nothing Then Exit Sub     Application.ScreenUpdating = Fase         For Each xCell In xRg             If IsNumeric(xCell.Value) And xCell.Font.Strikethrough Then                 xCell.Value = ""             ElseIf Not IsNumeric(xCell.Value) The...

Open Excel Create three columns with following titles: 1. First Name 2. Last Name 3. Phone Number Fill your data row wise in the respective columns and then press Alt+F11 to enter the Visual Basic mode. In the left corner you will see This workbook under VBA Project (Your file name). Right click on This workbook - Move the cursor to Insert - Click Module A new window will appear, paste the following codes there: Private Sub Create_VCF()     'Open a File in Specific Path in Output or Append mode     Dim FileNum As Integer     Dim iRow As Double     iRow = 2     FileNum = FreeFile     OutFilePath = "D:\OutputVCF.VCF"     Open OutFilePath For Output As FileNum     'Loop through Excel Sheet each row and write it to VCF File     While VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) <> ""         LName = VBA.Trim(Sheets("Sheet1").Cells(iRow, 1))    ...

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, I'm looking to search column A for a value that matches C, and return the email address from column B in a new column (D). The current formula almost works, but instead of returning the email address where A matched C, it returns the email address from the same row. =IF(ISNA(INDEX(B:B,MATCH(C3,A:A,0))),"",INDEX(B:B,MATCH(C3,A:A,0))) This probably will solve the problem and also remove the  #N/A  result that would appear if you couldn't find a result due to its absence in your lookup list. Thanks,  Neil

How to install and run android apps on windows pc: Here I am illustrating all the 3 methods to run android apps on your windows pc Method 1: Bluestacks Bluestacks offers a free android app player for windows and mac  OS  to install and run android apps on pc. Most of the people install android application on their pc using Bluestacks method, because it’s easy. So here are the steps to run android applications on windows pc using Bluestacks. 1) Download Bluestacks app player from  this link . 2) After downloading, Start installation. 3) In case if you are not using graphics card, then while installation, you might get a pop-up box warning. Don’t worry just click “OK” installation will not terminate. 4) Soon after installation, a screen like following screenshot will appear. 5) Now click on  App Stores  icon to access android application markets like Get Jar, Amazon App store and 1Mobile. 6) Click on any of the app market then search and inst...

1. Start screen sets the scene Excel's new Start Screen helps you get to work more quickly. Along its left edge are the most recently used worksheets, any of which can be pinned to your Recent list so they will always be visible. Here, too, you can click  Open Other Workbooks  to access your files from a disk or the cloud. The Start Screen’s top-right corner also shows the SkyDrive (or SharePoint) account you are currently connected to. A range of templates appears here to help you quick start a project. These can also be pinned, or you can use the search feature to look online for other templates. A list of suggested searches can help you get started. New users will appreciate the template choices, and existing users will likee the Recent file list and quick access to existing files. Although the Start Screen can be disabled, I find it useful enough to stick with it. 2. Enjoy a new Backstage View The Backstage View, introduced in Office 2010, is accessible from ...