00:00how do you get the last record from each row like this try not to do it manually it is
00:06error prone
00:07and labor intensive and worst of all if your data set changes you're going to have to redo this
00:12manual copy and paste madness all over again so let me show you how you can complete this task
00:18using a single yet so simple formula but before that let's take a look at this count function
00:24let's say for example let's say equal count and in that argument i'm going to highlight my row of data
00:31and close parentheses and hit enter this returns a value of four four indicated that there's four
00:38records or rather four cells with some numbers in it the next row if i put count and i do
00:46the same
00:46thing again here from c6 to f6 like this it will return a value of three which means three cells
00:57out of the four cells has a value in it so now keep that in mind we're going to need
01:02that later on i'm
01:03going to just delete these two cells here now we're going to start off with using a offset function
01:09and the first argument on the offset function will be your reference point we're going to use
01:14the name as a reference point just before the very first column of data comma and then we're not
01:22going to use row we're going to count the number of column either leave it blank or put zero like
01:26this
01:26and the third argument is the count function that we're talking about just now and inside that argument
01:32for the count function we're going to say c5 to f5 close parentheses twice like this and hit enter as
01:38you
01:39can see this is returning the very last value here now apply the same formula to the rest of rows
01:44you can see that this eight thousand eight hundred fifty two is from here and six thousand five hundred
01:51fifty seven is from here and so on
01:54you
01:54you
01:55you
Comments