division

Hi guys, I'm trying to find a formula that will find the second biggest number that can be divided by another number, with remainder of 0. Basically, I want to do an exact division with the second biggest number. Is there any formula to find this number? For example: 4 is divided by 1, 2 and...

Hello, Been trying to figure this out for a few days now, and starting to drive me crazy. Sub Annualize() Dim WB As Workbook Set WB = ThisWorkbook Dim WS As Worksheet Set WS = WB.ThisWorksheet Dim Range1 As Range Set Range1 = WS.Range("B2:B4") Dim Range2 As Range Set Range2 =...

Hello everyone, I'm assuming this is the ideal function, but I could be way off. Issue on "data" page: Need name of employee (column E) to register a "Division" (e.g. Administrative, Maintenance, Shipping, Production) in another Cell (column W) On "Employees" page I have a the four "division"...

Hi, Is there a formula that would return an integer from a division calculation? For example: A1 will contain a varying non integer In A2 I would like to show the integer from dividing the value in A1 however, this division is limited by a set number. If A1 = 2.962 this number should then...

Hi Can anyone help with a VBA code that makes a Hyperlink to cells? This Workbook is a staff list where in column "E" it is possible to use a Hyperlink next to each person to see a photo The path to the file is e.g. C: \Users \ Division \ Staff \ 38543_Benny_Mcgee \...

Is it possible to format half of a cell with a different format? I'm using =TEXT(G5,"0.00")&CHAR(10)&TEXT(E5,"0.00") and would like to format the first half with an underline so it looks like a division. Like this 1267.98 66.21

Dear all I am trying to find the minimum value in the array Stress(i,j) The maximum value appears correct. However the minimum value always appears zero if all the elements are positive. Kindly help I am posting the code below Private Sub CommandButton1_Click() Dim i As Integer Dim...

I don't know if excel will work for this so let me know thoughts. Trying to create a macro to create a racing schedule. Criteria : Multiple clubs, each club might have 1 to 6 teams. 2 teams race at a time against each other. Each race might be a 3 of 3, 4 of 4, 5 of 5, or best 3 out of 5...

Hi I'm making a spreadsheet that tracks game data in League of Legends. In ranked mode you're placed in a division and have "LP" (points from 0-100 where 100 can promote you to a higher division). So I wanna make a chart of this and what i have is shown in this image: https://imgur.com/NTlJKw8...

I am not much good at this and any help would be appreciated. I can’t drag formula down column. =Sum($E59:E164)/105 =Sum($E59:E165)/106 Note division is Ascending by each entry Drag gives: =Sum($E59:E164)/105 =Sum($E59:E165)/106 which is correct...

Hi All, I am not sure that this is the correct place to post this, but I have a VBA question. I found a set of code online to do what I desire, but I need to modify it to suit my needs. What I am doing is this: I have a set of Names and values separated in my excel sheet as "Divisions" ex...

I have a sheet titled "scores". Columns are name (text), division (text) and Score (number). I would like create another sheet (Awards) that displays the 1st and 2nd place winners (highest scores) in each division from the "scores" sheet. example: Name Division Score Bob...

I have a spreadsheet with a list of names for which I have to do lookups to in order to get specific information. In my data table I have: <tbody> NAME DIVISION ROUTE Smith J Technical 5268 Brown RS Legal 276634 </tbody> In my working sheet I have a list of names in col A as follows...

I am using Excel 365, and for the life of me I cannot get to produce a Pivot table from two ranges. Each range has three columns, with the same headings and the same data formats. I am calling up the PivotTable wizard, selecting the Multiple consolidation ranges, but when the pivot table is...

Hi, I have a table of data that looks like below. I need to be able to rank seperately both the TS & TM division sales whilst only looking at certain criteria, in this case 66 and 67 but these numbers just a small sample. My actual worksheet is a dump with over 30 different Area's...

I am calculating the % change between unit sales year-on-year, but if the movement is greater than 500% either way I don't want the formula to do anything, and similarly if there are no figures to compare in prior years then I don't want the formula to return an error (because of division by 0)...

hi all, i can't seem to find anything on passing the name or caption of a form control button into a macro. I am setting up a divisional report that uses the same base data. Users are to select the button with their division name on it, and this will then export the filtered contents to a new...

...but after days of dedicated Googling that have not yielded results, I need help. In a nutshell, I use huge datasets to run a dashboard and to make it work I need to relabel each line of data to tell me what Division it applies to, and what Function. Bearing in mind these are workforce...

Why does this not work? Dim DataArray(1 To 10, 1 To 10) As Variant Dim a As Integer, b As Integer a = 1 b = 0 DataArray(1, 1) = Application.WorksheetFunction.IfError(a / b, 0) I expected the above to return 0. Instead I get a division by zero error message. Thanks

Hello, I'm hoping someone could help me out with a file I have at work that is taking lots of time. We get a report with multiple division's information on it, and we have to filter down for each division on each tab (removing the other divisions), and then email out the files to that...