# Search:

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

Page 1 of 6 1

1. ## Thread: I need with my friend

by shg
Replies
10
Views
165

### Re: I need with my friend

Format E2 as General.

The formula in C2 should be =DATEDIF(B2, A2, "y")

by shg
Replies
8
Views
181

A
B
C
D
E
F
1
Group
Qty
CDF
3. ## Thread: Standard deviation of correlation matrix

by shg
Replies
6
Views
84

### Re: Standard deviation of correlation matrix

Change the formula in those cells so they return blanks on and above the main diagonal. Blanks are ignored by STDEV.
4. ## Thread: Help converting weird date format

by shg
Replies
5
Views
111

### Re: Help converting weird date format

Messy ...

A
B
C
115-May
01 May 2015B1: =--(1 & MID(A1, FIND("-", A1) + 1, 4) & LEFT(A1, FIND("-", A1) - 1))

216-Mar

by shg
Replies
3
Views
191

### Re: Time Conversion

You're welcome.

by shg
Replies
3
Views
191

### Re: Time Conversion

c
d
e
f
4
8.00
8.30
0.50e4: =dollarde(d4, 60) - dollarde(c4, 60)

5
7. ## Thread: Unprotect sheet error in VBA

by shg
Replies
19
Views
261

Worksheets

by shg
Replies
5
Views
144

Or ...

A
B
C
D
E
1
Site

by shg
Replies
5
Views
144

### Re: % increase.

One way, perhaps:

A
B
C
D
E
1
Site
10. ## Thread: Solver: Constraint for values in a range

by shg
Replies
1
Views
56

### Re: Solver: Constraint for values in a range

SolverOk SetCell:="B94", _
MaxMinVal:=2, _
ValueOf:=0, _
ByChange:="AJ55:AJ84", _
Engine:=1
...

by shg
Replies
7
Views
108

A
B
C
1
data
lbs

2
112.3
12. ## Thread: Autofill AAAA-AAAB etc

by shg
Replies
15
Views
239

### Re: Autofill AAAA-AAAB etc

UDF?

A
B
1AAAAA1: =ColLtr(ROW() + 18278)

2AAAB

3AAAC
13. ## Thread: Noticed odd new functionality after upgrading to Excel 2016

by shg
Replies
3
Views
68

### Re: Noticed odd new functionality after upgrading to Excel 2016

You're welcome.

by shg
Replies
1
Views
66

### Re: Using Application.OnTime

You can pass scalar arguments, it's just a little fussy:

Sub main()
Range("A1").Value = "Bob"
Application.OnTime EarliestTime:=Now(), Procedure:=CallString("mySub", "Test", "A1")
End Sub...

by shg
Replies
3
Views
68

16. ## Thread: Erasing Arrays after use question

by shg
Replies
3
Views
101

### Re: Erasing Arrays after use question

You're welcome.

More compactly,

Function IsArrayInitialized(av As Variant) As Boolean
On Error Resume Next
IsArrayInitialized = Not IsError(UBound(av))
Err.Clear
End Function
17. ## Thread: decimals to feet and inches with excel 2002

by shg
Replies
6
Views
126

### Re: decimals to feet and inches with excel 2002

Or =B1 & TEXT(C1,"' 0 #/##""")

Is there a question?
18. ## Thread: Erasing Arrays after use question

by shg
Replies
3
Views
101

### Re: Erasing Arrays after use question

Function IsArrayInitialized(av As Variant) As Boolean
Dim i As Long

On Error Resume Next
If IsArray(av) Then
i = UBound(av)
If Err.Number Then Err.Clear Else...
19. ## Thread: Does 'On Error Resume Next' reset error?

by shg
Replies
1
Views
57

### Re: Does 'On Error Resume Next' reset error?

It does, but I would use Sub B just because it makes clear what the code is doing.
20. ## Thread: Scientific Notation Removes values when converting cell to Number

by shg
Replies
3
Views
151

### Re: Scientific Notation Removes values when converting cell to Number

You're welcome.
21. ## Thread: Scientific Notation Removes values when converting cell to Number

by shg
Replies
3
Views
151

### Re: Scientific Notation Removes values when converting cell to Number

The data needs to be imported as Text and remain as text. Numbers in Excel (64-bit IEEE Doubles) only every display a max of 15 significant digits.
22. ## Thread: Randomly Distributing a Sum Over Cells

by shg
Replies
5
Views
227

### Re: Randomly Distributing a Sum Over Cells

1. Copy the code below from the post
2. In Excel, press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window...

by shg
Replies
5
Views
227

Like this?

A
B
C
D
E
F
G
24. ## Thread: creating BINs by altering variables

by shg
Replies
12
Views
276

### Re: creating BINs by altering variables

You're welcome.
25. ## Thread: creating BINs by altering variables

by shg
Replies
12
Views
276

### Re: creating BINs by altering variables

You can't enter the +/-; it comes from formatting.

Just enter 2.5.
Results 1 to 25 of 150
Page 1 of 6 1