List to Table in Excel [QSS]

Hello Guys,

After long time and little ups and down in life, Welcome back to Gyaan of Excel. Whether pandemic is endemic or not but excel is not going to leave us alone with its unique features and unique daily problems. I am back again to resume our series name QSS [Quick & Smart Solution].

Here we will see how to arrange data in table from list. Though it appear little confusing but here we will do it like having piece of cake. So let’s start…

First we will see what is problem and what solution we are going to have.

Now lets see how to do it

Now follow below step... 

Amazed? Great... 

Explore more on my blog and share your feedback in below comment.

How to add Days or Months or Years in Date in Excel [QSS]

In routine job at excel, it is very common type of requirement to add days or months or even years to particular date to get future due date or past date. Manual calculation for 1 or 2 date can be okay but for big data, you have to take help of formulas.

In continue series of QSS, in this post we will see how to add Days or Month or Years to date. So lets jump on it.

As you can see in below image, where we need to add 45 days or 5 months or 3 years to 31st Jan 2021. How to do it? Scroll down to 2nd Image

In below image, we have solution for that. As you can see, you can add Days by simply adding days to date, to add Month, you can use Edate formula and for Year you can use Date formula.

As You can see in Year adding formula, you can use same formula to add Days and month too.

I hope you like it.

Share your comment and views on this post.

Enjoy

From Formula to Cell Address to Cell value [QSS Series]

    I know you got confuse with title of this post. Welcome back to the blog of new creative and smart world of excel. Being creative (Jugaadu), Have you ever been in wonderful but confusing situation in excel where you get result of your formula as any cell address but don't know how to get value of that cell address? Yes? Good. In this series of QSS, I will help you out without wasting much time. So follow below steps.

Problem

Solution (Use Indirect Formula)

Got amazed? Cool.. Keep exploring more stuff on my blog and become more and more smarter..