How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source.
Name the field in the Calculated field and apply the formula by Double-clicking...
The Next Level Technologies
Excel Learning...Read & Share....Happy Learnings
Record Macro (Automating day to day activity reports)
-> Choose Record Macro in the Code group of the Developer...
Hi,
In today's Excel topic we will see how Index & Match function is superior than Vlookup/Hlookup.
With Index and Match, the return value need not be in the same column as the lookup column, unlike...
RIGHT function in VBA returns the Specified number of characters from the end of a text string
Syntax: Right(String,Length)
Sub RIGHT_1()
Dim mystring As String
mystring = "Narendra Modi"
MsgBox Right(mystring,...