Need help on assigning numbers to users from list
Hi,
I have a list of numbers in Col A, usernames in Col D, and value in Col E1 (Count of Col A divided by Count of Col D).
Need help using a formula to share numbers in Col A equally to each user based on the value in E1 in Col B .
Example:
A B D E 1 user1 user1 2 2 user1 user2 3 user2 user3 4 user2 5 user3 6 user3
Please help me on this and all your help will be much appreciated.
Thanks in advance
Pradeep
I do not understand what you mean by:
Need help using a formula to share numbers in Col A equally to each user based on the value in E1 in Col B .
Can you tell us what your EXPECTED results are and try again to explain what you want.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
=countif(b:b,d1)/countif(d:d,d1)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks