Search in a row and Find Column number matching from the data in a column:

In-order to search a row and find the column number which is matching the data in the column you can use the following formula: 

=MATCH(A7,'Sheet_Name'!A8:Z8,0)

lookup_value - A7 (Value in column A7 in the same sheet)

lookup_array - 'Sheet_Name'!A8:Z8 (Check row 8 in worksheet Sheet_Name)

match_type - 0

For detailed info regarding MATCH formula, please look MATCH.

MATCH Function - Formula to find the row number where "Grand Total" is existing:

Syntax:

=MATCH (lookup_value, lookup_array, [match_type])

Arguments: 

lookup_value - The value to match in lookup_array.

lookup_array - A range of cells or an array reference.

match_type - [optional] How to match, specified as -1, 0, or 1. Default is 1.

Usage notes: 

Use the MATCH function to get the relative position of an item in an array. Match offers several different matching modes, which makes it more flexible than other lookup functions. Used together with INDEX, MATCH can retrieve the value at the matched position.

Match type information:

• If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. The lookup_array must be sorted in ascending order.
• If match_type is 0, MATCH finds the first value exactly equal to lookup_value. lookup_array does not need to be sorted.
• If match_type is -1, MATCH finds the smallest value that is greater than or equal to lookup_value. The lookup_array must be sorted in descending order.
• If match_type is omitted, it is assumed to be 1.
• Note: All match types will find an exact match.

Notes:

• Match is not case-sensitive.
• Match returns the #N/A error if no match is found
• The argument lookup_array must be placed in descending order: TRUE, FALSE, Z-A,...2, 1, 0, -1, -2,..., and so on.
• If match_type is 0 and lookup_value is text, the wildcard characters question mark (?) and asterisk (*) can be used in lookup_value. 
• If match_type is 0 and lookup_value is text, lookup_value can contain the wildcard characters asterisk (*) and question mark (?). An asterisk matches any sequence of characters; a question mark matches any single character.

Formula to find the row number where "Grand Total" is existing:

=MATCH("Grand Total",'Sheet_Name'!$A:$A,0)

lookup_value - "Grand Total"

lookup_array - 'Sheet_Name'!$A:$A (Check Column A in worksheet Sheet_Name)

match_type - 0

Install Dual Skype Accounts in Android Mobile

If you want to run two skype accounts simultaneously in an android phone, then you need to follow the following steps:

1. First log onto Google Play store and install  skype from their. You can use this skype application to login to your first skype account.

2. Then access the website http://skype.gmw.cn/down/skype-for-mobiles.html and download skype for android APK using the following button in the website.:

Install the downloaded APK. 

After installing this skype APK you will be able to see two SKYPE applications in your android phone one from step 1 and the other from step 2. Now, you can use both the skype applications to login to two skype accounts simultaneously.

Thank you for reading my post.