Replies

You can’t specify the font size for the combo box from the Forms toolbar, the only way to increase the font size is to increase the zoom percentage for the worksheet.

Actualy, in Excel 2004, one can control the font and its size of a Forms Listbox or combo box by modifying the Normal Style.
Too bad the height of a list item doesn’t adjust accordingly. (make the size to large and you’ll only see the bottom half of the letters in the listbox.)

perhaps

SalesmansDiscount = MIN(totalDiscount/2, .05)

CompanyDiscount = totalDiscount – SalesmansDiscount

You might also try TextToColumns, setting format General in the last dialog screen, to do a quick conversion from text to number.

http://en.wikipedia.org/wiki/Greedy_algorithm

Both Advanced Filter and the database functions (e.g. DSUM) treat naked text (e.g. “Cat”) in the criteria fields as if there were wildcards.
“Cat” returns the same as “=Cat*”.

I suspect that it comes from a blank in the criteria field, being treated as ALL. “” is the same as “=*”

You could make ws1 and ws2 functions rather than variables.

Try formatting the column with the custom format “123”@
(quotes included)

I don’t have 2007 so this is untested. It looks like the dates in A4:A20 are Excel serial dates, rather than the text that formula is testing against.
=SUMIFS(C4:C20,A4:A20,”>=”&DATEVALUE(”01/01/2008”),B4:B20,”Steve”)
I don’t know if
=SUMIFS(C4:C20,A4:A20,”>=”&DATEVALUE(”01/01/2008”),A4:A20,”<"&DATEVALUE(”02/01/2008”),B4:B20,”Steve”) will be accepted, but
=SUMIFS(C4:C20,A4:A20,"<"&DATEVALUE(”02/01/2008”),B4:B20,”Steve”) – SUMIFS(C4:C20,A4:A20,"<"&DATEVALUE(”01/01/2008”),B4:B20,”Steve”) should work.

If you want January of any year,
=SUMPRODUCT(C4:C20,–(MONTH(A4:A20),–(B4:B20="Steve"))

The formula =SUMIF(C:C,1,H:H) will return the total Profit Sharing for group 1.

This form handles a range that starts after column A.

{=MAX((myRange=”B”)*COLUMN(myRange)) – (COLUMN(myRange)-1)}

I couldn’t convert your workbook. However,

If you wanted SUMIF(A1:A10, “x”, B1:B10) to be restricted to the visible rows only, you could create a helper column C, where C1 = SUBTOTAL(109,B1) and drag down.

Then =SUMIF(A1:A10, “x”, C1:C10) would give you the sum of the row B values that 1) have “x” in column A of the same row and are visible.

Perhaps something like

Private Sub ListBox1_Click()
    With Me.ListBox1
        If .ListIndex = 1 Then .ListIndex = 3
    End With
End Sub

=Trim(Split(myVar,”(“)(0))

Enter numbers from 0-1 in column B of the attached or change the current values.

=IF(SUMPRODUCT(–(A1:A1000=”Smith”),–(B1:B1000=”H2014″))*SUMPRODUCT(–(A1:A1000=”Smith”),–(B1:B1000=”H2015″))0,”Duplicate”,”All same”)