| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Last Item Entered in Row
Hi, I am hoping I can get some help on this.
I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in columns B - BA. I need a formula in colum BB that will find the last price entered for that item # in all of the columns. There will be items that may get updated each week, and others that will only get updated periodically, so those columns may be blank. Any help would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
| won't automatically repeat 1 item already entered in column? | Excel Discussion (Misc queries) | |||
| How do I tell Excel to find the last item in a column? | Excel Discussion (Misc queries) | |||
| find previous row for an item | Excel Worksheet Functions | |||
| showing the # of times an item is entered in a column | Excel Worksheet Functions | |||
Threaded Mode
