Yogendra Pratap Mishra

I write all the information in my blog which can be useful for you. "Valuing Yourself👍 Always give your Best Shot.......

Yogendra Pratap Mishra

Mishra Blogs

More…
Home

Home

Home

Translate

Posts

Atom

Posts

Comments

Atom

Comments

Search This Blog

Contact Form

Name

Email *

Message *

Wikipedia

Search results

Top 100 Useful Excel Macro [VBA] Codes Examples

November 20, 2018

Yogendra98.blogpost.com You can automate small as well as heavy tasks with VBA codes. And do you know with the help of macros, you can break all the limitations of Excel which you think Excel has? So today, I have listed some of the useful codes e xamples to help you become more productive in your day to day work. You can use these codes even if you haven't used VBA before that. All you have to do just paste these codes in your VBA editor. These codes will exactly do the same thing which headings are telling you. For your convenience, please follow these steps to add these codes to your workbook. Before you use these codes, make sure you have your developer tab on your Excel ribbon to access VB editor. If you don't have please use these simple steps to activate developer tab . Once you activate developer tab, you can use below steps to paste a VBA code into VB editor. Don't Forget: Make sure to download thi...

Get link
Facebook
X
Pinterest
Email
Other Apps

OFFSET combined with SUM or AVERAGE_#Yogendra

April 13, 2019

OFFSET combined with SUM or AVERAGE Formula: =SUM(B4:OFFSET(B4,0,E2-1)) The OFFSET function on its own is not particularly advanced, but when we combine it with other functions like SUM or AVERAGE we can create a pretty sophisticated formula. Suppose you want to create a dynamic function that can sum a variable number of cells. With the regular SUM formula, you are limited to a static calculation, but by adding OFFSET you can have the cell reference move around. How it works: To make this formula work, we substitute ending reference cell of the SUM function with the OFFSET function. This makes the formula dynamic and the cell referenced as E2 is where you can tell Excel how many consecutive cells you want to add up. Now we’ve got some advanced Excel formulas! Below is a screenshot of this slightly more sophisticated formula in action. Add caption As you see, the SUM formula starts...

Get link
Facebook
X
Pinterest
Email
Other Apps

1 comment

My 1st song(Yogendra Pratap Mishra)

November 16, 2018

"Doston ye gaana Maine aapke liye likha hai Aapke liye jald hi mere YouTube channel pe iski video bhi aapko mil jayegi to tab Tak aap is gaane ko gungunaye aur luft utdaye.Dhanyawaad."aur agar aapko gaana accha lage to comment karke bataye aur share Kare. Song lyrics-@"Ek din aa gayi.......".......!!!!!!!!! Lyrics-Yogendra Pratap Mishra Music-Yogendra Pratap Mishra Composed-Yogendra Pratap Mishra Ek din aa gayi Dil se aavaaj. Tu Meri hai tu Meri hai-2 Dil ne kaha Dil ne suna. Kuch ho gaya,sapne buna. Vo raah nihare Tera Pyaar. Tu Meri hai tu Meri hai. Ek din aa gayi Dil se aavaaj. Tu Meri hai tu Meri hai-2 Ek saam ko Dil ne kaha. Tera Chand hai khoya Kahan. Chand aayega purnima ki raat. Vo Meri hai vo Meri hai.-2 Ek din aa gayi Dil se aavaaj. Tu Meri hai tu Meri hai-2. Koi ronke to rukna nahi. Pyaaar Tera hai jhukna nahi Chahe karni pade duniya se takraar. Tu Meri hai tu Meri hai-2.

Get link
Facebook
X
Pinterest
Email
Other Apps

About Me

Yogendra Pratap Mishra

Visit profile

Yogendra Pratap Mishra

10/13 - 10/204
10/06 - 10/131
05/19 - 05/262
04/28 - 05/053
04/14 - 04/213
04/07 - 04/145
03/17 - 03/241
03/10 - 03/177
03/03 - 03/101
02/24 - 03/039

02/10 - 02/173
02/03 - 02/105
01/27 - 02/034
01/20 - 01/276
01/13 - 01/201
01/06 - 01/131
12/30 - 01/062
12/23 - 12/301
12/16 - 12/232
12/09 - 12/164
12/02 - 12/096
11/25 - 12/0213
11/18 - 11/2525
11/11 - 11/1817

Show more Show less

Report Abuse

Powered by Blogger