Mar 20 2019 04:33 AM
Hi There.
I am new for advance excel techniques.
Could you please help to provide solution?
I have attached an image which is self explanatory.
If you have any question, please let me know.
TIA
Mar 20 2019 10:17 AM
Use pivot table instead using any formula , still you want to use formula define a value on which base you want to see that report like date , model number or any other head then u can use formula for making such reports, but i suggest to use pivot table@mohsin91santono-_-1220
Mar 20 2019 06:54 PM
Hi Gaurav
Thanks a lot for your insight
But Pivot is not solution for me.
I need it for some reason. :)
Mar 20 2019 06:57 PM
Hi Celia,
Could you please help in this post?
I have confidence that you can help.
Please Please Have A Look.....
Mar 22 2019 10:48 PM
SolutionI Solved It By Myself
Thanks @Celia_Alves ;)
You showed a great way :D
I am forever grateful
Mar 23 2019 06:39 PM
Well done, @mohsin91santono-_-1220 ! I was also going to suggest tables and pivot tables as @Gaurav_Jalan did. I am glad that you were able to come up with a solution. That's the best way to learn Excel!
Mar 22 2019 10:48 PM
SolutionI Solved It By Myself
Thanks @Celia_Alves ;)
You showed a great way :D
I am forever grateful