COUNT DATA HORINZONTALY 4N-T AND M ADJUST

1-count data  horizontal (FIRST SECTION)

2- tri  TOP   in column  EI

3-then put together in column EK (AFTER PAIR)
29083374b--2-_4N_tp_mid_fix.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
That's already done in the 29083374c workbook that I uploaded in our last thread, but I'll attach it here again.
29084077c.xlsm
Martin LissOlder than dirtCommented:
Oh, I understand now, Be back soon,
Martin LissOlder than dirtCommented:
This calculates the values in columns EE:EK.
29084337.xlsm
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

The TOP horizontal is  as needed

then

1- the button "Hide TOP count"   is out of place  and is not making the hide

xxx1.PNG
Martin LissOlder than dirtCommented:
That's because your workbooks aren't consistent concerning what's in what column, where the data starts (some in row 4, others in row 5) and where the buttons are so all the function in this workbook will need to be redone one at a time.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  

Sorry !
Martin LissOlder than dirtCommented:
That's OK. In any case the hiding and unhiding can be done without code as in this version. Click the '-' sign in the little box at the top of the columns. If you like that then all of the hide/unhide buttons in all your workbooks can be done this way. No new question will be needed, just remind me to do it whenever you have a different workbook.
29084337x.xlsm
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
im triyng to donwload  but it dont down!
Martin LissOlder than dirtCommented:
Try again.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
Is great to me

i have 2 question for

1- can the high of the "-" area be shorter ??

2- MIDWAY TOP need be show not hide
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
rrr1.PNG
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sss1.PNG
Martin LissOlder than dirtCommented:
1- can the high of the "-" area be shorter ?? => No. And I think you can have one large group that hides and unhides (like the one I just changed) and have sub-groups underneath and in that case I believe that the "-" area would be higher.

2- MIDWAY TOP need be show not hide=>OK

Note that I got rid of the Show RPW button.
29084337a.xlsm
Martin LissOlder than dirtCommented:
I'm done for the night.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

1- this hide /unhide control is more robust
Thanks for the Great Idea ! like always !!

just one adjustment as shoe here by now

zzz1111.PNG

2- then

MID HORIZONTAL  TOP
is the  needed


Here the file
29084337a--1-_4NNNN.xlsm
Martin LissOlder than dirtCommented:
OK I removed that group which I added by accident. BTW are you aware of what happens when you click these buttons?
Cursor_and_Microsoft_Excel.jpg
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

1- closed all the groups
2-open al the groups

is an great tool!
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

in ID: 42471668

you say  

OK I removed that group which I added by acciden

but where is the file now ?
Martin LissOlder than dirtCommented:
Take a look at the picture you posted in ID 42471356. It shows three "groups" and your picture points to the first one. I didn't mean to add that group, so in my 29084337a workbook that I posted above, I removed that group.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin !

i open 29084337a  file  (is   the last file i have )

please verify because it  have the
group which I added by accident


also  need the change to  MID HORIZONTAL  TOP

Sorry ! is becuase im waiting to move foward
and that the last file i have  

Please verify!
Martin LissOlder than dirtCommented:
This question was about 'Horizontal Top' which I've done in 29084337a. 'Mid Horizontal Top' would be a new question.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok let me open it
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

I found why you don't see the group

is because it hide from BS TO CC

when you unhide  you will see it

and still there   (because is hide ) please verify
Martin LissOlder than dirtCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB
 Best Expert !
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.