table

Hello excel experts. I'm trying to create a checkbox in column B, linked to column C, for each new row that I create in a table. I have this VBA code that I'm testing and its a mix of recorded macro and code found on the internet: Sub ButtonClick10() Dim lastRow As Long Dim sh As...

Hello all - I have a question, please: Col A has values. Col B checks a condition and returns true or not ("Y"). If Col B returns TRUE, Col C stores Col A's value. Col D repeats the stored value so that: Col E can check Col D against a different condition, and returns TRUE or not. This...

Greetings all - I am stumped on how to accomplish this and would be very grateful for any help or suggestions, thank you! 1 - I have rows with prices in them in a table: open, high, low, close (cols ABCD) 2 - Col E has a formula that identifies a condition. For simplicity's sake, I am hand...

Hi, I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance. I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list...

So I'm working with a horizontal table that tracks a count of calls per week per employee, currently formatted as Name 1/3-1/7 1/10-1/14 1/17-1/21 1/24-1/28 1/31-2/4 2/7-2/11 EMPLOYEE A 249 292 107 212 226 218 EMPLOYEE B 425 447 214 203 419 352 EMPLOYEE C 429 459 397 382 362 372...

Hi, I am add a simple sum calculation to a pivot table which will multiply column 1 with 2. I have added a calculated field with the following formula ='Unit'*Quantity However i have noticed that a lot of the totals are showing incorrect. Is there a different method to calculating this? Thanks

Hello all, I have a table that will have over 800 records when done. We need to be able to select a RANDOM 5% sample for auditing. The data that we will be using to determine selection will be in column A:A (Tracking Number). I have been looking at RANDOM, RANDBETWEEN, and INDEX. I also...

Hello, I have 4 sheets in a workbook (Sheet1, Sheet2, Sheet3 and Sheet4) On Sheet1 I have a dropdown in B1 to select from a list of fruits. For eg. Apple, Banana, Cantaloupe, Below that dropdown there is a "Store" table with headers Store(A5), Isle(B5), Shelf(C5) On sheets 2,3 and 4, I have...

- OS : MacOS and Windows (tested on both) - Excel version : 16.64 - Issue When I do SHIFT + drag & drop a column within an Excel Table (it's NOT a Pivot Table, it's a normal Table), it will mess up with the column widths. It doesn't behave like this when it's not a Table. - Screenshots of...

Hi, I have a data list and a userform to add additional row(s) with data. I would like an error message to pop up whenever duplicate data is entered in the according userform field on the basis of a specific column in a named table. A blank entry field is admitted, but no duplicate entries. I...

Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers? If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%? We are rounding down on both years of service & company growth. Company growth: greater...

Hello, I'm a little new to Excel and completely new to this forum. I've run into an issue I cannot wrap my head around since variations work just fine but I feel I'm missing knowledge nobody inhouse can teach me, but I'm trying to understand why my formula isn't working. I'm not native English...

Hi Team, I am working on a worksheet event. My requirement is whenever new data is added to the table I am trying to call a macro. (My table has been connected to Mysql database) Private Sub Worksheet_Change(ByVal Target As Range) Dim Records As Range Set Records = Range("Stockout") If Not...

Hi Team, I have connected my table to MySQL Database. If any data is updated in the database I will get it in an excel table. If any data is added newly I want to trigger a macro. How it's possible? I tried the worksheet Change event but did not trigger the macro which I stored in Module...

I'm experiencing an issue with exporting the contents of a Word document to PDF. After pasting a table from Outlook into Excel, certain parts of the table are retained, then the new table is pasted into Word. The Word document is saved using a specific filename, the date, and a number to...

Hi, i have data in a row formula: Month Product 1 Product 2 Product 3 January 122 344 4555 Februar 556 555 655 I need to make a new table where the row is changed to column, i have tried with INDEX MATCH to no avail, i need to make it Lookup both in Rows and Columns in order to make...

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...