I love using the SEQUENCE function dynamically. For example, if you have a list of names in column B, you can create a sequence in column A starting from 1 based on the length of entries in column B. A simple formula for this would be: =SEQUENCE(COUNTA(B:B)-1, 1, 1) Here, B1 could be a title like "Customer." Now, imagine you have a list of invoices in Sheet 1 where one column is "Customer." In Sheet 2, you want to create a unique, sorted list of customers. You can do this by setting B1 to "Customer" (as the title) and using this formula in B2: =UNIQUE(SORT(OFFSET(Sheet1!A2, 0, 0, COUNTA(Sheet1!A:A)-1, 1)))
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
I love using the SEQUENCE function dynamically. For example, if you have a list of names in column B, you can create a sequence in column A starting from 1 based on the length of entries in column B. A simple formula for this would be:
=SEQUENCE(COUNTA(B:B)-1, 1, 1)
Here, B1 could be a title like "Customer."
Now, imagine you have a list of invoices in Sheet 1 where one column is "Customer." In Sheet 2, you want to create a unique, sorted list of customers. You can do this by setting B1 to "Customer" (as the title) and using this formula in B2:
=UNIQUE(SORT(OFFSET(Sheet1!A2, 0, 0, COUNTA(Sheet1!A:A)-1, 1)))
You know what, this is the first time I know these skills despite of using excel since long time.
Thank you
Thank you for sharing. It's so helpful.
Actually, I've been using this formula for quite a while. It's a real time-saver!
Not really a formula but a GUI feature
Not working
I knew this but I still always choose the wrong columns/rows option and have to undo and do it again 😂
I am 35 years old... Jus opt for data analytics course... Will i get job whn i finish this course... Please comment... Thannk you...
Using the formula kinda easier and faster
Great point! Unfortunately it’s not available for some earlier excel versions so it’s nice to know the alternatives
You are wrong because most Excel users started their journeys with this particular method
I tried on my side, didn't worked what could be the reason am using Microsoft 365
Most of this guy's features are for newer excel or needs to be enabled in the advanced settings. So I'm not surprised
Too long,, seq is better> select the seq> ctrl c> ctrl shift v