Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
48
Views
Topic starter
Hello excel experts
I have in the sample file in columns G & H two formulas
Array formula in G
=SUM(IF(($B$3:$B$17=B3)*(E3<$E$3:$E$17),1/COUNTIFS($B$3:$B$17,B3,$E$3:$E$17,$E$3:$E$17)))+1
and a formula in H
=G3&IF(COUNTIFS($B$3:$B3,B3,$E$3:$E3,$E$3:$E3)>1," R","")
How can get the same results in column H with just one formula? If it is impossible I accept VBA code
Thanks advanced for help
Posted : 04/02/2018 2:20 am
Hi KingTamo
See if this is what you want.
Sunny
Posted : 08/02/2018 8:31 pm
Topic starter
That's exactly what I was searching for
Thank you very much
Posted : 09/02/2018 3:33 am
