Aug 26 2022 07:57 AM
Hi,
I manage very big tables. I need to access the last cell within a column.
Let's say we have column A with Month. I have 5000 lines with january, then 2300 lines with february, 3000 for March as an exemple. The column is sorted ascending. Now I would like to scroll down to the last cell before the next month. Let's I'm in A2, and I like a short cut to get to line A5000, just before the change to February.
Does anyone kon
Aug 26 2022 08:48 AM
You can try ctrl+F and in "find what" enter "february". Then click "find next" or enter. This returns the first cell with "february" which is one cell below the last cell with "january".