Excel Magic Trick #130: 3 Dimensional Database in Excel
Loading...
Loading...
23,837
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (17)
-
@milestowalk Can you post an example of your 3d project plan?
-
@ExcelIsFun try this mrexcel.com/forum/showthread.p
hp?p=2688032#post2688032 -
@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
Loading...
1:09:39
Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)by ExcelIsFun21,429 views- 4:02
Using Excel as a Databaseby HugoPhongPresents4,905 views
- 6:19
Dashboards in Excelby contactatbiznet137,193 views
- 6:45
Linking Data from Different Excel Sheets and Workbooksby ExcelFormulas22,302 views
- 1:03
Turn Excel into Database Management Softwareby Vizubi25,522 views
- 6:03
Excel Magic Trick #151: DATEDIF function (between two dates)by ExcelIsFun20,578 views
- 4:52
302208 - Creating a simple database using Microsoft Excelby HowToUseExcel9,258 views
- 7:52
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteriaby ExcelIsFun20,581 views
- 1:45
Creating a Database by Importing from Excelby intuitquickbase30,558 views
- 6:07
CONSOLIDATIONby aimansadeq10,760 views
- 7:46
Excel Magic Trick 185.5 Advanced Filter Data Extract 1criterby ExcelIsFun21,175 views
- 4:19
Create an Excel UserForm, Part 2 of 3by contextures154,220 views
- 9:47
How to Use Database Functions in Excel for Tables and Listsby DannyRocksExcels4,854 views
- 10:11
YTLE#64: D Function: DAVERAGE DSUM & moreby ExcelIsFun13,612 views
- 9:20
Excel Magic Trick #213: Dynamic Data Extract w Formulaby ExcelIsFun7,813 views
- 7:36
Creating a Data Entry Form in Excel for SPSS/PASWby bartonpoulson18,946 views
- 2:01
Data Base Functions in Excelby DaveGalligan32,745 views
- 9:41
Excel Magic Trick #187: Unique List w Dynamic Formulaby ExcelIsFun14,029 views
- 12:43
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formulaby ExcelIsFun22,271 views
- 8:18
Excel Magic Trick # 254: Data Table Creates 100 Formulasby ExcelIsFun26,099 views
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.
EnerkaPower 9 months ago
Wow, I do not. Try THE best excel question site:
mrexcel[dot]com/forum
ExcelIsFun 9 months ago
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.
milestowalk 10 months ago
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
ExcelIsFun 10 months ago
@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 10 months ago
Send me link to your post so that I can follow along also! (Send link by YouTube e-mail).
ExcelIsFun 10 months ago