How to bottom and second to bottom automatic send to overview?

HenrikKruse 

It sounds like you want to create an automated report in Excel that extracts data either from the last filled cell or the second-to-last filled cell in a specific column. You can achieve this by using Excel functions like INDEX, MATCH, and OFFSET. Here is how you can set it up:

Let us assume you want to extract data from Column 2 (where you put information from the main box).

1. In your report cell (the one you want to automatically populate), enter the following formula to get the last filled cell's value:

=LOOKUP(2,1/(B:B<>""),B:B)

This formula looks for the last non-empty cell in Column B and returns its value.

1. To extract data from the second-to-last filled cell in Column 2, use the following formula:

=LOOKUP(2,1/(B:B<>""),B:B)-INDEX(B:B,COUNTA(B:B)-1)

This formula calculates the difference between the last non-empty cell and the second-to-last non-empty cell in Column B, effectively giving you the value of the second-to-last filled cell.

1. Adjust the formulas and column references as needed to match your specific column and data.

Now, your report cell will automatically display the value from the last filled cell and the second-to-last filled cell, allowing you to choose which one to use for your report.

Keep in mind that these formulas assume that your data is consistently entered in a chronological order, with no skipped rows, in the specified column (Column 2 in this example). If your data does not follow this pattern, you may need to modify the formulas accordingly. The text was created with the help of AI.

Hope this will help you.

Was the answer useful? Mark them as helpful! ...and like it.

This will help all forum participants.