why does my excel doesn't have take function? i'm so confuse
@shahidhabib-um7ev
6 ай бұрын
Dear SIR I WANT TO ASK A QUESTION CAN I ASK ?
@ornashuva
4 ай бұрын
Thanks for the great explanation. I would have one question: if the table is not in a defined range (ie each month I add further rows to a table) how can I still get the last 'entry/value' of that column? For me it's a date, however by using =TAKE(C6:C110,-1,-1) the system returns 00/01/1900 on empty cells (formated as date). thanks alot
@Anonymous-zn9qo
Жыл бұрын
Is there any alternative functions which we can use in older excel version's and get the same result
@aliuoladejo7242
10 ай бұрын
LOOKUP FUNCTION
@matthewwerstler7760
8 ай бұрын
Thanks Excel University - I was having trouble remember how this worked, and I am very grateful how simple you made this explanation. The naming helped me search it up online, but you could add TAKE to the end for even more SEO traffic.
@ExcelU
8 ай бұрын
Great idea ... and ... done! Appreciate the tip :)
@Smokeyham
10 ай бұрын
Well explained! Thanks.
@behfar89
8 ай бұрын
how can this be used for when you are adding new columns, as opposed to new rows?
@elcesar215
7 ай бұрын
How is work in pivot table ??
@PaulEBrownbill
Жыл бұрын
Thanks, good video to show how to use two functions. Paul
@ExcelU
Жыл бұрын
Glad it was helpful!
@ricigri1242
8 ай бұрын
The only video that saved my life. Huge thank you
@LamaHI
7 ай бұрын
Thank you sooo much. This saved me a lot of time.
@monologuesofaconsultant
Жыл бұрын
Very nice, thanks.
@ExcelU
Жыл бұрын
Thank you!
@alpdip2112
Жыл бұрын
Excellent :)
@ExcelU
Жыл бұрын
Thank you! Cheers!
@taizoondean689
Жыл бұрын
Thank you 😊
@ExcelU
Жыл бұрын
You're welcome 😊
@jacqal9922
6 ай бұрын
Hey - what if we just wanted a cell in the row?
@ExcelU
5 ай бұрын
To retrieve just a cell, rather than the whole row, use only that column reference with the TAKE function. So, instead of something like TAKE(TableName) which returns all columns in the table, you'd use TAKE(TableName[ColumnName]) to return just the cell from that single column. Hope it helps :)
@johnx2686
Жыл бұрын
Can we use this function in excel 2007?
@ExcelU
Жыл бұрын
Neither of these functions are available in Excel 2007 ... sorry about that. However, they are available in Excel Online in case that will be helpful :)
Пікірлер: 25