multiple

So, I have a several locations. Lets say Phoenix, Goodyear, Avondale. For each location, they could have a number; 1, 2, 3, 4, or 5. Keep in mind, the location and numbers can be listed multiple times on this sheet. So what I need is, for the Location of Phoenix, what is the total amount for...

Hi I want to add time then multiple the result by rate which is 10. So I have my time formatted as hh:mm then I used =Sum(B1:B4) to find the total which is 21:00 Now I want to multiple 21:00 by 10 to find how much to pay I got 18:00, clearly that is wrong. So I convert the total pay cell to...

I cant seem to get my head around SUMIFS and VLOOKUP, Im currently using: =SUMIF('Gas July'!$B$2:$D$217, VLOOKUP($A3, 'Gas July'!$B$2:$D$217, 1, FALSE), 'Gas July'!$D$2:$D$217) Which points to a sheet with only July Data and multiple sites and it gives me the number I want (total usage for...

Not even sure if this is possible. I have a workbook with 31 sheet and want to st up an extra sheet that pulls all the data from A22 to h42 into a list to look like 1st A22 B22 C22 E22 F22 G22 H22 1st A23 B23 C23 E23 F23 G23 H23 and then so on that I can then drag to change the "1st" to...

Hi Please help, I have the code below where I have multiple sheets rows from A:Q and the source is B which is the date what I want from oldest to latest, B1 is the header so it should start from B2. I am gettng an error on the 'Next' Private Sub CommandButton2_Click() Dim wksht As Worksheet...

I’m trying to set up a table where you can have multiple dynamic lists. For example, column 1 has a drop-down list containing the asset group, column 2 would then have a sub-category if there is one otherwise it would remain blank and column 3 would then show the correct assets attributable to...

Hi. I have a spreadsheet that has two rows of data both with multiple columns. One row has 16 columns of data and the one below has 10 columns of data. ABCDEFGHIJKLMNOPQRS 12345678910111213141516 12345678910 Does anyone know the formula to display the data as one row adding the data from...

Hi all Im using the index match feature with multiple criteria to get a returned value, but its slowed the sheet to a crawl. Any other ideas to return the text value? Im not great at VB I should mention its a shared document and I think arrays have issues with it being shared...

I have a column of number values and need to find a give amount which could be a multiple of 1 or more of those numbers. Is this possible in excel?

Hi All, I have a data of all positive and negative values like -400 200 200 -100 100 -500 250 250 300 -150 -150 I have multiple formulas to identify the matching numbers but all i want is modifications I have data in A1:A100 I use the B1...

Hello, I have a spreadsheet with tens of thousands of formulas like the following. I've split it over multiple lines for readability. =IFERROR(IF(K156=0,0, IF($J156<=AC156,AC$2, IF($J156<=AD156,AD$2, IF($J156<=AE156,AE$2, IF($J156<=AF156,AF$2, IF($J156<=AG156,AG$2...

Issue: Multiple duplicate values in excel cell. I have multi column data A to AA. In some cells I have multiple duplicate values in each cell (contains numbers and alphabets and special characters) separated by comma. How to remove multiple duplicates and keep only the unique values in each...

Good day, I am new to the VBA code for excell. I am trying to automate a process for my small business. I am trying to create a macro to find multiple values, one of them is "B00ZL31582". All i came with so far is: Cells.Find(What:="B00ZL31582", After:=ActiveCell, LookIn:=xlValues, _...

Hi everyone, I have an excel problem that I am stuck on, appreciate any help! Goal: To identify the total sum of each company in a specific stage based on a Date criteria. For example: <colgroup><col span="4"></colgroup><tbody> Client Action Date Stage Amount Company A 1/1/2019 1 $100...

How can I filter multiple columns by color?

Hi all, So I am writing a code to select multiple columns. Here is what my code would look like: Columns("B:B")... Columns ("E:E")... Columns ("H:H")... Is there an easier way of selecting all of those with only one "Columns"? The ... is there just for the example. Thanks in advance.

I have a large worksheet used for creating daily reports on a monthly basis. I am trying to create a macro that will clear the data entries in order to create a blank worksheet that can be used as a template. The workbook contains a lot of pages but the ones that are currently giving me a...

Hello there, Can we create pivot table from multiple sheets? I have 5 sheets in a workbook and their column orders are identical. I need to create one pivot table using all 5 sheets as source data. I can't combine the 5 sheets into 1 due to the volume of data. Thank you!

I would like to find some function or VBA code to count how many rows contain 3 specific numbers in columns B: to G: i.e how many rows contain 1 & 2 & 7 <tbody> A B C D E F G 1 David 1 4 7 8 9 10 2 Andrew 1 2 4 5 7 9 3 Steve 2 3 4 6 8 10 4 Bob 3 5 6 7 9 10 5 Harry 1 4 6 7 8 9 6...

Hi, I'm in the process of trying to consolidate multiple sheets into one. Sub Consolidate_Data() ' Copy Data onto one sheet Sheets("Data1").Select Range("A3").Select Range(Selection, Selection.End(xlDown)).Select Range("A3:S" & Range("A" & Rows.Count)).Select...