UNIQUE Function
Relevant answer
Filter, choosecols, chooserows .v.v. Excel mạnh hơn nhiều ^^ Ggsheets chỉ tiện hơn khi share nhiều người xài
Relevant answer
Rod Esmade Can you not just VStack() function the data and wrap it with Unique() function?
Relevant answer
Try something like this and change cell references to match yours. Don't forget to lock arrays before you copy down.
Relevant answer
if you are using Office365, you could use the HSTACK & DROP
=LET(u,UNIQUE(B:B), DROP(HSTACK(u,SUMIF(B:B,u,C:C),1))
Relevant answer
Not sure why you have the sort BY COLUMN when you only have one column. Just drop it or put 0 or False -- you should only have 1) ZERO as the unique should only return one blank row, so wrap the formula in ... =DROP(UNIQUE(SORT(VSTACK(F7:F200,A7:A200),1,1)),-1) This assumes you were sorting text and the 0 would be at the end.
Relevant answer
- Hỗ Trợ Vay Vốn Ngân Hàng Kết Bạn Zalo: 0359.078.354 để được tư vấn làm thủ tục
- Thủ tục vay tín chấp nhanh gọn giải ngân trong ngày
- Khoản Vay: 20-500 triệu
- Lãi Xuất Cực Kì Ưu Đãi (0,8%)
- Kỳ Hạn Vay: 12 - 18 - 24 - 36 tháng.
- Giải Ngân Nhanh Gọn Trong 2 Tiếng Nếu Đủ Điều Kiện
- Không Thẩm Định + Không Cần Chứng Minh Thu Nhập + Vay qua ngân hàng toàn quốc làm Việc Cả T7 Và CN.
- Thông tin bảo mật khách hàng - Uy Tín -Nhận Và Thanh Toán ATM Nhắn tin ZALO hoặc Call ngay để được tư vấn (2)
Relevant answer
You want to use the UNIQUE formula.
Can’t say exactly what it needs to be, as I can’t see your rows, but probably something like =UNIQUE(F9:F10000)
The super large range, is just to avoid a situation where you end up adding date outside the range, in which case the formula would stop working right.
So if you know the number of entries isn’t ever going to get anywhere near that high, you could use a more reasonable range.
Relevant answer
hey Ishvar Naranji it is absolutely vague when you are saying its not valid, those formulas posted are absolutely 100% working one, and has been used time and again, tested several time, show how it is not working for you
Relevant answer
EJ Uyuyoy Malinao one other way of resolving this is
• Formula used in cell B6
=INDEX(B$2:B$4,AGGREGATE(15,6,(ROW($A$2:$A$4)-ROW($A$2)+1)/(($A6=$A$2:$A$4)*($B$2:$D$4<>"")),COLUMN(A1)),1)
And Fill Right, Formula works Excel 2010+ onwards!
Relevant answer
A simple way would be to use the UNIQUE formula referencing the Google form input column to create a ‘cleaned’ list of unique words. E.g:
=UNIQUE(‘ Form Responses’!A:A), then do a COUNTIF formula using the newly formed list.
Relevant answer
I take my hat off to all of you…you’re excel experts and I’m glad I joined this group!
Relevant answer
Relevant answer
Joshua Blaine updated the Excel Formula as well. 😊 Please refer the screenshot, the earlier formula may result FALSE Positives for that i have shown an example above. Thank you. However in this case Power Query is much better as since we are simply doing a grouping and taking the max value of each in a group.
Relevant answer
Luc Le Noir one other way could be
• Formula used in cell K2
=VSTACK({"Customer","Street"},UNIQUE(HSTACK(G3:G12,XLOOKUP(G3:G12,B3:B14,C3:C14))))
Relevant answer
Luc Le Noir hope your query is resolved now, please edit the post as #SOLVED.
Mark Solution as "SOLVED"
Relevant answer
Hello Will Taylor , That's very nice , thanks for these two formulas , we are learning each day a little more from each other
Hot network questions
