The startmonthsp name refers to the months across the top of my pivot table. This formula works but I now need one small change. If the value in the columns are zero or less then I do not want the formula to return that column header (bypass it until it gets a positive value above zero).

Attached is a workbook that shows my formula in action.

I've got a spreadsheet with various amounts in cells A3:L5. I want to find the last non-blank entry in each row but only where the entry is in a column headed "Guaranteed PRB" (found in row 1). Then I want it to return the column header title found in row 2, which is a date.

I've attached a sample of the spreadsheet with the expected answer in column M.

I've been trying find an appropriate formula to extract the column header from a table in a different sheet if the row header and value in that table is known.

in the lookup table the row titles (column A) are product codes, column titles (row 2, D through AX) are business names and the table values are quantity.

In a different table I have product codes in column A and in column B i have the max number/quantity of products for that code. In column C i want to put the company name associated with the product and the number/quantity.

I have the following sample data set and I'm trying to return the appropriate column header based on criteria (i.e. DDD) and a number value which will be somewhere within the range of the table. In example below, the value returned should be Header 2 because the value is greater than those in Header 1 column (range H9 to L26).

I need a formula to return column header if there is data in the column, any data.But I also need to return the second, third, fourth header with data too

In column A row 2, I have =IF(M8"",$M$1,IF(N8"",$N$1,IF(O8"",$O$1,IF(P8"",$P$1,IF(Q8"",$Q$1,IF(R8"",$R$1,IF(S8"",$S$1,IF(T8"",$T$1,""))))))))

This returns the row 1 header for the first instance of data in row 2 columns M thru T But in B2, I need the second header with data in the column.

I need the results in yellow (1st, 2nd, 3rd, 4th) from the array to it's left

1St match2nd 3rd 4thColumn MColumn NColumn OColumn PColumn QColumn R Column MColumn PColumn QData data2Data3 Column NColumn OColumn PColumn R Data Data2 data3 data4

Would use match/index but can't increment it to the second or 3rd match

Cells A3:A500 contain product numbers, e.g. 1001, 1002, 1003 etc.. etc... Cells G2:N2 are column headers, e.g. North2011, South2011, North2012, South2012 etc... etc... Cell F2 is a lookup that will return a year, e.g. 2011, 2012, 2013 etc... etc...

Against each product is a "yes" if it was sold in the north or south region for each year. This could be both north and south, one or the other or none at all.

What I would like is a formula in cells E3:E500 that looks at the year in cell F2 and if there is a "yes" in either the North or South for that year to return "yes" otherwise blank.

I am unable to upload a sample document due to firewalls.

I'm working on a spreadsheet where I need to return the column header where the value in that row matches the criteria from an if statement.

The column headers are departments, the row headers are customers numbers, the values show the % of items sold in that department as a % of the total purchases by that customer.

I need to make a formula for each row so that if the % in any of the current row's values is 75%-100% then get the column header for the column that value is in.

I know it's an IF statement, but I don't know how to return the column header for the value when the if statement is true.

I have another table that only lists IDs Table2 ID 1 2 3 5

I want a VBA code such that if ID is in Table2, VBA looks for the matching ID in Table1 and if the matching ID found, it looks for ALL non-empty cells and if a non-empty cell is found in the row, it returns the value in the cell and the header to give something like this

Sr. ITEM DESCRIPTION BRAND UNIT A-Z AL AMEEN COLOR WORKS INDEX OXFORD PENCIL SUPPLIES STORE WAVES LOWEST PRICE SECOND LOWEST Vendor Lowest Price Vendor 2nd Lowest Price

[Code] .......

I have above table and wants to get the formula for getting the 1) Vendor Name of the Lowest Price per item 2) Vendor Name of the 2nd Lowest Price per item 3) and be able to copy down the formula for other items.

I've got numerical data in columns A through AF, starting in row 4. I need a formula, starting in AG4 that I can drag down. I need the formula to look back across the row until it gets to the last posistive number, then return the column header of that column (the column headers are in row 3)

so for example

Header row

Jan Feb Mar Apr May Jun Jul Aug

Data

0 3 0 0 8 0 0 0

the formula would return May in this example as 8 is the las positive value and the column header for that column is 8. There are no blank cells in the data.

I have a list of names and the chores they need to do on a certain day. I need a formula that returns the chore the person needs to do when the date is filled in.

Ex: Sheet2 Col:A has names filled in A2:11 , row B1:J1 has dates that you would input. formula goes in B2:J11 Sheet1 is the master with all the data the formula would be pulling from. column A2:A11 has the names , row B1:S1 has the chore that needs to be done. B2:S11 has the dates already filled in.

I am having trouble with getting a value (which is the row and column value) from a set of numbers. I have attached an example table to try and make things clearer. What I have is a table with a set of Row Headers, and Columns Headers all numeric. e.g Columns headed 1, 2, 3, 4, Rows 30, 40, 50 etc. I want to find the 1st occurrence of a value e.g. 1.0 in the table (by 1st Up mean closest to top left), and then give me the value of the Row and Column Header that corresponds to that.

