| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last value in column...
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last value in column...
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last value in column...
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. |
|
#4
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
