Welcome to Srinivas Kumar Goud blog

=ctrl+ ;

=SUM(A2:INDEX(A:A,ROWS(A:A))) OR: =SUM(OFFSET(A2,,,ROWS(A:A)-1))

START search with ^ END search with $ https://www.youtube.com/watch?v=lH8Gkyl1mfg

for /f "delims=" %%a in ('dir "C:\" /b /ad-h /od "Anoth*"') do set "latestDir=%%~a" echo %latestDir%

> dir/ ad /b /on source: http://forums.devshed.com/programming-42/dir-command-list-folders-504954.html

Using find and replace: Hit CTRL-H to open the Replace dialogue box enter  String .*  into Find what leave Replace with empty(/1) Select Regular expression and .matches newline Click on Replace ref:https://superuser.com/questions/233562/how-can-i-delete-rest-of-the-line-after-a-specific-string

Arow            B                                                                           C               D 24/01/2018 PAYMENT RECEIVED 000000000L1625996828275 Credit 2 25/01/2018 PETROL TRXN FEE RVRSL EXCLUDING TAX Credit 2 3/1/2018 SWAGATH DE ROYAL HYDERABAD IN Debit 10 4/1/2018 INDIAN RAILWAYS CA INR HTTPS://WWW.I IN Debit 10 5/1/2018 BAR ONE HYDERABAD IN Debit 10 5/1/2018 BAR ONE HYDERABAD IN Debit 10 Now want to get sum of credit & debit like below Credit 4 Debit 40 Ans: Formula :  = SUMPRODUCT ( ( $C$2:$C$222 = Credit ) * ( $D$2:$D$222 ) )

Add   # coding: utf-8 at top of .py file

First we install Python. I recommend Python 2.7 because it has the most compatible packages. Visit  www.python.org  and navigate to  Downloads  >  Windows  and click  Python 2.7.9 .