So for the example attached, I want to get the row Value 200 and Column 6 from finding the 1st occurrence of the number 1. I have tried various combinations of index and Match etc. But I can't get my head around the fact that the position of the 1st no. 1.0 can change, therefore I can't use any releative positions etc.

I'm looking for a formula that will return the column header (a date) of the first instance of a number greater than 0. For example if columns A through S had dates as in row 1 (header row), and in row 2, every column contained a 0 up until column P, I would want the date (Row 1, Column P) returned? I think this might be a sort of index/match formula, but I am not very familiar with these.

I have this table, which can be seen as a basic custom gantt chart: KLRWo.png

And I would like to fill the A column with start dates, based on the first filled cell of the range on the same row, and the header value of its respective column (row 1). It's easier to show my expected result than write it actually:

I have a data set with the weeks of the year as my column headers and a value of 1 (from a pivot table) in a distinct row value (removed for privacy) showing whether it existed in a given week based on pre defined criteria. What i need to do is ID the first (from the left) non blank cell in each row and then return that cells column header. I then need to do the same for the last (from the left) non blank cell in each row and then return that cells column header. On the attached I've put values in column N and O to show an example of what I need to return using a formula.

I've been using a nice colorful spreadsheet to use to schedule rooms for an organization. Visually it has worked out well but now I need to automatically generate a 'report' using that data. So...

I want to scan each row of a table and create another table with that data transformed. That is, scan each row and whenever I find any text in a cell I want to return that text (the room being used) as well as the row and column header information (who is starting to use that room and on what date). I've attached a jpeg to show the example.

Ideally, when I scan the row and find text to return the headers I'd like the row scan to also find when the fill color changes and return that column header, too as that that would be the date that the room stops being used.

I have a spreadsheet of several thousand named items (in column B) with values associated with them in column A). The "name" field is a string of several alternative names for the item.

I have a list of ~50 items that I am trying to find the values for. Each uses one of the alternate names.

What I want is a function that will return the associated value in column A when one of my shortlist names is found.

Trying to write a formula that looks for the first number in the same row, then returns the value in that column in a different row. In the example included, cell A-7 should contain the formula. Within row 7, determine the column where the first number is listed (column D in this case), then return the value listed in row 3 of that column ('C' in this case).

I've tried Lookup, Index, and Match functions, but can't seem to get the right combination.

Is there a formula that will allow me to look for the existence of any number value in a row of one worksheet and then return a specific number value in a cell on another worksheet? For example, if the formula finds any number value it will always return the number 15 to a cell on another worksheet.

I am working with data that has numeric values in columns S, T and U. In column M I want to return the header of the column that has the largest value (S,T or U).

The problem is that it only sometimes works properly. I have found instances where the value in column T is greater than S and yet column S's header is still returned. What am I doing wrong?

I need a formula to put into cell B19 to Find X in the corresponding row and to return the header value

******** ******************** ************************************************************************>Microsoft Excel - Book2___Running: 11.0 : OS = Windows .NET Server (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEF1Part NumberDescriptionSubframe BuildCut And ChopHopper BuildCabBuild2026319Assy Air Ram Auto Blanking X 3026321Assy Air Ram Rear Boom L/H X 4026320Assy Air Ram Rear Boom R/H X 5022587Assy Air Ram Side BrushX 6031159Assy Air Ram Side Brush Large DiameterX 7030501Assy Blanking Flap Valve Single Vm Minor 8034783Assy Brake Pedal Lh Vm Minor Fl X9034784Assy Brake Pedal Rh Vm Minor FlX 10036349Assy Brush Control D/S No Hp Opt Mer/Mag X 11024553Assy Brush Core 1300 Large Widesweep X 12024554Assy Brush Core 1300 Small Widesweep X 13023169Assy Brush Core Large 7000 X 14025662Assy Brush Core Large 80/85 X 15032482Assy Brush Core Magnum Poly/Wire Mix X 16 17 18 19034784Subframe Build 20023169Cut And Chop Sheet1 [HtmlMaker 2.41] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

With four numbers, I am attempting to "return" a number that is greater than zero, EVEN IF zero is in the array. Meaning, I need the number greater zero, knowing zero is within the array. This will be a part of a much longer concatenate formula.

010 5 0

I would expect the answer to be "5". I tried: =abs(min(A1:D1))

This works great if there is a negative number (e.g. a -5, rather than 5 shown above), but when the numbers are all positive, the result is "0", I want 5 or the next greater number above zero.

I have a table with the follow values (simplified version): A1:E1 have text headers B1:E1 have formulas to pull in text values. Some are blank. Some have repeat values. F1 has the value I want to look up. I need F2 to look at A2:E2 and compare to F1. It needs to pull in the corresponding A1:E1 value for the furthest to the right A2:E2 value.

Example: Column A B C D E F Row 1 Jan Feb Mar Apr May Imp1 Row 2 [blank] Imp1 Imp2 [blank] Imp1

I am trying to search a range for all of the nonblank cells, when I find one, return the column header and the value in that column. Vlookup won't work on this. It will only return a specified column.

Employee performance

ID area one | two | three

12947 23 | | 19 12948 32 | | 20 12948 |17 | 52

What I am trying to do is create a communication sheet. Employee ID 12947, your performance in area one= ______, in area two = ______ and so on.