In my Worksheet I have 80 columns (80) numbers with over 100 rows.
All numbers are mixed.
I picked 20 numbers and mixed them using a special algorithm.
My conditional formating formula picks(marks) 20 numbers in each row.
I have divided the worksheet in to 2 even parts (40 numbers/columns in each side).
I would like to find a formating formula that would tell me at the end of each row haw many numbers is in each half of my worksheet. How many numbers in first 40 columns and how many in second half.
Is it possible?
If you need more explanations please let me know.
Thanks in advance for your help.
John
Bookmarks