Please see attached sample.
Note: Column A and B will be going down to 2000 rows, and so formula in Col D will need to go down to 4000+ with a simple copy and paste down.
This does not seem to work:
=LET(a,SUM(IF(MOD(ROWS(E$2:E2),5)={0,3},2,1))-1,INDEX(($A$2:$A$7,$B$2:$B$5),+SUM(IF(a=1,COUNTIF(E$1:E1,$A$2:$A$7),COUNTIF(E$1:E1,$B$2:$B$5))),,a))
Try:Formula:
Please Login or Register to view this content.
Note, this ignores blanks. It is assumed there will be no blank entries or the list will possibly not reflect your needs.
Last edited by TMS; 05-09-2024 at 09:16 AM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I get the #SPILL! error.Originally Posted by TMS
Try:Formula:Please Login or Register to view this content.
Clear anything below the cell where you want to put the formula.
See sample file updated.
Is this resolved now?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks