multi coloums

I have an Excel 2016 file with a large set of panel data in the following actual form: <tbody> VAR ISO VALUE 1990 1991 1992 IMPORTS ARG 1,287 NA NA IMPORTS AUS 9,178 447 10,792 IMPORTS AUT NA NA 1,325 GDP ARG 153 206...

This Vlookup should work I think but it isn't. Current table does have more columns in between Service Indicator and Support Activity. There is a column at the end of the current table to hold the formula Formula {=INDEX(Table5[@[MSR Category ]],MATCH(Table5[Service Indicator]&Table5[Support...

Hi i have 3 columns data as various dates like this Date 1 date 2 date 3 01-01-2006 04-04-2007 05-09-2008 01-07-2006 01-07-2007 01-07-2008 01-07-2009 now i want to create a list of dates like 01-01-2006 01-07-2006...

Hello Team I'm struggling with this one.. Step 1) Filter MAIN Category (On field 20) Step 2) Then Filter SUB Category (On field 4) Step 3) Do the magic Step 4) Goto the next MAIN Category Step 5) Filter SUB Category Step 6) Do the magic again Sub Filter_On_2_Columns_BB() 'This Macro Filter...

I'm trying to pull back (based on Customer Number), their #1 Case Reason based on volume of cases, and then when there is a tie (like for 3CTI001-S or 3RTT001), bring back the most recent Case Reason as the winner (from the top tied groups). I'm thinking there are some arrays and countifs...

Hi guys, I am looking to do the following: Have a button that when selected in another page, will find data across two different coloums in a different page, then copy and paste that data into another after wiping the page that the data is being copied into (as it will be used again for...