Too many variables for nesting "IF" function

[Scrane]

I have a rather large spreadsheet that gives me the following information:

10112 Biloxi

MT Manager Trainee BOP Active 2
CSR Customer Service Rep BOP Active 2
MGR Manager BOP Active 1

10112 Biloxi BOP Active 5


This sheet has information for over 200 branches (10112). From this sheet, I feed two more sheets. I need a formula to easily feed the other sheets (Manager) (Supervisor) based on the branch number. Since there are over 200 branches, "IF" statements will not work. Also, each (Supervisor) has approx. 5 (Managers) and each manager has approx. 9 branches.


Any help would be appreciated!!!!

 

[Smitty]

Welcome to the Board!

Is the information all in one column? (If you follow the HTML Maker link in my sig you'll be able to post an actual screen shot).

Where's the data coming from (this looks like a database report)? If it is coming from another source, can you get the raw data? Then you could probably build pivot tables to summarize.

 

[Scrane]

Welcome to the Board!

Is the information all in one column? (If you follow the HTML Maker link in my sig you'll be able to post an actual screen shot).

Where's the data coming from (this looks like a database report)? If it is coming from another source, can you get the raw data? Then you could probably build pivot tables to summarize.

Hi Smitty,
Unfortunately I am locked out of opening the other website. Not all information is in one column. The data has been manually keyed in, so there is no database. This was easier to do when there were fewer branches, but now that we are over 200 and growing, it is not feasible to do by hand.

Let me know what information you need from me and I will be happy to provide it.
I have exhausted all of my google searches on this! lol

 

[Smitty]

If it's all been manually input, then you might want to think about tweaking it into a normalized format:

Excel 2012
	A	B	C	D	E	F
1	Unit	Location	Emp Type	BOP	Active	Count
2	10112	Biloxi	MT Manager Trainee BOP	BOP	Active	2
3	10112	Biloxi	CSR Customer Service Rep	BOP	Active	2
4	10112	Biloxi	MGR Manager	BOP	Active	1
Sheet4

If it's like this, then you can create pivot tables to summarize everything.

Excel 2012
	A	B	C	D	E
3	Unit	Location	BOP	Active	Sum of Count
4	10112	Biloxi	BOP	Active	5
5	10112 Total				5
6	Grand Total				5
Sheet5

 

[Scrane]

I thought about changing the format at one point, but decided against it for some reason. I may have to rethink that.

Thank you so much for your help!

 

[Smitty]

No problem,

If you can post a more expansive screen shot someone might be able to whip up some code to normalize the data for you.