Excel Magic Trick #130: 3 Dimensional Database in Excel

[EnerkaPower]

I watched your video and I can see that at 4:04 you add a new row to the table. This should be light blue but it is actually dark blue. The same problem with the formatting happens later as well at 4:42. How can you keep the formatting in order to have alternating dark & light blue rows whenever you add a new row to the table? Do you know a way to fix that? Thank you.

[ExcelIsFun]

Wow, I do not. Try THE best excel question site:

mrexcel[dot]com/forum

[milestowalk]

Is there a way you could allow multiple values in a single cell for Category, but be able to still validate them?

Ex: Have Red, Pink in cell 2A and it should accept it, but if I enter Red, Cyan,  it should throw the error for me.

[ExcelIsFun]

I have no idea how to do that. Access is good for that. I am sure that there is a way, though. Try THE best Excel question site:

mrexcel[dot]com/forum

[milestowalk]

@ExcelIsFun Thanks for the quick reply. Just so you know the reason for my ask, I use excel for project planning and I need to show my GANTT chart 3 dimensional: 1. Features 2. Resources 3. Date / Schedule. I hate MSProject as it is not flexible, needs additional setup, training for other folks who are using it, etc etc

Thanks for the quick reply. I will try MrExcel

[milestowalk]

@ExcelIsFun Thanks for the quick reply. Just so you know the reason for my ask, I use excel for project planning and I need to show my GANTT chart 3 dimensional: 1. Features 2. Resources 3. Date / Schedule. I hate MSProject as it is not flexible, needs additional setup, training for other folks who are using it, etc etc

Thanks for the quick reply. I will try MrExcel

[ExcelIsFun]

Send me link to your post so that I can follow along also! (Send link by YouTube e-mail).

[milestowalk]

@ExcelIsFun try this mrexcel.com/forum/showthread.p­hp?p=2688032#post2688032

[jrwashburn]

@milestowalk Can you post an example of your 3d project plan?

[TheLtbiomed]

"oh white is a color,let's just type black" looooooool amazing tutorial thanks man!!

[ExcelIsFun]

I am glad that you liked it!

[Emily6109]

I think it is awesome that you do these videos. I am graduating from college in May and I am watching these videos to try to become more efficient in excel and more marketable as an employee. Thank you so much!

[ExcelIsFun]

You are welcome!

[zahawk007]

hey,

I m Zarshad Pakistan. i m facing a problem in the above example, i m doing same as u did in the Example: but in the end (Daverage Formulea not worked its give the answer [#DIV/0]. this answer is same in both of the method i.e [Averageifs function also give the same result {#Div/0}] please help me in this way.

thnks

Best Regards  Zarshad

[ExcelIsFun]

#Div/0 means that you are dividing by zero. I do not know what the exact calculation is, but for whatever reason it has a zero in the denominator.