indexing

Need help regarding how I can copy the data from different columns having some cells with no data into a single column ignoring the empty cells...

Relatively new with VBA and doing my best to learn it. I have a userform which has a listbox. To this I would like to add some type of Match function so that the listbox only displays the rows in which a certain value is displayed. For example, the project ID is displayed in Sheet1 cell B1. In...

Hello! I'm looking to copy an entire row from one worksheet (Sheet1) to another (Sheet2) based on multiple criteria. For example, in the image below, I need to be able to find all the "Green" fruits and then refine that further to only "Medium" Size. Then, I need to copy the entire row (as long...

Good day All, I need to extract data from an excel sheet and index them on another sheet to formulate results with handicaps etc. I am struggling on extracting the data: <tbody> Division Stage Number Name Hit Factor Classic 1 Ira 2.57 Classic 2 Ira 0.97 Standard 1 Jason 5.36 Standard...

I have a complex macro in my mind that I want to build, but such little macro experience that I just can't build it alone. One workbook. Three sheets. Several hundred rows, but only columns A through G. Sheet1 "Old" Sheet 2 "New" Sheet 3 "Final" Sheet 4 "Report" Each workbook has the exact same...

Hi, I am wanting to index multiple worksheets, match to data in a cell and return the required information. The following formula works for a static name of the spreadsheet I am indexing, 'Gillig'...

XL 2010 workbook opens with three windows configured (location on screen and size) as they were when the workbook is saved. XL 365 opens with three equally sized windows in the middle of the screen. Tried fiddling with Windows object and indexing but read somewhere that, for example, indexing...

Ok, I've been slaving over this problem and even after 2 days of trying I only feel close by 20% if that. Goal: Create a dashboard with personnel's training information that they can print or click on hyperlinks (embeded) to specific course sites. This dashboard - snapshot as I am calling it -...

Hello all, Hoping someone can help with a calculation problem I have been using… =INDEX('Sheet1'!$H$1:$T$500,MATCH(1,INDEX(($B$6=' Sheet1'!$F:$F)*($C7=' Sheet1'!$G:$G),0,1),0),MATCH(D$6,' Sheet1'!$H$2:$T$2,0)) I run the indexing calculation above which looks across at other worksheets and...

I am having trouble indexing a Bill of Materials (BOM) to eliminate redundancies. Within the BOM, multiple assemblies use the same parts or components. I am trying to create a new sheet to consolidate/organize a parts list without having to use the VLOOKUP function. I know this may be more...

I have tried to post this question earlier, but it didnot show up. My problem is to find a relative straight forward way to determine what methods are valid for a given set of process required. For example, <tbody> Process 1 Process 2 Process 3 Process 4 Process 5 Process 6 Method A 0 0 0 1...

Hi I know this is a newbie question but I haven't had much experience in dealing with Match indexing (or if there is another way of doing this). So I have Sheet A full of of emails and names and a Sheet B with the same emails in Sheet A but no names. I basically need to match the emails in...

Hello there, so i have a couple questions about indexing data from a table ive created, and wanted to know how i can have it output all the different data, but not output zero's for blank cells or #N/A for blank cells Here is the formula im using =INDEX(ProbeList[Mag...

I have a large spreadsheet with about 156k rows, that ive divided into rows of 10k. I only want the duplicate values. So, I've performed conditional formatting, and added a filter. Problem is, when trying to filter by color, excel indexes all values of 10k before allowing the drop down to appear...

I am wondering if there is anyway to see which cells have already been selected for a formula with the cells on multiple sheets. Is there a way to show the selected cells in a formula like when they are on the same sheet and it outlines the selected cells in different colors? I really like...

How to match students marks to skills required from the questions? IE what formula can give me an output of the proper skill for the ones marked incorrect? where students mark 0=incorrect, 1=correct; question 0=skill required, 1=not a skill required

Hi I am looking to try and convert data that have been collected off some survey forms. The data appears like this below. I am wanting to create lists like shown further down. Is there a formula that i can use to copy down? I am looking at trying to convert around 200 rows into this list shown...

I am trying to create an indexing system, that can check and create an index from a number of worksheets and forms as different transactions or events occur, the index number is created by the date formatted "ddmmyyyy" and an indexing integer at the end. example and code below. everything runs...

Good morning, I'm trying to create a formula that will update cell D7 in Tab #1 based upon manually entering data into monthly cell L37 in Tab #2. (In this example, we are using November that would be cell L37 in Tab #2. October would be the prior cell and so on and so forth.) I would...

Can you please help with an Excel formula that will calculate a growth index that will work with negative as well as positive values. For example: Country A growth = 5% Country B Growth = 7% To calculate the index for country B growth Vs country A, we can easily calculate the growth index as...