Linked Questions

I have a question regarding a simple formula: Gn=Fn-En, but if En is an empty cell, then search on the same row (n), all the n-1 values in order to find the first non empty cell. Is it possible to ...

I use the following function =DAYS360(A2, A35) to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change 'A35' as I ...

I am having a lot of difficulty trying to come up with a way to 'parse' and 'order' my excel spreadsheet. What I essentially need to do is get the last non empty cell from every row and cut / paste it ...

I have a worksheet with the following contents in A1:G1 7 8 4 2 9 11 10 Formula =SUMPRODUCT(MIN($B1:$G1-$A1)) (1) evaluates to -5, =SUMPRODUCT(ABS($B1:$G1-$A1)) (2) evaluates to 18. But =...

I need to create a formula that returns the row number of the last empty cell within a range. For example Cell Data B10 text-a B11 text-b B12 text-c B13 B14 B15 text-d B16 B17 ...

Am running Excel 2013 on Windows 10 with 16 GB memory. I have a hierarchical structure similar to figure 1 below. My structure is 1000+ rows and as deep as 27 levels. For a "tree" as depicted above, ...

This is a followup question to this one. The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel: =LOOKUP(2,1/(A:A<>""),A:A) My question ...

I have a sub that formats specific ranges on a sheet and I want to make it more efficient (it was copied from running the macro recorder and works fine). I Also want incorporate code so that if a ...

I am trying to count the number of non-empty cells in a range (H5 to J13), where another cell (in column G) also matches a text string from a different cell. I am using a spreadsheet on Google Docs so ...

I was searching for a formula that sums the last thirteen rows in a column from the bottom. I found: =SUM(INDEX(R:R,MATCH(9.99999999999999E+307,R:R,1)):INDEX(R:R,MATCH(9.99999999999999E+307,R:R,1)-...

I Have Table like this, where i have to use macro because my table always change Every day (SSAS) so i have use macro to filter automatically, I am able to sum Amount based on same Vendorname, ...

I am able to get a column into version sorted order. The issue is Excel formula do not seem to handle tables that have an Excel Filter on them to excluded unwanted rows. VBA macros are not an option ...

As painful as it sounds, I've been tasked to implement a spreadsheet to calculate drug absorption and elimination half-life. I actually use LibreOffice Calc, but a solution tested in Excel would also ...

Is there a way to find the length of a row in VBA (counting only cells that are not empty)? Thank you in advance.

This is I think a simple problem but I can't seem to find the right solution for it. I don't know if VBA is needed for it. Basically I just want to subtract the last two non-empty cell in Excel. ...