table array

  1. P

    Scrubbing Mass Email List

    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. Attempted Solutions: In...
  2. S

    Format a table into two columns

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

    VBA overwrite table in sheet1 with table in sheet2

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

    Copy/Record Table Data to New Sheet after Power Query Refresh

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

    Two tables to manage data

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

    Statically Set Table Column on Table That Resizes

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

    Trying to get Max value from column in Table and get 0.. (VBA)

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

    Resultant value from a Multiple Table

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

    [SOLUTION HELP]: Copy data from cell and pivot table into new table format.

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

    Variable VLookup based on Cell Value

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

    Curious problem with a find and replace macro?

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

    Better way to input formulas in tables?

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

    Extract Rows/Cells from Master Table to Sorted Tables based on Suffix of Text.

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

    Updating Multiple Tables and Adding New Tables using a Reference Sheet from Master Workbook

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

    Does value exist in 2 or more table arrays (VLOOKUP)

    I want find out if B2 in Sheet1 exists in column B or C in Sheet2. If B2 exists in either column B or C in Sheet2, I would like to display Yes or True. If B2 does not exist column B or C in Sheet2, I would like to display No or False. For example: Sheet1 <tbody> A B C (Does value exist in...
  16. L

    VBA not finding correct value.

    Hello, i am working on a VBA that should find a match in the table column A of sheet 1 and match it in a table on sheet 2 and select column 6 cell value. but when i run the code it selects the wrong row and value. what i'm i doing wrong. Sub test() Dim ws1 As Worksheet Dim ws2 As...
  17. G

    VLOOKUP Table Array (different Workbook) Based on Another Cell's Value

    Hi All, I'm trying to VLOOKUP a value in different Workbook (could be Open or Close). However the Table Array information, I would like to get determined by the value of another cell so that in case if I have to change the lookup worksheet & its path in multiple formulas, I would have to change...
  18. B

    Using OFFSET and MATCH to return the correct value

    I have a problem with using the MATCH formula to return the correct 'ranking' from my named array. I have the following: Cell Q3 - with options VL,L,M,H,VH Cell R3 - with options VL,L,MLH,VH Cell T3 should return an overall rating depending on what the user has selected from Cell Q3 and R3...
  19. T

    Constructing new table based on elements of a pre-existing table

    Hi, I am having trouble working out how to construct a new table based on the elements of an existing table. I'm pretty sure it's a combination of VLOOKUP and MATCH but he could also use INDEX. Here is the master table: <style type="text/css"> table.tableizer-table { font-size: 12px...
  20. S

    VLOOKUP formula inside Table_array

    Hello, I am trying to have vlookup search another sheet for a certain value. The problem is I want it to search the sheets in the table_array based on one of the other cells. I want it to look at what value I have in b9, so the formula is =VLOOKUP(DATE(P5,1,1),B9!$A$3:$F$2520,2,TRUE) but when I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back