| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value in column...
Glad to hear it - thanks for feeding back.
Pete On Jan 16, 4:10*pm, Jambruins wrote: thanks, that works perfectly. "Pete_UK" wrote: Try this: =LOOKUP(1000,J2:J83) It will find the last number entered in the range J2:J83 which is less than 1000. Format the cell as percentage if that is how you want it displayed. Hope this helps. Pete On Jan 16, 3:51 pm, Jambruins wrote: In column J from J2:J46 I have percentages and tomorrow I will add another percentage which will go in J47 and this will continue everyday. *I would like a formula in cell J84 to find the last cell that has a percentage and have that percentage show up in cell J84. *So today it would grab the percentage from cell J46 and tomorrow it would grab the percentage from cell J47. *Thanks.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
Hybrid Mode
