table

Hi all, i hope you're doing well. First of all, sorry for bad English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula lately. It's quite helping with my daily Excel use. I have a one case where i want to divide its own cell using a value from another cell...

So I'm trying to return a cell value from a table, relating to a text based cell as the searching tool. It's actually part of a larger formula, but the rest is straight forward. I am trying to return a result where if the day of the week changes in A2, it changes what cell I use in a formula in...

I have a table with 3 columns, whose fields I show below: ABCDE123Customer_IDProcess_NumberFolder_Name41234P0000000011234 - 155678P0000000025678 - 267D4:D5D4=[@[Customer_ID]]&" - "&[@[Process_Number]] The [Process_Number] Column, has the Format...

Hello, I have a feeling the answer may be no, but I'm looking to create a table - linked between Excel and Word - where part of the table is Excel data -> Word, and the other part is Word -> Excel. I would like my staff to enter comments against each student, but have been told by many that...

I've been working all day to no avail. Not sure why table is not filtering when activating this macro. Option Explicit Sub AgentFilter() Dim aQuery As String Dim LastRow As Long With sh_AGENTS LastRow = .Range("C999999999").End(xlUp).Row If...

Hi, I am looking a formula to search a table say D and 5 to return "Red" if someone could help please.

I have a large table of prices. The column headers in the top row have titles with some duplicates which can't be changed. I can't break up the table into more than one. Those column headers in the top row also are used to produce a validation list. But that list first shows up in a spill list...

Hi all. I have a sheet with selection options in database format: Tag Value A 123 A 234 A 321 B 12 B 34 C 1 On a second sheet I want the cells to have a dropdown list based on the filtered value of the database. The value which should be filtered on is in the header row, e.g...

Hi All, I struggled a bit with the title - so I'll try to explain more clearly. I have created a Table in Excel, which I intend to share with a selection of users to populate. This will result in a indeterminate number of rows being populated. Each column in my Table (10 columns in total)...

Hi, Very grateful for anyone's help or advice! I have a table called "CR_Table" - I'm looking to add some VBA code to insert a row to the bottom of the table when I click on a button, copying the formatting/ formula from above. Please could anyone let me know what code would help me do this...

Hi Everyone, I hope I can find an answer in this forum :) I'm working on formatting 20 finance tables in Excel for Mac and want to create a system for future use. The goal is to make it easy for our finance team to format tables consistently. So I've formatted a table with various styles...

Hi, I have an excel sheet that need to look for values in a table. I want to select from a dropdown a BRAND, then when I select the BRAND I want a unique list of all the models for that BRAND. Then select a MODEL and have the next dropdown have a list of all the SIZES... First picture is the...

Hello masters of excel! I need advice... I have a data set or a table with about 6000 rows and about 20 columns of text and another 15 or so with some formulas splitting some strings then DATEDIF and then converting to years and months a few times over.. So.. Not a huge amount of of data but...

Hi Everyone, I have a 30 column table in excel, and the first 6 columns are getting data from a sharepoint list connection, however when I delete or add a row in sharepoint list only the first 6 columns of the table are being removed/added and the other columns are just shifting up/down. How do...

Hi Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data. I have tried doing this with pivot/unpivot but struggling to get my head around it...

Okay, I have several tables on several worksheets. I have another table that lists all the formulas from the other tables, so that if I ever get hit by a bus, and someone wipes out the original formula in the other table, they can find it here. I am only using formulas in this spreadsheet, as...

So i have this table here: DEFGHIJKL4#BewerbungslisteOrtDatumPortalStatusLetztes UpdateTage seit BewerbungKommentar51Roland Deeg GmbHKirchberg an der Jagst23.10.2023Bewerbung per HomepageAbsage22.11.202338Die Bewerbung ist 38 Tage her62JMS AG Jet Maintenance &...

For Excel VBA, I am trying to make a code which looks at the value in the column "case type" and let it paste a formula or clear a cell, based on said value in the cell of the column "case type". For Case type 1, Column 1 should contain be cleared of any values and Column 2 should contain...

I managed to have to make it partially work; however, it copied and pasted a whole range from Data sheet - I want only the row that matches C6 from Entry sheet . Here is the code: Sub Find_Order() Dim entrySheet As Worksheet Dim dataSheet As Worksheet Dim checkSheet As Worksheet...

Hello Everyone, I have got a data model at hand with several dimensions including date, hierarchical and structural fields as seen in the table below. What I now would like to do is to calculate sales for upcoming months of the current year. How it's supposed to be calculated is shown in the...