Книга1.xlsx Screenshot_1.jpg
Good afternoon! how to do? duplicate rows are calculated among themselves and according to the highest coloring rate in the cell ? (example in the figure)
Книга1.xlsx Screenshot_1.jpg
Good afternoon! how to do? duplicate rows are calculated among themselves and according to the highest coloring rate in the cell ? (example in the figure)
Last edited by vlad-94; 09-15-2022 at 05:35 AM.
Administrative Note:
Members will tailor the solutions they offer to the version (NOT a release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
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.
MS Office tells us nothing useful - which VERSION do you have???
standart 2010
If I understand correctly then select cells F1:F7 and use the following formula as a conditional formatting rule:Formula:Please Login or Register to view this content.
Edit: Looking at this a second time it may be that the following would work better:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Last edited by JeteMc; 09-17-2022 at 09:50 AM.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
thank you JeteMc , you are the god of excel, my solution =AND(COUNTIFS($F:$F;F1)=2,AGGREGATE(14;6;$G:$G/($F:$F=F1);1),1)=G1) . Topic closed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks