multiple columns and rows

  1. S

    All Combinations of Multiple Columns Without Duplicates

    I have been searching for a code that does what I am hopeful is understandable to whomever may be able to help me with this. I have multiple columns with multiple names (10 columns in this case), some names are duplicated, and need to generate all possible combinations of these 10 columns of...
  2. B

    Index-Match on Multiple Columns -- Nth Result

    Can someone help me adjust this formula to return the Nth "group" that a "name" is in? And if the "name" only occurs once, the search for the 2nd occurrence will return ""? Sticking with the pictured example, I would like each person's 1st group to show in column H [like it already is] and each...
  3. B

    lookup in unsorted table, column and row unknown (No VBA, please)

    I've copied snippets of my data from two tabs: "Pokémon" & "Fast TMs". As an example, we'll use Nidoking, who's pokédex number is 34. I need cell I16 in the first table to find Nidoking's # ("34") in the second table (cell M6) and return the name of his Move ("Iron Tail"). I'll then need a...
  4. M

    Multiple awards separate into different columns

    Thank you in advance. I have a spreadsheet with participants winning multiple awards. I want the awards in separate columns tiled Awards 1 Award 2 Award 3.... I have this... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Award Jane Gold...
  5. S

    help! stuck! If, Index, Small, Row, Rows!

    <tbody> </tbody> first row is building name, next row is dept #, next row is area of study. The dates to the right are all of the dates that a meeting is scheduled. I am trying to search a specific date and return a result that lists the bldgs, dept, area for that specific date. Below...
  6. D

    Difficult Riddle: Summing values across various columns and rows

    I am attempting to sum a range (multiple rows and columns) based on multiple criteria (location, type, and if it contains value >=0) in another tab in workbook. I have attempted sumifs, sum(if()), and array formulas but have been unsuccessful. =SUMIFS('TRUCK Utilization'!P$7:P$367,'TRUCK...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top