2nd

Hello, I'm a beginner when it comes to formulas and this particular spreadsheet is giving me 2 issues. The zero amounts in the 2nd column need to be blank. I got the first one to work but that's it. Then I have a problem where the 859910 is the second column shows up. It needs to be the...

Hi all, A pretty simple question but I am stumped. Say I have "Room Revenue" for 30 days in the month of October. Room Revenue | 30,000 |1st Oct Room Revenue | 30,000| 2nd Oct Room Revenue | 29,000 | 1st Oct Is there any way I can get the final value to sum up all Room Revenue for 1st Oct...

Forgive my noob Q, but I'm mostly self-taught :/ I want to go to a 2nd open workbook, go to a specific sheet within that workbook, and select a specific range on that sheet. I currently use 3 lines: Windows("data_file.xlsm").Activate Sheets("raw_data").Select...

Hello, Marcelo helped me with a sumproduct formula that would only return results that matched a certain criteria. this is the formula "=SUMPRODUCT(($C$2:$C$6)*($A$2:$A$6=$G2);($D$2:$D$6)*($A$2:$A$6=$G2))" criteria is on G2 (b), criteria array on A2:A6. Result is 4,9. But I want a 2nd...

Hi guys I have a two dimaentional array said ' My Array' in my vba procedure which stores person names in first column and cities names to which the person in 1st column has visited , in 2nd column. My need is to count the unique city names in the 2nd column. How can i count that. Data stored in...

Hi all, I have the following formula I am using to pull a corresponding date: =IFERROR(TRUNC(INDEX(ClosedOn,MATCH(A3&B3,ClosedName&ClosedMainAssignee, 0))),"N/A") My question is this, I have exactly one situation in the subset of data where Ax & Bx are respectively the same twice. The formula...

I want to create two cell, 1st cell value will be between score 0-100, 2nd cell will be shown in % based on the value in the 1st cell Example: 1st cell is A1 and 2nd is A2 When A1= 98-100, A2=100% When A1= 97-91, A2=90% When A1= 90-86, A2=80% When A1= 85-81, A2=70% When A1= 80-76, A2=60%...

hi I have 2 sheet in my workbook. 1st sheet is where is my item will be enter(down direction). 2nd sheet (Singe item) is my data bank which collected what are being entered in 1st sheet. Below is my vlookup formula =VLOOKUP(A3,Sheet1!$B$2:C20,2,FALSE) Problem is when duplicate item(common)...

I have for columns and am trying to create a formula that will place "X" in the first column if: 2nd column is greater than 11 and the third column is greater than 85(regardless of the value in the fourth column), or the 2nd column is greater than 11 and the forth column is less than 1.5...

Hi - I have been working on this for a while and cannot figure it out - your help is greatly appreciated!! I have a tab with a list of employee codes and their hours worked. I have a 2nd tab with a list of employee codes and their cost. I have written the formula to multiply them together -...

<tbody> A B C D E F G 1 2 1ST 2ND 3RD 4TH 5TH 3 -89.8 -89.8 -89.6 -35.2 -7.4 -15.5 4 22.4 -89.8 -89.6 -35.2 -7.4 -15.5 5 52.3 -89.8 -89.6 -35.2 -7.4 -15.5 6 1 -89.8 -89.6 -35.2 -7.4 -15.5 7 -89.6 -89.6 -35.2 -7.4 -15.5 -13.8 8 -35.2 9 -7.4 10 -15.5...

I am trying to get the DATA in my "Transactions" sheet to filter in 2 columns. The first one filters col A to "0" and the 2nd filters to the data in O1 cell. But it fails out every time on the 2nd filter with Run-time error '424' Object required. Any help is appreciated. Below is the part...

Title

Hi All, I am looking for assistance for a mathematical formula to be able to turn my assessed win betting prices (win %) into place betting probabilities. The below should explain the equation a little further. <tbody> W% 2nd % 3rd % Horse 1 35 Horse 2 15 Horse 3 13 Horse 4 10...

Hi, I am looking for a formula to find the 1st, 2nd and 3rd smallest value for the date of the "Date" column which has the same code in "Code" column. Formula to give space if cell in "Date" Column is empty or if code is repeated in column C, D or E. as shown in the table below. <tbody> A B...

I use the Following Conditional Formula to highlight rows if multiple cells together are duplicated: =SUMPRODUCT((col_b=$B1)*(col_C=$C1)*(col_d=$d1)*(col_e=$e1))>=2 and it works fine except it highlights all instances not only 2nd or 3rd or more duplicates as intended I've tried countifs...

Sub PowerQueryRefresh() ActiveWorkbook.Connections("Query - Actuals").Refresh ActiveWorkbook.Connections("Query - SFDC").Refresh ActiveWorkbook.Connections("Query - PW Most Likely").Refresh End Sub Hi All, I have just upgraded to Excel 2016 and I am wondering if excel 2016...

Hello, Is there any method to start a new paragraph for a long text which uses "Concatenate" within a cell. eg. =Concatenate("aaaaaaaaaaaaaaaaaaaaaaaaaaa ","bbbbbbbbbbbbbbbbbbbbbbbbbbb") I would like to get the 2nd text ie "bbbbb..." as the next paragraph within the same cell...

Hello everyone my name is Brandon and i'm new here. I am having a problem with coming up with a formula and was hoping someone could help a new person to excel. I have made a spreadsheet report that splits up a 8 hour shift in half cause we our overtime is done by half shifts. I was hoping...