Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...
Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...
Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...
Presentation Perfect Reports. Why Presentable, neatly crafted Reports makes a job more perfect and easy for Business Analyst who is going make decisions out of the information structured in reports. Many...