Friday, November 18, 2016

Get Your Bank Mini Statements on Your Mobile Without the Internet


Get Your Bank Mini Statements on Your Mobile Without the Internet

Dial *99# to do basic Banking instantly. One can check balance for accounts, mini statement where the mobile number is registered & no internet required. Below are the direct codes for banks:


*99*41# - State Bank of India
*99*42# -  Punjab National Bank
*99*43# - HDFC Bank
*99*44# - ICICI Bank
*99*45# - AXIS Bank
*99*46# - Canara Bank
*99*47# -  Bank Of India
*99*48# - Bank of Baroda
*99*49# - IDBI Bank
*99*50# - Union Bank of India
*99*51# - Central Bank of India


*99*52# - India Overseas Bank
*99*53# - Oriental Bank of Commerce
*99*54# - Allahabad Bank
*99*55# - Syndicate Bank
*99*56# - UCO Bank
*99*57# - Corporation Bank
*99*58# -  Indian Bank
*99*59# - Andhra Bank
*99*60# -  State Bank Of Hyderabad
*99*61# -  Bank of Maharashtra
*99*62# - State Bank of Patiala
*99*63# - United Bank of India
*99*64# - Vijaya Bank
*99*65# - Dena Bank
*99*66# - Yes Bank
*99*67# - State Bank of Travancore
*99*68# - Kotak Mahindra Bank
*99*69# - IndusInd Bank
*99*70# - State Bank of Bikaner and Jaipur
*99*71# - Punjab and Sind Bank
*99*72# - Federal Bank
*99*73# - State Bank of Mysore
*99*74# - South Indian Bank
*99*75# - Karur Vysya Bank
*99*76# - Karnataka Bank
*99*77# - Tamilnad Mercantile Bank
*99*78# - DCB Bank
*99*79# - Ratnakar Bank
*99*80# - Nainital Bank


*99*81# - Janata Sahakari Bank
*99*82# - Mehsana Urban Co-Operative Bank
*99*83# - NKGSB Bank
*99*84# - Saraswat Bank
*99*85# - Apna Sahakari Bank
*99*86# - Bhartiya Mahila Bank
*99*87# -  Abhyudaya Co-Operative Bank
*99*88# - Punjab & Maharashtra Co-operative Bank
*99*89# - Hasti Co-Operative Bank
*99*90# - Gujarat State Co-Operative Bank
*99*91# - Kalupur Commercial Co-Operative Bank.

Also, u can dial *99*99# to know your Aadhaar linking and Over Draft Status.

Thursday, November 17, 2016

Know your bank balance without wasting your ATM transaction

We all know that all the banks have restricted us to do limited transactions through ATM. If we are doing ATM transactions beyond the provided limits, bank will charge us for each exceeded transactions. 

Now you need not to worry, All Banks have started this new facility to know your bank balance without wasting your ATM transaction: 





What you need to do is: You have to call on below mentioned mobile number of your bank from your registered mobile number (which linked with your bank account). Call will automatically get disconnected and you will get your bank balance information on your mobile phone through SMS. Now you need not to waste your ATM transaction, just to know your Bank Balance.



1. Axis Bank – 09225892258
2. Andhra Bank – 09223011300
3. Allahabad Bank – 09224150150
4. Bank of Baroda – 09223011311
5. Bhartiya Mahila Bank – 09212438888
6. Dhanlaxmi Bank – 08067747700
7. IDBI Bank – 09212993399
8. Kotak Mahindra Bank – 18002740110
9. Syndicate Bank – 09664552255
10. Punjab National Bank - 18001802222
11. ICICI Bank – 02230256767
12. HDFC Bank – 18002703333
13. Bank of India – 02233598548
14. Canara Bank – 09289292892
15. Central Bank of India – 09222250000
16. Karnataka Bank – 18004251445
17. Indian Bank – 09289592895
18. State Bank of India – Get the balance via IVR 1800112211 & 18004253800
19. Union Bank of India – 09223009292
20. UCO Bank - 09278792787
21. Vijaya Bank – 18002665555
22. Yes Bank – 09840909000
23. South Indian Bank- 0922300848
24. Bank of Maharashtra- 9222281818


We should always share good news with others.


Wednesday, November 2, 2016

SEARCH Function in Ms-Excel

The Microsoft Excel SEARCH function returns the location of a substring in a string. The search is NOT case-sensitive.
The SEARCH function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SEARCH function can be entered as part of a formula in a cell of a worksheet.



View Video on YouTube

Syntax

The syntax for the SEARCH function in Microsoft Excel is:

 SEARCH( substring, string, [start_position] )  

Parameters or Arguments

substring :  The substring that you want to find.
string      :  The string to search within.
start_position :  Optional. It is the position in string where the search will start. The first position is 1.

Note: If the SEARCH function does not find a match, it will return a #VALUE! error.

Applies To: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003,

                  Excel XP, Excel 2000

Type of Function : Worksheet function (WS)
Example (as Worksheet Function) - How to use the SEARCH function as a worksheet function in Microsoft Excel:


Based on the Excel spreadsheet above, the following SEARCH examples would return:

 =SEARCH("bet", A1)  
 Result: 6  
   
 =SEARCH("BET", A1, 3)  
 Result: 6  
   
 =SEARCH("e", A2)  
 Result: 2  
   
 =SEARCH("e", A2, 1)  
 Result: 2  
   
 =SEARCH("e", A2, 3)  
 Result: 9  
   
 =SEARCH("in", A2, 6)  
 Result: #VALUE!  
   
 =SEARCH("cel", "Excel", 1)  
 Result: 3  

Extract data from a long and between of the string in Excel

Extract data from a long and between of the string by using MID and SEARCH Function in Excel

One of my blog viewer Shahrukh Ali, from U.P. has raised beneath query on one of my post:

Query:
 i want only amounts which is after second (|) some time its in 3 digits and some times 4 or 5 digits  
 is there any small formula  
 Excel data is  
 774857|Fos|350|Main|Green|2234|  
 97868|Fos|4500|Main|Green|46577|  
 i mean i want only that amount which is between 2nd and 3rd (|)  
 Results should be 350 and 4500 for this data  

Solution:
Function Used:
 =MID(A2,(SEARCH("|",A2,SEARCH("|",A2,1)+1)+1),(SEARCH("|",A2,(SEARCH("|",A2,(SEARCH("|",A2,1)+1))+1))-(SEARCH("|",A2,SEARCH("|",A2,1)+1)+1)))  

Note: Type or Copy & Paste this function into Cell "B2" and string on "A2" cell