columns

  1. H

    Combining 3 x INDEX MATCH

    Hi All, I have a column with INDEX/MATCH formula, but the match value could come from 1 of 3 possible columns. Could you help me combine the below into one formula please? =IFERROR(INDEX(admin!$C$4:$C$100,MATCH(C4,admin!$B$4:$B$100,0)),"0")...
  2. S

    How to take screenshot of certain range?

    Hi I want to take screenshot of a range and expect a prompt to save it. The range is not always same. The maximum range is same... means there wont be more than 11 rows and 10 columns. But, I only want to take screenshot of the range having data. That is less than or equal to 11 rows. Number of...
  3. S

    Copy from one sheet to another baed on an IF AND OR

    I'm not sure if what I'm asking is possible to accomplish with excel. But what I would like to do is on sheet one copy list names that meet specific criteria based on IF AND OR of contents of columns next to their names. <tbody> Name Y N M YES jim 1 1 y jeff 1 y bill 1 n sam 1 y...
  4. H

    How do I properly pivot duplicate data to avoid enumeration errors? (Importing XML)

    Hi! I have a custom google map with thousands of pins and thousands upon thousands of data points in an XML file. I'm trying to get them to display all nicely in a normal spreadsheet so I can sort and analyze the data. I'm having trouble with the final steps when I'm importing the XML file into...
  5. Z

    Conditional Formatting Based on Headers

    I am having trouble coming up with code that will scan the column headers, strings, and then apply the specific conditional formatting based on values in that column. The order of the columns can vary depending on how individuals pull the report. I want the formatting consistent despite the...
  6. J

    Creating an Unusual List

    My problem is the following: I am looking to create a list in 'column A' by referencing a range of cells from the range B2:E20 with some blank cells and some not. In the list I want to include only the non-blank cells while also updating automatically if the cells in 'columns B:E' are changed...
  7. D

    Transpose columns to rows from 1 sheet to another sheet with VBA with ongoing columns

    I have a constantly-updating spreadsheet I use to track projects, but I want to create a summary view for internal stakeholders. I'm looking to transpose my columns to rows from 1 sheet to another sheet. The issue I run into is that as new projects get added on to the original list (as a new...
  8. D

    VBA to bring columns in rows (except first column)

    Dear all, I'm struggling with a code to move columns values into rows, except the first column. Of course, it will be needed to add rows and populate the blanks in the first column. Probably, an example will make my exercise easier to understand: An important point is that the number of...
  9. A

    Index Match Countif Distinct unique values with two or more match columns with result in two different tables.

    Hello, I wonder if anybody can help me out. I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values. I was able to do this so far with Index, Match and Countif array formula but it only works for...
  10. C

    VBA Code to Unhide columns

    I'd like to unhide columns based on clicking the a button that I have created. When the user clicks the button, columns F-I would unhide. When the button is clicked again it moves to unhide the next group of columns J-M and so on. I'd like to use the same button to keep this quoting worksheet...
  11. C

    Re: Number selection

    Re: Number selection Hello All, Sometime back ( June 1st 2019 ) I put in a request in the forum for help on Configuring Number Groups. https://www.mrexcel.com/forum/excel-...er-groups.html What I would like to do is to perform much the same task as the original request except for the...
  12. A

    VBA to sort columns

    Hi All, I have multiple tabs I need to merge. I have been able to write the code to merge the into data into one spreadsheet, but sometimes that columns aren't a match. Is there a way I can sweep some VBA code over my workbook and sort the columns depending on the title, ideally going through...
  13. I

    If then statement failing

    Hello all, I'm having an issue getting an IF then statement to work within VBA. I'm trying to have my spreadsheet format a text to columns if A2 is blank. (meaning if it hasn't been text to columns already) I've tried a number of different formulas. It's not skipping if A2 has data and redoing...
  14. P

    index match

    Hi I have a table with multiple columns and a form that adds data to each of those columns, as a "case". I also have a separate function that adds data to some of those columns, based on the value in column A as a "case update". How do i get the remaining blank cells in that row to fill with...
  15. T

    Collapse/Expand grouped columns based on cell value

    Hi All, I have a worksheet with 52 weeks of personnel planning. These are grouped columns with an empty column in between each week. The groups are in columns E:PL. Each of the weeks are named ranges. Columns A:D have text (ie. work path, area, etc.). For the user, the columns are frozen to...
  16. F

    If And Statment to include three columns

    Hello, I am looking to expand a formula to include a third column. The current formula is; if(and(n2="",o2="")m2,n2), Basically I am trying to say if column N & O are blank then report the data in column M to the new column. If there is data in either column N or O then report this data instead...
  17. G

    One table multiple sheets ?

    Hi, I am sure there is an easy way to do this (I hope) but I am struggling. Please help :-) I have a large set of data, about 30 columns and about 40,000 rows. About 7 of the columns need updating regularly but it's cumbersome to navigate and tricky to reorganise as the data is appended to...
  18. P

    VlookUp

    I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would...
  19. N

    Custom group handling in a pivot table

    I would like to ask you about the groups in a pivot table. You easily create one group by selecting for example 5 from 6 columns headers (or rows, of course) in the pivot table and right-click - group. From this point and then: If I see a grouped pivot table how can i know which columns it...
  20. A

    Arranging in order

    HI Team, I want to arrange below table in order. If you see the 1st column have all the number. Now in C and G have common number with making of 1. Now i need both them in side to side. Same for others. All the columns should be arranged in order so i can know what are the alphabets have same...

Some videos you may like

This Week's Hot Topics

Top