column reference

  1. M

    Formula works, then doesn't

    Hello, I am at a loss as to what is happening here. I have some survey data on one sheet, and I am putting together a summary on another sheet. I want mean, standard deviation of the sample, and median for some of the data. I am compiling the summary statistics both for all surveys and for...
  2. S

    Renaming files using column reference

    I would like to have a VBA code that would rename files (both excel and pdf) in a specific path. The files in the path are initially named as 1, 2, 3, 4... etc. Now the template that has the VBA will have the exact number of files with the number series in Column A. While in Column B, I will...
  3. J

    SumProduct Based on a Column Criteria

    Hi All - I need help with creating a SumProduct formula that will utilize different columns (Based on the selected month) to populate the total cost. Below is an example of what I am trying to achieve. The data setup cannot be changed at it is used a wide set of reports...
  4. S

    Data Table Vlookup column Reference

    Good Morning When using an Excel Data Table and Vlookup is it possible to reference the column position in the Table by the column name instead of the column number. I did a literature search at it appears I must still use the column number. Thanks Steve
  5. I

    Vlookup column reference is last filled column in a row?

    Good evening and thanks for looking at this and possibly helping me out. Currently, I have a standard vlookup forumla that looks like =Vlookup(B2,Sheet2!A:G,5,false) However, the data on sheet two is ever expanding--each month, specifically. And I need to return the most recent (so, rightmost...
  6. C

    Find a column reference for a cell meeting 2-dimensional criteria

    Hello! I have been trying to do this for many days now, and so finally decided to join this forum and ask for help. I am trying to get the column number of a cell that meets both vertical and horizontal criteria within a matrix. Specifically I am trying to produce a formula that will give me...
  7. A

    Convert sub Insert COLUMN of checkboxes to Insert ROW of checkboxes

    Hi all, I found the following code that inserts a single column, user entered range of checkboxes. (It works very well and saves much time for those interested) Sub insertCheckboxes_OnCentre() 'Found via at...
  8. R

    Excel table 2007 use indirect function in a row or column reference

    Hello Excel Experts, I am trying to use the indirect function in a table reference to return the value at the intersection of the row and column, like so: =Table5[#This Row] Table5[indirect(C7)] However despite many variations or attempts with the match formula, this isn't working. The lovely...
  9. B

    vlookup sorting issue with Column Index Number

    I'm using a vlookup function for one of my excel tools at work. I built it to find a relevant salary value in a salary table based upon references from within the worksheet. The salary table is composed of Grades, which are in the left hand column, and Steps which are in the top row. An...

Some videos you may like

This Week's Hot Topics