-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
explainations
-
M
Sumproduct for date counting
After some research I have found a solution for counting date occurrences within a cell range. Could someone give me a breakdown of the following function and a reasonably simple explanation of how it works. =SUMPRODUCT(--(TEXT(A1:A100,"mmmyyyy")="Jan2000")) Thank you- madstock
- Thread
- count explainations sumproduct sumproduct + count days
- Replies: 4
- Forum: Excel Questions
-
S
Explanation of Code in VBA
Range("A65536").End(xlUp)(1, 2) = txtTitle.Text 'Prints the text in the Title column' This code goes to a text box on a form and it prints whatever I type in the text box directly into the first blank row in the second column. I found this code on this site, but I would like to understand it...- seasmith
- Thread
- explainations help me please range
- Replies: 9
- Forum: Excel Questions
-
Meldoc code explaination. for Experts. Help!!!!
;)Meldoc prepapred this code: Please expplain how this code works each line. Thanks alot!!! Sub Pedie() With Sheet1 lr = .Cells(Rows.Count, "A").End(xlUp).Row For i = 2 To lr If .Cells(i, "D").Value >= .Cells(2, "H").Value Then .Range("A" & i & ":G" & lr).Copy...- pedie
- Thread
- explainations
- Replies: 1
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
