adjust 00 tool

when i look for 00 i get others values
also
when i try to use MOVE tO History button

an error show  for 00

as shown

b222.PNG
error-when-move-to-history.PNGfix_00_find_tool_N_ALL.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:
Let's do this in 2 steps. I think I've corrected the "00" problem and I've changed what's shown in LOCATION to include both the column and the row (it was only showing the column before). Let me know if that part is corrected. If it is, please don't select it as the answer until I fix the history problem.
29119496.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
working as needed Expert
0
Martin LissOlder than dirtCommented:
OK, good, but I have a question for you about the history. On the HIST-DTA sheet, column 'A' is the number you search for, while column 'B' is how many there are. What bothers me is that column 'C' is a percent and to get that percent you are dividing column 'B' by column 'A'. That would make sense if column 'A' were the total number of 2-digit numbers, since then column 'C' would show you what percent of all the 2-digit numbers were the number you searched for, but to me dividing the count by the value that you searched for is meaningless. For example if you searched for "14" and the count were 14, the percent would be 100! What would that mean to you? And the problem with 00 is that there are 17 of them but when you try to divide 17 by 0 you get an error since division by 0 is not allowed.

OK, bien, pero tengo una pregunta sobre la historia. En la hoja HIST-DTA, la columna 'A' es el número que busca, mientras que la columna 'B' es la cantidad que hay. Lo que me molesta es que la columna 'C' es un porcentaje y para obtener ese porcentaje está dividiendo la columna 'B' por la columna 'A'. Eso tendría sentido si la columna 'A' fuera el número total de números de 2 dígitos, ya que la columna 'C' mostraría qué porcentaje de todos los números de 2 dígitos eran el número buscado. , pero para mí dividir el conteo por el valor que buscaste no tiene sentido. Por ejemplo, si buscó "14" y el recuento fue 14, ¡el porcentaje sería 100! ¿Qué significa eso para ti? Y el problema con 00 es que hay 17 de ellos, pero cuando tratas de dividir 17 entre 0, obtienes un error ya que la división por 0 no está permitida.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I see

the %  should be

the count / Total column

(column B/ Column D)


whats we try to track is the higher  count (how many times the NUM appear in the total columns)

to identify it

that make sense
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ccc11111.PNG
0
Martin LissOlder than dirtCommented:
that make sense
Did you mean "Does that make sense?". If so then, yes, and I'll make that change. Since the percent is 'B' divided by 'D' then I think the '%' column should be after column 'D'. In other words switch 'C' and 'D'. Do you agree?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Yes ! Expert
0
Martin LissOlder than dirtCommented:
Try this.
29119496a.xlsm
0

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:
Outstanding!   Martin
0
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
VBA

From novice to tech pro — start learning today.