Set categories for rows in a sheet

**dpvro** · 11-17-2016, 10:38 AM

Hello everyone,

I have a case where I have an excel file in which I store three categories of information (processes, rules,documents).
I have many groups of 3 categories and each category can have multiple rows.

For example:

Row 1 Process_1

Row 2 Rule_1_1

Row 3 Doc_1_1_1
Row 4 Doc_1_1_2
Row 5 Doc_1_1_3

Row 6 Process_2

Row 7 Rule_2_1

Row 8 Doc_2_1_1
Row 9 Doc_2_1_2
Row 10 Doc_2_1_3

Row 11 Rule_2_2

Row 12 Doc_2_2_1
Row 13 Doc_2_2_2
Row 14 Doc_2_2_3

I would like to apply some formulas on each Process, Rule, Doc, for example I want to count how many Docs are in a sheet, or thinks like this.

How can I categorize each row in order to use this categorization in formulas and other operations?

Thank you

**newdoverman** · 11-17-2016, 10:53 AM

Welcome to the forum.

Create a "Custom List". Directions on how this is done can be found here:
http://www.dummies.com/software/micr...ofill-feature/

A clarification of what you are actually trying to do would be appreciated as Word has much better facilities for numbering in the manner that you describe. Depending upon what you are doing, maybe Word is the program to use. It all depends upon your data.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. (Remove private or sensitive data that shouldn't be published)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click on Browse under Upload Files from your Computer and then find the file on your computer using the dialogue that opens. Click on Open then click on Upload. Click on Close this Window. Click on Submit.