hi team,
I'm trying to create a more dynamic table than what i have come up with to date (see attached).
Just seeing if there is a more robust way to create the table other than the way i'm doing it?
Perhaps there is a way to use index match to make it more dynamic.
Any help would be much appreciated.
You should set up your DB in the following manner. This is what is considered Normalized in the DB world and will then allow for easier analysis and what - if scenarios.
Excel 2016 (Windows) 32 bit
Start Date Amount Notes Date Amount Product A Product A purchased 1 month after start date Product B Product B purchased 2 months after product B initially and then 3 months after the preceding Product B purchase Product C Product C purchased 4 months after each Product B purchase Product B Product B purchased 2 months after product B initially and then 3 months after the preceding Product B purchase Product C Product C purchased 4 months after each Product B purchase
Sheet: Sheet2
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Your +31 is not an exact science. Better would be to use EDATE:
=EDATE(D2,1)
will give 01/08/2020
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks