LinkBack URL
About LinkBacks
Using Excel 2010
Hello,
I need to count AD sets till they finds in any of the 2 upper and lower rows…, If there are number in both rows just highlight cell in colour red…, if both are blank result 0
Please help.
Regards,
Moti
Using Excel 2010
Hello,
I need to count AD sets till they finds in any of the 2 upper and lower rows…, If there are number in both rows just highlight cell in colour red…, if both are blank result 0
Please help.
Regards,
Moti
In cell 'C72' try;Formula:
Please Login or Register to view this content.
Then pull across.
You can also pull down, but need to adjust the range as the range is 2 rows.
Conditional formatting to for red cells applied only to first 4 rows where I entered the formula for you.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
@ORoos, formula does work but I have plenty of set more than 600+ so far will be difficult to apply formula for each set independently one by one. Any ways thank you for your help. Good Luck!
I will wait if anyone suggests VBA solution for this.
Kind Regards,
Moti
Please Login or Register to view this content.
Change the highlighted code as required.
Last edited by JohnTopley; 04-08-2024 at 04:13 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
@JohnTopley, this is an all-in-one solution also thank you for giving easy and flexible range changes choice.
I appreciate your time to solve this problem. I wish you good day and good luck.
Kind Regards,
Moti
Although John beat me to it, I post my solution anyway
You can also adjust the start of the Rows to analyze, and the row where the results start.
Please Login or Register to view this content.
@ORoos, thank you for giving one more option. JT’s code is bit more flexible; I wish you good day and good luck.
Kind Regards,
Moti
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks