column reference

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

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

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

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

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

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

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 Chandoo.org at...

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

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