Hello i am looking for a way to display a result in the updated bid set column based on values in the Add#1 - 6 Columns with the latest addendum always displayed for each sheet.
Hope this isn't to confusing.
Thanks in advance!!!sample.xlsx
Hello i am looking for a way to display a result in the updated bid set column based on values in the Add#1 - 6 Columns with the latest addendum always displayed for each sheet.
Hope this isn't to confusing.
Thanks in advance!!!sample.xlsx
In J5 enter
=INDEX($A$4:$H$4,MAX(IF(C5:H5<>0,COLUMN(C5:H5),0)))
with Ctrl + Shift + Enter keys together
Thanks worked like a charm !!!! +rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks