# Search:

Type: Posts; User: sdckapr; Keyword(s):

Page 1 of 20 1

1. ## Thread: Animate the drawing of Excel 2013 Scatter Plot Point by Point

by sdckapr
Replies
12
Views
427

Option Explicit
Sub AnimateChart()
Dim rX As Range
Dim x As Long
Dim y As Long
Dim iCols As Integer
2. ## Thread: Help Me Figure Out a Formula

by sdckapr
Replies
8
Views
131

### There is no attachment. I presume that sum of the...

There is no attachment. I presume that sum of the COUNTIF of the present and COUNTIF of the excused divided by the total count should work. But without know the setup, it is difficult to be more...
3. ## Thread: Help Me Figure Out a Formula?

by sdckapr
Replies
15
Views
368

### Does this modification to your code work? I just...

Does this modification to your code work? I just took the total you get and divided it by the number of cells in the range and then convert that number.

Public Function AvgGrade(rng As Range) As...
4. ## Thread: Animate the drawing of Excel 2013 Scatter Plot Point by Point

by sdckapr
Replies
12
Views
427

### Could you elaborate on what you need in excel? I...

Could you elaborate on what you need in excel? I don't understand what you want the chart to look like and what you want animated. [perhaps you could attach a picture of what you need].

For...
5. ## Thread: Physical test with run time

by sdckapr
Replies
9
Views
195

This question was asked and answered earlier. Is there a reason you posted it again?
If you are looking for a modification of RG's formula:...
6. ## Thread: Physical test with run time

by sdckapr
Replies
9
Views
195

### Something like: =min(100, 'selected...

Something like:
=min(100, 'selected cell'/15*100)

Steve
7. ## Thread: Auto-execute VBA code on workbook open

by sdckapr
Replies
3
Views
94

### Is the code located in the ThisWorkbook Object?...

Is the code located in the ThisWorkbook Object? It needs to be located there.

Steve
8. ## Thread: Blank Cells Match Formula Explanation

by sdckapr
Replies
4
Views
129

### Some formulas must be entered explicitly as an...

Some formulas must be entered explicitly as an array (ie using the ctrl-shoft-enter). Some formulas implicitly work with arrays (sumproduct, index, etc) so the formula does not explicitly need to...
9. ## Thread: Excel 2010 copy/paste giving incorrect results.

by sdckapr
Replies
4
Views
105

### Are all the rows unhidden in both the copy and...

Are all the rows unhidden in both the copy and the source?

Steve
10. ## Thread: Formatting numbers with VBA

by sdckapr
Replies
3
Views
79

### This is not a bad source for the information:...

This is not a bad source for the information: http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx

Steve

by sdckapr
Replies
5
Views
165

### The IRR can get a Div/0 error on some occasions...

The IRR can get a Div/0 error on some occasions if during the iterations the function gets that type of error internally. I think having the values flip too much between positive and negative can do...

by sdckapr
Replies
5
Views
165

### Same as before: details of a specific example and...

Same as before: details of a specific example and how you are calculating it, so we can try and understand the issue.

Steve

by sdckapr
Replies
5
Views
165

### could you provide details of the situation or at...

could you provide details of the situation or at least an example that we can work through. Also what is an "EAY"?

Steve
14. ## Thread: Excel incorrect result after cross-sheet sorting

by sdckapr
Replies
4
Views
143

### Change the formula in B1 to something like:...

Change the formula in B1 to something like:
=COUNTIF(Sheet1!A:C,A1)

And it will sort the way you expect it to sort. By explicitly adding a sheetname (even if it is sheetname on the sheet), the...
15. ## Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by sdckapr
Replies
11
Views
683

### I don't understand the logic to get 0.21 as the...

I don't understand the logic to get 0.21 as the average. The average of the values from B5:B15 is only 0.17. You can get this average with the array formula (confirm with ctrl-shift-enter):...
16. ## Thread: Macro to create a pivot table

by sdckapr
Replies
1
Views
77

### At runtime you could determine the number of...

At runtime you could determine the number of pivottables in the workbook:
x = 0
For each wks in Activeworkbook
x = x + wks.PivotTables.Count
next
x = x+1

and then in your creation code use...
17. ## Thread: replace default grids

by sdckapr
Replies
8
Views
164

### A fill hides the grid. If you follow Retired...

A fill hides the grid. If you follow Retired Geeks Instructions you can add borders to those cells which will be over the fill and act as a grid.

Steve
18. ## Thread: Formula returns color to "yes" and"no"

by sdckapr
Replies
5
Views
126

### This is cross-posted at...

This is cross-posted at http://www.eileenslounge.com/viewtopic.php?f=27&t=17311&sid=1eb5c3b7be4bf1d4a149a9d0796a749a. That forum has answers in it, so please go there for any followup and additional...
19. ## Thread: If a certain value is found, delete certain cells

by sdckapr
Replies
20
Views
8,948

### I am not sure I understand completely. Could you...

I am not sure I understand completely. Could you elaborate? Is it ONLY the number 1 or is it more general. If a duplicate is found, what should happen to the duplicate cell: clear it, change it to a...
20. ## Thread: Plug date into cell

by sdckapr
Replies
13
Views
1,066

### There is no need to copy/paste Sub...

There is no need to copy/paste

Sub Date_Enter()
' Date_Enter Macro
ActiveCell.Value = Date
ActiveCell.NumberFormat = "d mmmm yyyy"
End Sub
21. ## Thread: Help Me Figure Out a Formula?

by sdckapr
Replies
15
Views
368

### An alternative which only requires entering the...

An alternative which only requires entering the values in 1 place is to use match/index.

Option Explicit
Public Function Grade(rng As Range) As String
'DECLARE AND SET VARIABLES
Dim rScore...
22. ## Thread: Calculating Days In Cumulative Between Categories.

by sdckapr
Replies
2
Views
103

### Will 2 pivot tables work like in the attached? ...

Will 2 pivot tables work like in the attached?

Steve
23. ## Thread: Plug date into cell

by sdckapr
Replies
13
Views
1,066

### If it is more than one cell, you can also use in...

If it is more than one cell, you can also use in VBA something like:
range("A1:A15")=date

If using the shortcut key, you can select the cells you want to change the date of:
ctrl-;
Then use:...
24. ## Thread: Help Me Figure Out a Formula?

by sdckapr
Replies
15
Views
368

### Perhaps this example will work. Steve

Perhaps this example will work.

Steve
25. ## Thread: Round times to the NEAREST hour

by sdckapr
Replies
4
Views
169

### You can essentially accomplish what you have with...

You can essentially accomplish what you have with your formula with:
=INT(J2*24+0.5)

Steve
Results 1 to 25 of 500
Page 1 of 20 1