table array

Hi. I'm looking for an Excel formula that will do the following based on the table below: Column A Column B Apples No Apples Yes Oranges No Oranges No Oranges Yes Peaches No Peaches No I need a formula that will look at all the lines of Apples and if any of the lines has a...

Hello - I have two tables across two worksheets. Table 1 has activities/tasks (approx. 200) down column A and named individuals across row 1 (approx. 25) with input data being added into the table, say B2:Z200, so that you can assign one or more named individuals to an activity (and the same...

I have a cell suppose B1 = "APPL" I have a Table named "APPL_PRICE" which has Date column & Price Column. I want to VLOOKUP a specific Date( in A1) from the table using the reference of B1 Such as =VLOOKUP($A$1,APPL_PRICE[Date],2,FALSE) But instead i need to use reference of B1...

I'm fumbling around in the dark with this one as I can't get anything in play here that isn't a circular reference (Maybe that's the only solution though). So what I want to be able to do is create a dynamic list of parts based on their appearances in a table that aren't 0. The table looks as...

Good evening, hope someone can help. I am trying to create lambda functions that work in various tables in a workbook. The worksheet calculates "Year To Date" (a running total) and "Previous Year to Date" (YTD from the previous row) The functions are kind of long (especially the Previous...

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

Hi Excel Gurus, I've been working on this problem for days and tried numerous different formula to no avail, any help is appreciated! Problem: I have a list of 250,000 emails that needs to have all emails associated with lawyers removed (ex. info@lawofficexyz.com). Attempted Solutions: In...

I have a data table as shown below: 1 a 6 f 11 k 2 b 7 g 12 l 3 c 8 h 13 m 4 d 9 i 14 n 5 e 10 j 15 o What I need to do is take all the numbers and but them in one column and all the letter in a adjacent column. As shown below: 1 a 2 b 3 c 4 d 5 e ... ... Any help...

I have a schedule in sheet1 and a schedule in sheet2. I want to "subtract" the table range in sheet2 with the table range in sheet1. Sheet2 is the "skeleton" of the schedule, and the determined values in specific cells. Sheet1 is the "skeleton table", just with cells added afterwards. So i want...

Hi guys, I hope everyone is doing well! Just a quick question, I have a table on Sheet 1, with data that is populated using power query SQL source. My apologies if my question is a little confusing, I wasn't really too sure how to word it. What I'm needing help with is somehow making it so...

im at a loss here and describing it might be more confusing than simply presenting my dilemma, eitherway... i feel like it s easier to simply explain my current scenario than attempting to get the concept across: there s a col "groups" with certain "properties" in another col, which then...

I have a budget spreadsheet that has a table in it. Over the years, I just kept the table to 999 rows. This was more rows that I ever needed and things worked well. In some of my VBA functions, I would statically set the columns for items that I would look for. As they are static, I don't have...

Sub Macro1() ' Sheets("issue raw data").Select Range("Table1[[#Headers],[Amount of matches]]").Select highest = WorksheetFunction.Max(Selection) answer = MsgBox(highest) End Sub So I have numbers like 1,2,3,4,5 in column, but for some reason it results in 0. I tried to add Dim...

The File contains 6 tables. First 5 Tables named Apple, Orange, Mango, Grapes & Banana and it contains the data of it varieties and its respective cost. In 6th “Fruit” table, two columns are there. One is ‘Fruit name’ and the second was ‘variety counts’. If I choose any one fruit in a first...

Hello, I need your help on EXCEL VBA solutions as per below requirements 1. Copy pivot table data in cell A9:A11 and C9:C11 in to sheet OUTPUT per example in sheet output. 2. Copy data from sheet INPUT cell G32,G36,G37,K32 (cut only first 2 digits),K33,K34,K35 (cut only first 3...

Hello Everyone Can anyone help me with my formula I need to do a VLookup on a Cell but the Table Array needs to be different based on the Value of another Cell. =IF(B5="Office",VLOOKUP($B$9,matrix!$D$2:$F$100,2,FALSE),IF(B5="Production",VLOOKUP($B$9,matrix!$AG$2:$AJ$100,2,FALSE),"0")) Any...

Hi Folks, I have a column of data (column H) headed [customer reference]. Customer reference data is populated by users when they book a courier online. They have to input a client customer number (3 digits), a sales order number and a check digit, each element separated by a hashtag (so...

So I have 8 different tables, some with up to 65 columns, others less. Current I have formulas in the columns for those which need formulas. I kind of want to transition away from having the formulas in-cell, where they can be changed, erased, etc., to having them be coded. However, I am...

Hello fellow excellors, I have a number of assets that contain very specific suffixes, for example: XRD05_CV XRD06_CV XRD07_CV XRD08_CV_I XRD08_HB XRD08_WS XRD09_CV These assets are listed in a master table. as you can see, there are different suffixes such as _CV, _CV_I, _HB and _WS. Now I...

Workbook A (WB_A)is used by multiple people saved to their local computer. Saved in the same folder is another workbook (WB_B) that is used as a reference. WB_A pulls information from WB_B and populates multiple tables with rows. I need to be able to add new Tables to WB_B so that WB_A can pull...