I require this formula to only count a maximum of “one” for each column.
I need each of these columns to have a max result of one. I do not know how to do it.. I would be super grateful for any help.
Here is my current formula:
=IF(COUNT(W128,W129,N128,N129,G128,G129,AF117,AF118,Y117,Y118,P117,P118,I117,I118,AI106,AI107,AB106,AB107)>=5,round(SUM(T128:AC129,C128:Q129,AF117:AH118)*0.05,2),"")
Hello beekerdale,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi beekerdale, I think that you will need to post your question in one of the questions forums like the Excel Formulas & functions forum rather than the Hello..Introduce yourself forum to get any answers. please see the link below.Originally Posted by beekerdale
Excel Formulas & functions
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Ah, Yes indeed! Thanks so much,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks