return column header

Good day great minds, I have been battling with this fommula for while now and I need yours help on it. In the first image is a list of 1 - 49 numbers with the trands of each numbers. And on the second image is the lists of the highest 10 numbers trends and lowest 20 numbers trends. I used...

Hi all, I have an excel with numerous diagnostics that are being tested for a phone (either fail/successful). I then have a Hardware summary column that tells you if the phone was successful or has failed, for all the failed phones i want to have a formula that will allow me to see all the...

Hello. I am a first time user. I can usually search for what I need and adapt the solution to my situation but this challenge has me wanting. I have a set of data that I would like to search as a set of columns or an array and I would like to return the results of each occurrence to a cell or...

Hello! Need the help of an expert on Index-Match. The task at hand is to return the column header, based on the row header and its value in the row. <tbody> Z1 Z2 Z3 S1 Q R A S1 W T B S1 E Y C S2 R Q J S2 T W K S2 Y E L S3 A J Q S3 B K W S3 C L E </tbody> Please note a...

Hello, I'm having trouble with this and I'm hoping somebody here may be able to help. Here is a sample of my data: <tbody> 2011 2011 2011 2011 2012 2012 2012 2012 2013 2013 2013 2013 2014 2014 2014 2014 <tbody> Co.1 </tbody> <tbody> Co.1 </tbody> <tbody> Co.2...

Hi, I have a table. In the column A is a list of all classes available, in row 1 across the top of the table is a list of people. There is an 'x' in the appropriate cell to indicate which classes each person is taking. Sample table: <TBODY> A B C D E 1 All attendees Person 1...

There's probably a simple way to do this but I keep tripping over something. I have two columns with team abbreviations, one simply says whether they are AL or NL the other is the result of a search with multiple occurrences of the team name. I need to match the long list with the short and put...