Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

in the same column same digit by time

4N to add  AM / PM  count by follow in the column 

29227394a.xlsb



as we did here but now for  AM  PM   :

https://www.experts-exchange.com/questions/29227333/in-the-same-column-same-digit.html?anchor=a43355252&notificationFollowed=278181006#a43355252



1- make the follow count by column  L   M  N  O  by week


2-then put this in AM  to   X    Y    Z  AA


3- then PM in  AB   AC    AD   AE

Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

I don't understand.
ADRIANA P

ASKER
the first time we did it taking into account the whole week and am and pm together

now this time I need to do the same

but adding the separation of am and pm

That is to say, everything that is me we do for the section of am

and everything that is pm goes to the pm section

if you look at me

example if you see a number

A.M


1-q is the same
2- what is one up
3- is one down


6
7
8
ADRIANA P

ASKER
1w2012 to 24w2012  have pm alone

but 25w2013   onwards have AM PM







I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ADRIANA P

ASKER
here AM and PM for week 26W2012
                                                                                                                       AM/PM                     AM                        PM
Martin Liss

Lets talk about the AM/PM portion for a minute. I'm going to use the word "near" to mean that a number is equal to, one less than or one more than the previous number.

I assume that cell T1010 is 21 because the 1 in T1010 is near the 2 in T1009. And I assume that T1011 is 213 because the 3 in T1013 is near the 2 in T1009.

If my assumptions are correct then the 123 you show in AB1011 is NOT correct because the 3 in cell T1011 is NOT near the 1 in T1007 and so I believe that the AB1011 should be blank. Do you agree?

Hablemos de la parte AM / PM por un minuto. Voy a usar la palabra "cerca" para significar que un número es igual a, uno menos o uno más que el número anterior.

Supongo que la celda T1010 es 21 porque el 1 en T1010 está cerca del 2 en T1009. Y supongo que T1011 es 213 porque el 3 en T1013 está cerca del 2 en T1009.

Si mis suposiciones son correctas, entonces el 123 que muestra en AB1011 NO es correcto porque el 3 en la celda T1011 NO está cerca del 1 en T1007, por lo que creo que el AB1011 debería estar en blanco. ¿Estás de acuerdo?
ADRIANA P

ASKER
If my assumptions are correct then the 123 you show in AB1011 is NOT correct because the 3 in cell T1011 is NOT near the 1 in T1007 and so I believe that the AB1011 should be blank. Do you agree?

yes

I would like to know if a button could be made that allows me to make it visible or invisible as necessary

that is, the normal state is full am pm

but if I want to see only  AM

or if I want to see only PM

I say visible or invisible so as not to affect the visibility of other columns like ORD
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
The button would be to see the columns L M N O according to necessarily
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ADRIANA P

ASKER
Great Job !!
 Best Expert !


ADRIANA P

ASKER
I mean if you can create a button that makes the numbers visible or invisible in the column down by AM or PM
example :
 
 
49W2013

31073107AM






01820182AM






02340234AM






29632963AM






99249924AM






79017901AM







Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Martin Liss

Which columns?
ADRIANA P

ASKER
for columns  L M N O 
Martin Liss

That's already done.
I added two grouping buttons, one above column K and the other above column W. Column K is a little wider than it used to be so that the +/- button can be seen.

When the "-" is clicked in column K, columns L to O will be hidden and then if the "+" is clicked they will appear again.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
that hides the columns L M N O but  I talk about an button that does not hide the columns but makes it visible or invisible the DATA  for AM  or PM as needed  in columns L M N O   down the columns

when I hides the columns does not let me see PM only it hide all data
but
If i want to see  the data corresponding to AM only by made  PM invisible, I can see the data only for AM  to work with

same for PM when needed


rigth now If I only want to see only data for PM in the columns without hiding the Columns L M N O, how can I do it?

then a button that makes visible the data you need to see needs

1- ALL DATA TO THE SAME TIME = AM / PM in columns L M N O
or
2-ONLY the AM data in the columns L M N O
or
3- only the data of PM L M N O
ADRIANA P

ASKER
in this sample   I just hide PM DATA but still see AM DATA to work with

49W2013

31073107AM






01820182AM






02340234AM






29632963AM






99249924AM






79017901AM





Martin Liss

As I said above, when the "-" is clicked in column W, the AM and PM sections will both be hidden and then if the "+" is clicked they will appear again. I can't do just AM or just PM because they are next to each other.]
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
can you make the data invisible in a cell with a button?
I'm not talking about hiding a column or a section
Martin Liss

Are you saying you don't want any columns hidden?
ADRIANA P

ASKER
Everything that was done is perfect
and it's working fine

but it would help me to make invisible or visible
a data using AM or PM as filter

that way I could only see visually
of what you need to analyze
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
if with a button you can make AM invisible
while I watch and analyze PM that would be fine
Martin Liss

Please answer my question.

but it would help me to make invisible or visible
a data using AM or PM as filter
I don't know what that means.
Martin Liss

What do you mean by "invisible"?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ADRIANA P

ASKER
in this sample i make invisible PM so i can work with AM

Martin Liss

As far as I can see you haven't made anything invisible.
ADRIANA P

ASKER


Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
I'm making PM data invisible for week 3W2014 PM only

In Columns L M N O  make PM  invisible  so I only see the AM data
but only the data in those columns to see everything else the same and thus analyze it
Martin Liss

You'll find a new 'HidePM' button near column L.
ADRIANA P

ASKER
where?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ADRIANA P

ASKER
you means hide unhide?

Martin Liss

Here.

you means hide unhide?
Just click the button. It does both,
29227471a.xlsb
ADRIANA P

ASKER
it won't let me click him
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Sorry about that.
29227471b.xlsb
ADRIANA P

ASKER
Great ! idea is good but something need be adjusted
is  not showing all the data when unhide

even i try  the Digit Num  to put the data back in columns L M N O





SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Awesome and wonderful
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ADRIANA P

ASKER
Great Job ! Best Expert !
Martin Liss

By the way, when the PM values are hidden, if you select one of them like cell L1007, you will see the value in the formula bar. The reason for that is that to "hide" them I changed their font color to white.

Por cierto, cuando los valores de PM están ocultos, si selecciona uno de ellos como la celda L1007, verá el valor en la barra de fórmulas. La razón de esto es que para "ocultarlos" cambié su color de fuente a blanco.
ADRIANA P

ASKER
Thanks ! It is good to really know what I need because that way it is more visual to be able to analyze it and make fewer mistakes

I have two more questions about 4N, one of them is

in TRig create two user froms but using column B and column A as key


the last question is in DD-X to color the hits in ORD of one week and two weeks

With that I finish 4N although I still have material to work with

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.