• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Misusing Excel as a Database ... > Handling Variable Numbers of Records...

Handling Variable Numbers of Records per Category

Excel presents a real headache when you have some number of records in different categories, and not all categories have the same number of records. Figure 1.12 continues the example first shown in Figure 1.1.

Figure 1.12. This is what a relational structure can look like when it gets shoehorned into a worksheet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint