multiple cell values

Hi Board, Does anyone has advice about this problem. I have this 2 sample table ("A1:D11" and "F1:G6") <tbody> A B C D E F G 1 Grouping Date Data name Data value Group Multiplier 2 1 1/1/2017 Need to multiply 6 1 2 3 1 1/1/2017 Not need to multiply 10 2 6...

Hello! I'm trying to figure out how to show the same row when different criteria are used in the same column. It's a little hard to explain clearly what I'm trying to do so I'll just use an example. Say I have big spreadsheet with thousands of rows that refers to projects that takes place in...

I'm trying to have my macro check if cells in a row on two different sheets match. I'm able to get it to work using And & Offset, but I'd like to know if there's another method to accomplish the same thing in a shorter code. This is essentially what I've got so far: Dim Sheet1 as Worksheet...

Hi, I would like to select multiple cells in VBA and output them into a selection of cells. However the output only shows the first value of the range. This is the code I have at the moment. Sub CopyCells() Dim CopyData As Single CopyData = Range("f4, f7, h7, j8, l6, n7, n10").Value...

So I've applied conditional formatting to columns A and B to highlight and bold any blank entries. However since those guys tend to show up a thousand rows or so down I don't have anything to alert me that there is a problem. I know that I can just filter those columns to check but I'm not the...

Let's say I have three columns where column C can contain "multiple" values like "John, Pete" instead of just "John" or "Pete". See table below... Is it possible in some way to make the slicer for Column C just show the unique values "John", "Pete", "George", instead of the combined ones like...

Hello! I found a way with using INDEX and SMALL formulas to return multiple occurencies of the string in many rows. The formula is simple and a power tool, here is an example =INDEX($B$2:$B$16;SMALL(IF($D$2=A2:A16;ROW(B2:B16)-1;"");ROW()-5)) The only thing that bugs me it this last ROW()-5. Each...

I've got a decent background on VLOOKUP & CONCATENATE, but apparently those 2 fall short of exactly what I'm looking to do... (I'm pretty sure I need Index & Match, but I'm not doing a good job of teaching myself...) Sheet1 contains a table of 'color packs' (table below shows A1:E6. Column A...

Hey All, I was trying to do something, but this is not working, clearly. I would like to filter a table according to 1 column. I want to filter those values, which are named "AA" and "BB" and have a color of white or green, RBG codes are in my command...

I'm wanting to get a count of values. The values are in text form with alpha and numerical, example: AL1, FF2. I looked at SUMIF and SUMPRODUCT to potentially accomplish this. I'm wondering the best course of action to get a total. Here's what I'm looking to do... I have a list of reports...

Ok everybody this is my first post and I am completely stumped! I work for a company where we track our employees times by using gps time stamps through an iphone application. Here is the way I invision the spreadsheet working. The Meta data from the gps pings from the employees phones comes...

Hello, I am looking for the proper syntax to generate a sum of the bottom-most cell in each column across multiple worksheets. My current formula looks like this: =VLOOKUP(9.99999999999999E+307,'Z:\Warehouse\Inventory 2013\Spray Pens\[Spray Pens.xls]Anti-Static'!D$1:D$300,1) but the above...

Hi all. I am a beginner excel user and new to the forum. I have a very large list of sales reports that I am trying to total up many different ways. Pivot tables work for much of what i'm doing, but I would also just like to try a simple formula for others. Here's an example: Find total of Red...

Need help with IF statement looking at ranges containing text. In summary form - we have a workbook with sheets represented below. Each month we want the highlighted cell to change to the # in sheet 2 where the month matches on both sheets AND sheet 2 reflects "ACTUAL" for that matching month...

Hi all, i've got a worksheet "patiënts" where in each row fore some columns (hours) a therapist is defined. Now i want to generate a new tab where i can see for each therapist the time and the patiënts he/she needs to treat. From ther i can generate a planning overview If there is a moment...

Hi, I am trying to build a simple tool using an userform. I have my results as a range of cells A1:A10 in an excel sheet. The result will be like: 1-1 2-4 5-8 8-8 9-14 14-14 15-16 17-19 20-21 22-23 But I want the result to be displayed in one textbox in userform.Is there any way?