Hello,
Sorry if this has already been asked/answered.
I'm trying to look across 12 columns of data (one for each month of year) and report the value in one of those columns, as well as the column header of the particular column with the value in it. Only one of the 12 columns will have a value in it, by the way. Basic sales analysis - you sold X items in month Y. X and Y are reported off to the right of the 12 columns.
Thanks in advance for any advice/suggestions!
=Lookup(9.99999e+307,A2:L2)
will report last (only) number in A2:L2
=Index(A1:L1,Match(9.9999e+307,A2:L2))
will report header in A1:L1 where the last (only) entry in A2:L2 occurs.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
tooleyr,
Welcome to the Excel Forum.
Detach/open workbook tooleyr - EF760122 - SDG10.xls and check columns M and N.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks