table

Hi all, I have two sheets. Sheet 1 (“Overview”) contains raw data, Sheet 2 (“Charts”) contain XY plots. On sheet 1, I have a table with four columns. 1) Company, 2) Industry, 3) Metric one, 4) Metric two. Based on filters applied to the industry-column, I’d like the XY plot to automatically...

I have the following table: Brand Type ProductName Brand A 100 Product_01 Brand A 100 Product_02 Brand A 200 Product_03 Brand A 200 Product_04 Brand A 300 Product_05 Brand A 300 Product_06 Brand B 100 Product_07 Brand B 100 Product_08 Brand B 200 Product_09 Brand B 200...

I am trying to make a Data Validation list from one of my tables, but I can't seem to get the UNIQUE function to work in the Name Manager. If I create a new Name called "Sports" and use the formula =tblGear[Sport], it works just fine. However, I want the unique values from there. I don't want it...

I pulled data into excel from an API. However, it shows as list then record. I need all records expanded when I close and load, but can't figure it out. A few screenshots to help see what I'm trying to work with: I need the values: id, ticket_id, user_id, reason, and created_at. I do not...

Hi I have a SharePoint list exported to an Excel table which I'd like to keep as a live connection by using Data > Refresh All. I'd like to lock the table so it cannot be sorted, but that it can still be filtered. I tried this through Sheet Protection (only blocking sorting but allowing...

Hi I have 3 different tables: Stage 1, stage 2, Stage 3 I want to display one of these tables when a certain stage is selected from a drop down list or when entered into a specific cell. I want to do this on a separate (Summary) sheet. Is there a function or way I could do this? Thanks very much

Hello, I am currently tracking information for a variety of locations. I have nearly 450 different locations that i need to track identical information, I am counting specific equipment and separating it by a descriptive class. For example - at a specific location i would like to count the...

Hi, I have this pivot table with ranked values of 1Yr and 5 Yr returns of various funds. I am trying to create a calculated field column with 50%*Rank1Y + 50% Rank 5Y. However, the calculated field doesn't let you choose the ranked values as the base for the formula. I was wondering if there is...

Hello, I would like to look in a range to see if two ranks match, if they do I would like excel to output both team names into two separate cells. For example in my image I would like to get Team 1 and Team 2 as my output but separate cells. I believe I need an array formula? but I cannot...

Hello, I have a table with A, B, C and D down one side and A, B, C and D across the top, in the middle of that table are values. I want to get excel to then be able to find the value of any cell, for example A,C or D,B and so on, and provide the value. Any help would be greatly appreciated...

Hi, In power query when using the Table.FromList function, I add ; Splitter.SplitByNothing() after the source list, as it doesn't seem to work if you don't . It says in microsoft docs that the splitter is optional, I tried just putting the value null, but this doesn't work either, can...

Hi, I am struggling to make Textjoin work with an additional criteria. =TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],RawData[Issue Status]="",""))) I am using the above code, which works, but then i want to use the same one, but adding an additional condition, which should be the below...

Hi All, USing below as an example, im attempting to create a bar chart with only 2 bars but using all of the below data. So on the left hand side (y axis) will be the months, and the x-axis along the bottom will be the value scale going up in whatever say 1000s. The thing is I want 2 bars...

Hi Everyone, I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...

Hello all, I'd like to know how to have a table be automatically refreshed based on a filter. The thing is that I have 1 tab, where I paste some data (its a table), and then i have in other tab, another table which is populated taking values of specific columns from first mentioned table. And...

Can you please help me. If I want to check another column at the same sheet (and all other sheets in the array) what can I do? I tried to change sht = Array("E") to sht = Array("E", "K") in order to check both Columns and add it where the code paste the values, but no luck. I need to keep the...

Hi, I have the following code as I'm working on multiple selections: With ActiveSheet.ListObjects("Main") Union(.ListColumns(1).Range, _ .ListColumns(3).Range, _ .ListColumns(5).Range, _ .ListColumns(10).Range, _ .ListColumns(30).Range, _...

Hello all. I am trying to speed up some code that I have written. What I have works perfectly fine, but is quite slow. I would like to see if there is a way to increase the speed. My workbook consists of 3 sheets. The first tab (named "Access Data") contains a table (named "tblData") with 5...

I want to import a table from a client that a schedule is for 13 week after importing this file , check if there is 13 week if not add another column for the missing week with a 0 any idea ?

Hi everyone, I have a small question for you: Let's say I have a table with headers and I'm trying to calculate an average. I'm using the following macro to calculate it Sub Average() ' ' Average Macro ' ' ActiveCell.FormulaR1C1 = _...