LinkBack URL
About LinkBacks
hi all members
https://www.mrexcel.com/forum/excel-...ml#post5135623
calculation automatique of names
hi all members
https://www.mrexcel.com/forum/excel-...ml#post5135623
Thank you for the cross-post link, however, you must also explain your problem in full here if you want help here. Please do so in your next post.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In a standard module.
Use like
Please Login or Register to view this content.PHP Code:=CountUnique(A1:A25)
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
hi
@AliGW thank you for informing me, i will in next post.
@bakerman2 thank you to trying helping me, but your code does not working with me, in fact i could not activate in macro
what i want to do is how to make automatique calculations of differents names which existe in same column when we have alot of same names, what i want not sum of name1 and sum of name2, what i want sum of different name
hi all
i find the solution with this formula
=SOMMEPROD(1/NB.SI($A$2:$A$100;$A$2:$A$100)) and =SOMMEPROD(($A$2:$A$100<>"")/NB.SI($A$2:$A$100;$A$2:$A$100&""))
thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks