place

This one has got me puzzled and I'm sure there is a simple solution. I have a long list of rankings for various statistical tests, i.e., A 1 B 2 C 3 A 2 B 3 C 1 and so on. I just want to determine how many 1st, 2nd and 3rd place rankings of A, then of B, etc. There is no real range to use a...

Can I place specific value into an array and then use the array with a loop to delete row if value in array is in cell. i.e. Place West, North, South in Array then use the following code. dim arr as Variant For i = lastRow To 2 Step -1 If Ws.Cells(i, "H").Value = arr Then Ws.Cells(i...

Not sure why this code would not work. The result is False. Cells(1, 14) = Range("I" & Rows.Count).End(xlUp).Offset(1).FormulaR1C1 = "=sum(R2C:R[-1]C)" It does work if I remove the cells(1,14) portion - however I am looking to place the result in a cell rather than at the end of the range...

Hi All, I have quite a few tabs, I need to go into each one and add a "Total" column at the end. However my problem is I want to separate the currencies so if column A =EUR AND B has the corresponding value, I want to place this into a column marked "Total EUR", how is this done as there are a...

Hello I have a table with the following: <tbody> 1991 1992 1993 1994 Industry A Place A x x x x Industry B Place A x x x x Industry C Place A x x x x Industry A Place B x x x x Industry B Place B x x x x Industry C Place B x x x x </tbody> In another sheet I need to...

Hi All, In the red highlighted, how do place Range(A:AC) ActiveSheet.PivotTables("PivotTable2").ChangePivotCache ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "\\serverpath\[ANALYSIS.xlsx]Details!R1C1:R3C32", Version:=xlPivotTableVersion14)

Dear all, Please advise, is there any way to calculate the following task with excel? In document https://docs.google.com/spreadsheets/d/18wuUFxV_0p2Cr0G8xA4O2e0qi_lW0K060vM6RnDnCzU/edit?usp=sharing, There are 3 players. We are playing pingpong games. Each day we play two tournirs. In each...

Hello, A............B..................C..................D..................E..................F 1-------------------------------------------------------------------------- 2-------------------------------------------------------------------------- 3---------22 / 183---215 /...

Good day. I am seeking and very much appreciate some help. I have a table (see below). The table contains: Colum C-F - names of 50 people, randomly place Colum G - a date Column I - the names of the 50 people Column J-M - where I want to place the results of the search. The aim of...

I'm submitting a chemistry report but some of the elements are listed in % and some in ppm. I want to change all elements to %. The elements reported in ppm have an exclamation point in the cell containing the element symbol. I would like vba to copy each column and place the copied data two...

I have numbers across rows 10 to 25. Underneath (say row 45), I get the SUM of the columns above =SUM(A10:A25), =SUM(B10:B25), etc. When I add a new row somewhere in the middle of the rows, the bottom of the column SUM takes into account the new row =SUM(A10:A26), =SUM(B10:26), etc. But if I...

Hiya folks. I have a varying sized table pulling through from power query, for each change in date in column B which is sorted from low to high, I have 3 lines which denote change in date I currently manually move these Is there a way to auto place when change in date happens? Many Thanks

Which is the best place to enhance the financial modelling skills? If anybody know please suggest me.

Hi,I want to create different sizes of rectangles with inputs. Then I want to optimally place these dimensions in a specific area (ex: 80cmx160cm). I using method that start with biggest rectangle following firstly go bottom after move left if possible. Actually this method the same with tetris...

Following from this: https://www.mrexcel.com/forum/excel-questions/1045185-class-instead-array.html how would I adapt it if my code were: Do Until DataArray(j, 1) <> DataArray(j + 1, 1) ie the suggestion was: If myArray(i).Name <> myArray(i - 1).Name Then but my condition now...

When I use the following, I place the formula into the Spreadsheet and get the resulting row number. Range(emailColumn & FirstRow & ":" & emailColumn & LastRow).Formula = "=MATCH(B2,'RosterFileName'!FullName,1)+3" When I try this function in VBA I get different errors; syntax, compile error...

Hello , I have this macro that I need help to modify : Sub PrintSheets () Dim i As Long For i = 1 To Me.Pages.Value Sheets ("Page" & i ).PrintOut Next i End Sub Now my wish is to print two copies of each sheet (page) printed by the macro above. Then on the first Copy, I want to...

I am using the following in a loop to add 3 different images to a worksheet and then place in the correct location. Multiple files are created but use only the same 3 imagesSet objImage = ActiveSheet.Pictures.Insert(ActiveWorkbook.Path & "\Images\" & strImageFile) objImage.Cut...

We have a weekly excel file that records all our sales, inventory etc. I would like to be able to pull some of the information from last week’s file when I start this weeks, using ‘C:\Weekly\[week2]inventory’!$A$1 works, but to reset all the different cells defeats the purpose. What I would...