Search results

Hi Claudine, Weird in fact... Try this to create you radio buttons. 1. Create a groupbox 2. Insert one radio button inside the group box and link the cell 3. Hold CTRL and click on the radio button. While holding CTRL, drag your mouse to copy the radio button inside the group box (2 times)...

Hi, I'm from Canada (Quebec province). Domain used to be .com but now I see .ca ??? Weird... Thanks for suscribing!

Hi wymama, If I understood correctly, this should work : Sub ShowRows() Dim c As Range Application.ScreenUpdating = False For Each c In Sheets("Summary Sheet").Range("B1:B600") c.EntireRow.Hidden = False If c = 0 Then c.EntireRow.Hidden = True Next c Application.ScreenUpdating = True...

Hi, One way to do it would be to have a table in which you list your alpha/numeric characters in one column and their value in the other column. After, you can use a Helper column and the VLOOKUP function to get the real values and you sum on your helper column. Let's say your table is in...

Hi kimkay, I don't understand why you get TRUE and FALSE with the formula I suggested. Did you try evaluating the formula step by step ? You should have the same result as the formule you found.

Hi ahhhmed, To my knowledge, this is not supported by Excel and you can only repeat printing rows at the TOP of the page. Otherwise, you must use the Footer, which will be printed on all pages. Maybe it is probably something you can do with a macro but I guess it will be tricky.

Hi Kimkay, I believe this formula should work : =IF(OR(C4="D01",C4="D08"),IF(I4<50,I4,50),"")

Hi smc001, If I understood correctly, try this formula in column F and copy down. It will return 0 or the dollar amount : =AND(A1="COMM",OR(B1=1011000010,B1=1011000012,B1=1011000100,B1=1011000500))*D1 or this one, it will return the dollar amount or empty cell ...

Hi amabdullah, Here's a way to do it : - change your hyperlink formula to : =HYPERLINK("#"&A1&"!"&ADDRESS(D1,D2)) . A1 : sheet name of the employee selected . D1 : formula that gives you the row of the actual date . assuming that your dates are in column C, the formula in D1 should be ...

Hi Atul, You can use the formula NETWORKDAYS. For example: A4=NETWORKDAYS($B$2,B4-1,$E$3:$E$6) where you specify the start date (B2) the end date (B4) and a range containing the holidays (E3:E6) Note: I added -1 to the end date because both start date and end date counts.

Hi Sammy, Try this code in a new workbook, update the path where your CSV files are and run the macro. The name of each files will be written in Column A of sheet 1 of your new workbook. In column B, the number of rows of each file. Sub OpenCSVFiles() Dim wb As Workbook, wbCSV As Workbook...

Hi Kinghart, Unless you use ActiveX controls, I believe worksheet event will not trigger. You could use ActiveX controls but I prefer to use the following method : Instead of using checkbox, you can use a double-click event associated with column B. Something like this for example...

Do your 27 values to be sum are placed in 27 NON-adjacent cells ? Instead of: SUBTOTAL(1, A2, A3, A4) you can write: SUBTOTAL(1, A2:A4) Otherwise, switch to Excel 2007 as you can use 254 references instead of 29. ;-)

Hi Kinghart, This macro will execute when there is a change in your sheet. You must place the macro in you sheet module. Adjust the range as necessary. Private Sub Worksheet_Change(ByVal Target As Range) 'Macro must be place in the worksheet code 'Macro executes when there is a...

This should work, in D80 : =IFERROR(INDEX($C$19:$C$49,LARGE(IF($B$19:$B$49=$C80,ROW($B$19:$B$49),0),COLUMN()-3)-18),"")

Hi, To insert a column: CTRL + SPACEBAR and then CTRL + +(on the keypad) To insert a row: SHIFT+ SPACEBAR and then CTRL + +(on the keypad)

Try this array formula in D60: =IFERROR(INDEX($B$19:$B$49,LARGE(IF($C$19:$C$49=$C60,ROW($B$19:$B$49),0),COLUMN()-3)-18),"")

Hi ahhhmed, Try this formula : =IFERROR(INDEX($A$2:$A$8,LARGE(IF($B$2:$B$8=$C2,ROW($A$2:$A$8),0),COLUMN()-3)-1),"")

Hi ahhhmed, Assuming that your numbers don't always start with "8", you could use this macro. (the macro will add a "/" before the last character) Dim rg As Range Dim c As Range Set rg = [A1:A5] 'range containing your values For Each c In rg c = "'" & Left(c, 1) &...

I would rather use : =if(#of single +# of double*2 >= 30,#of single * 1800 + #of double *2750, #of single * 2950+ #of double *2250) difference : # of double *2 to count number of people.