adjust 00 tool

ADRIANA P
ADRIANA P used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
working as needed Expert
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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.
Ensure you’re charging the right price for your IT

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

ADRIANA PACCOUNTING ASSISTANT

Author

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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
ccc11111.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Yes ! Expert
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this.
29119496a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Outstanding!   Martin

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial