Count DIGIT 2N MID

count digit in MID (Mon to Wed)
source column O

then show in column AQ   the count in column AR

a1.PNG
here the file
29087104--2-_2N_MID_to.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:
Try this.

I noticed that you have a small problem. I don't believe there should be formulas in the date row of the weeks. I can easily fix that if you like.
2018-03-10_06-57-03.png29088325.xlsm
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i have that problem
how can you fix it ?  because i have it in others woorbooks too
0
Martin LissOlder than dirtCommented:
The attached workbook is fixed.  It used this code to correct the problem in this workbook. You can copy and paste it into any other workbook that needs fixing.

El libro de trabajo adjunto es fijo. Usó este código para corregir el problema en este libro de trabajo. Puede copiarlo y pegarlo en cualquier otro libro que necesite corregir.

Sub FixIt()
Dim lngRow As Long
Dim lngLastRow As Long

Application.ScreenUpdating = False
lngLastRow = Range("B1048576").End(xlUp).Row

For lngRow = 5 To lngLastRow - 12 Step 13
    Cells(lngRow, "V") = ""
    Cells(lngRow, "X") = ""
Next

Application.ScreenUpdating = True
End Sub

Open in new window


After it's pasted you need to do two things.
  • Some of your workbooks start at different rows. Line 8 assumes the first row of data is row 5. Change it if needed to be the first data row in the workbook you want to correct.
  • Lines 9 and 10 refer to columns "V" and "X" because in this workbook those two columns have the problem. If there is only one column then delete one of the lines and change the column letter so that it's the column you want to fix. If there are more than two columns with the problem then copy one of the lines and paste it below line 10 and again change the column letter.

  • Algunos de sus libros de trabajo comienzan en filas diferentes. La línea 8 asume que la primera fila de datos es la fila 5. Cámbiela si es necesario para ser la primera fila de datos en el libro de trabajo que desea corregir.
  • Las líneas 9 y 10 se refieren a las columnas "V" y "X" porque en este libro de trabajo esas dos columnas tienen el problema. Si solo hay una columna, elimine una de las líneas y cambie la letra de la columna para que sea la columna que desea corregir. Si hay más de dos columnas con el problema, copie una de las líneas y péguelo debajo de la línea 10 y cambie nuevamente la letra de la columna.
29088325a.xlsm
1

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 !
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
Microsoft Applications

From novice to tech pro — start learning today.