multiple arrays

  1. H

    Category Mapping based on Multiple conditions

    Hi Team I am looking for help in getting require category mapping based on multiple conditions.... Here is the Dataset ... <tbody> Product Price Region P-1 360 N P-2 347 N P-3 452 S P-4 179 S P-1 345 E P-2 274 W P-3 207 E P-4 177 E P-5 177 E...
  2. S

    Lookup with multiple "or"-criteria

    Hi, I have been following the forum and it has provided me with some helpful tips along the years. However, this time I would have a problem I was not able to find an answer to. I would like to have a lookup or query function which contains multiple criteria which can also be in "or" format...
  3. T

    Array formula to sum data that meets multiple criteria.

    Hi, Everyone I am having trouble finding the best formula to calculate how much i spent on a particular item per year. The issue that I am having is when my monthly payment spreads across multiple years, I can't seem to create a working formula that can account for the cost that spreads into...
  4. B

    help with extracting multiple array data

    I have a project with a number of resources and different task to complete over a extended period. the maximum number of task assigned to an individual at one time is 7. I was planning to use a sum product which reference a drop down list of the resources,then task no, then date then tell me...
  5. G

    Help with Index match/countblank

    So I need to use Index Match and Countblank in order to arrange the number of parking spots I have available by using information from two sheets. The first sheet (Yard Configurations) is what we use for the arguments: <colgroup><col style="width:48pt" span="14" width="64"> </colgroup><tbody>...
  6. N

    Conditional Formatting: If at least one cell in a row contains at least 1 of 100+ options

    Is there a way to setup a conditional formatting formula to highlight if at least one cell on a row contains at least 1 of 145 possible codes. Column O contains a list of 45 codes. I need to know how to check that each row contains at least one of the 145 codes listed. There are over 1,000...
  7. B

    Using VLOOKUP across several arrays to return text

    Hi all, I am creating a database to search through medical journals. The way I have it organized is that I cannot use VLOOKUP to go through the list down vertically, and I must use multiple table arrays. As a work-around, I found this thread which shows exactly what I want to do, but the second...
  8. H

    Sum Product Query on mass amount of Data, 3 variables

    Good morning, Looking for a little bit of help on a sum product I have messing with my head! What i have is a mass expanse of data, 4380 lines long A-AZ wide, I need my Sumproduct to look over 3 conditions, Type, Wash and then week. Each cell will show me the total monies for that week, in...
  9. ProgramUser

    Look for offset value to the left from an array after only satisfying the match criteria of two sets first.

    Hi Excel Guru's, trust everyone is well today!!!.... I have been an avid reader of this excellent forum for a number of years and am a huge fan of Bill Jelen and Mike Girvin' work.....they have saved me many, many times. I can say the same for the many posters on this website who have also...
  10. A

    Autofilter data for multiple criteria and write name to all visible cells till last row

    Could you anyone please help me on below. I need my code to do following 1. filter for one criteria("=SE02") in column Q 2. Go to column R, write "AMC India" on all visible cells till last row 3. remove filter given in point 1. 4. Again filter for multiple criteria( ">= YC101", "<= MR107"...
  11. D

    Multiple text file importing

    Hi guys, I want to store data in 1 worksheet from multiple .txt files. Also, I want the first cell to contain the file name not the file path (if possible) so I can link it to the graphs later on. There is also AT MOST 7 columns in the data while the number of rows is variable and the first...
  12. A

    Shortening an index formula

    Hi, The formula below is a lookup using multiple values. It works well however I feel as if it could be neater. I am also bordering on the nesting limits if I would like to add any additional formulae. Could you please help me shorten it...
  13. S

    Is this possible - Internal LMS - only 250 records per page - 30 pages - 1 Import into Excel?

    Good Morning All! We have an internal LMS which houses courses and learners. For each of the courses in the system a maximum of 250 learners can be displayed on a single page. Some of the courses have up to 5000 learners which results in multiple pages to sift through. What I would like to be...
  14. B

    copying and pasting multiple columns to another sheet

    Hi All, Currently I have some code that looks like this: Range("A1:A30") = Workbooks(newbooks).Sheets(1).Range("A1:A30").Value Range("C1:C30") = Workbooks(newbooks).Sheets(1).Range("C1:C30").Value Range("E1:E30") = Workbooks(newbooks).Sheets(1).Range("E1:E30").Value This works fine however I...
  15. W

    Named Range Help

    Hello, I am trying to use named ranges to define a group of variables that will be used in a sumproduct, but I am return errors. For example: Sheet 1: Name ranges Apple = {1.000.1, 1.000.2, 1.000.3} Banana = {2.000.1, 2.000.2, 2.000.3, 2.000} Carrot = {3.000.1, 3.000.2, 3.000.3, c.0000}...
  16. A

    Cycling through two ranges to complete blank data

    I'm relatively new to programming so please be patient with me:confused:. I'm trying to find a way to cycle through two ranges and fill in blank cells. The worksheet has a "header"(A2:H2) that bascially determines how the rest of the sheet will be filled out. This header is subject to change...
  17. G

    Allocating multiple items to one master key

    I am relatively new to using Access and I have been asked to put together a database for allocating keys at our school. Every member of staff has certain keys allocated to them based on their role. There are also some keys which open multiple rooms. So for example a teacher will need a classroom...
  18. B

    selectively mutiplying mulitple worksheets

    I have 10 worksheets all with entirely different workings and I get a table of adjustment factors as the end result from each worksheet. An example of the resultant adjustment factor tables from 3 worksheets. <TABLE style="WIDTH: 218pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...
  19. W

    inter-sheet linking with shifting cells for auto-updates

    Hi all, I have been trying to figure out how to do something specific which I've come very close to, but not yet achieved. For my data, I am trying to have one sheet link to the prior sheet and the most recent month's data, plus the 5 months before for that for comparative purposes. Thus...
  20. K

    Complex Array Loops Question...

    I'm really hoping someone can help me...there doesn't seem to be an answer posted already on the internet and I wanted to consult the experts before giving up. I have created a formula that acheives my desired result, however, because it is so complex, it causes my data tables to take 30...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top