If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Offset formula
Hi
the reason for this is that COUNTA counts the formula result "" also as a non blank cell. Try the following instead to get the last numeric value in your range: =VLOOKUP(9.9999999E307,$X5:$X100) -- Regards Frank Kabel Frankfurt, Germany I have a spreadsheet that is updated on a weekly basis and I have a summary of the information at the bottom of the page. I only want to show the last figure in column X. I've been using the following formula.... OFFSET($X$5,COUNTA($X5:$X56)-1,0) This has worked until I put a formula in column X (the user used to have to fill this in as they went). Now my OFFSET formula isn't working. Is it because I now have an underlying formula there? I have this formula in column X so the user only has to enter the data in column W and column X calculates for them. IF(ISBLANK(W14),"",SUM(X13+W14)) Can anyone help?? --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|