Use UDF Function in worksheet

[YasserKhalil]

Hello everyone
I have this UDF Function

Please Login or Register  to view this content.

How can I use it in worksheet?

[xladept]

Hi Yasser,

Here's one way, but it fills with "#N/A" for the empty cells:

Please Login or Register  to view this content.

[YasserKhalil]

Thanks Mr. xladept
i got the results horizontally ..
Is there a way to avoid the error?

Is it possble to use this UDF function directly in the sheet?

[jindon]

Why are you asking similar questions?

Please Login or Register  to view this content.

=IFERROR(GetUnique($A$1:$A$10,ROW(A1)),"")
Copy down

[shg]

Not the most efficient, but cheap & cheerful:

Please Login or Register  to view this content.

Row\Col	A	B	C	D
1	8		8	C1:C10: {=GetUnique(A1:A20)}
2	2		2
3	8		10
4	10		5
5	10		3
6	5		9
7	3		1
8	2		4
9	9		7
10	1		6
11	4
12	7
13	1
14	10
15	6
16	1
17	2
18	8
19	8
20	3

[YasserKhalil]

Thanks mr. Jindon
I know my questions are similar .. I need to learn about using arrays ..that's my problem now
And my question about the udf function I posted in first post

As for your udf function it's great but as for blank cells it gives zero value .. I need to omit the zero and skip blanks

[YasserKhalil]

Mr. shg thanks for solving the problem of transpose .. now what about the error #NA and blanks?
I have values and blank cells in Column A

[shg]

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[YasserKhalil]

Mr. shg
Blank cells problem is skipped well .. But I still get #NA errors even after using "Iferror" function
Thanks for this great modifications

[YasserKhalil]

Thanks a lot Mr. jindon for this masterpiece
i will not forget this special UDF function that you devised

[xladept]

Hi Yasser,

This eliminates those "#N/A's" for the original question

Please Login or Register  to view this content.

[HSV]

Hello,

Here's another one.

Please Login or Register  to view this content.

[YasserKhalil]

Great and perfect Mr. HSV
Amd the most perfect thing is that it enables me to sort the values ..
Thanks a lot for this gift
I like all of you guys