• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Expand Formula across multiple cells

Status
Not open for further replies.

Taylah

New Member
Hi,

I have added new columns to my spreadsheet and have gone from 60 columns (H11:BO11) to 500 (H11:SM11) but my formula has not automatically continued as it involves multiple cells. The only way I can expand it is to type in each new cell to the formula. Does anyone know an easier way?


This is the current formula from H11 to BO11:

=IF(D11="",0(IF(H11=$H$10,1,0)+IF(I11=$I$10,1,0)+IF(J11=$J$10,1,0)+IF(K11=$K$10,1,0)+IF(L11=$L$10,1,0)+IF(M11=$M$10,1,0)+IF(N11=$N$10,1,0)+IF(O11=$O$10,1,0)+IF(P11=$P$10,1,0)+IF(Q11=$Q$10,1,0)+IF(R11=$R$10,1,0)+IF(S11=$S$10,1,0)+IF(T11=$T$10,1,0)+IF(U11=$U$10,1,0)+IF(V11=$V$10,1,0)+IF(W11=$W$10,1,0)+IF(X11=$X$10,1,0)+IF(Y11=$Y$10,1,0)+IF(Z11=$Z$10,1,0)+IF(AA11=$AA$10,1,0)+IF(AB11=$AB$10,1,0)+IF(AC11=$AC$10,1,0)+IF(AD11=$AD$10,1,0)+IF(AE11=$AE$10,1,0)+IF(AF11=$AF$10,1,0)+IF(AG11=$AG$10,1,0)+IF(AH11=$AH$10,1,0)+IF(AI11=$AI$10,1,0)+IF(AJ11=$AJ$10,1,0)+IF(AK11=$AK$10,1,0)+IF(AL11=$AL$10,1,0)+IF(AM11=$AM$10,1,0)+IF(AN11=$AN$10,1,0)+IF(AO11=$AO$10,1,0)+IF(AP11=$AP$10,1,0)+IF(AQ11=$AQ$10,1,0)+IF(AR11=$AR$10,1,0)+IF(AS11=$AS$10,1,0)+IF(AT11=$AT$10,1,0)+IF(AU11=$AU$10,1,0)+IF(AV11=$AV$10,1,0)+IF(AW11=$AW$10,1,0)+IF(AX11=$AX$10,1,0)+IF(AY11=$AY$10,1,0)+IF(AZ11=$AZ$10,1,0)+IF(BA11=$BA$10,1,0)+IF(BB11=$BB$10,1,0)+IF(BC11=$BC$10,1,0)+IF(BD11=$BD$10,1,0)+IF(BE11=$BE$10,1,0)+IF(BF11=$BF$10,1,0)+IF(BG11=$BG$10,1,0)+IF(BH11=$BH$10,1,0)+IF(BI11=$BI$10,1,0)+IF(BJ11=$BJ$10,1,0)+IF(BK11=$BK$10,1,0)+IF(BL11=$BL$10,1,0)+IF(BM11=$BM$10,1,0)+IF(BN11=$BN$10,1,0)+IF(BO11=$BO$10,1,0)))

TIA!!!
 

Attachments

  • 1621084635911.png
    1621084635911.png
    16.9 KB · Views: 8
Taylah
Could You upload a sample Excel-file which has some sample data and Your ... formula?
... and ...
Could You explain shorty ... what should it do?
As well as, that file needs expected results based Your sample data.
 
Taylah
You should reread Forum Rules
and You'll soon remember sentences about Cross-posting.
 
Taylah
You should reread Forum Rules
and You'll soon remember sentences about Cross-posting.


Hi Vletm,
This is the first time I have posted a question and didn't realise you had to put in the link to the other website where you have also posted to (thank you Fluff13 for doing so). I don't appreciate your unfriendly advice. Maybe you should reread Forum Rules and you'll soon remember to use language that conveys respect (Rule #7). https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/
Thanks.
 
Taylah
> About Your didn't realise you had to put in the link to the other website where you have also posted to
If You had read those Forum Rules before start posting then You had followed those rules.
It's it common sense to learn - find out - what to do? ... then start to do something?
I read those rules daily and many times, because before I'll notice someone to check that those have not changed.

> Could You give useful hint - How should someone advice to read those rules afterward ( after someone has skipped those ) ?
 
I suppose you took a moment to read Message to cross posters ?
And be careful about the way you treat members ( and certainly prominent ones like vietm ) . Many of our members helping on various forums, you might loose help in the future and get yourself a bad reputation. On XLForum e.g. rules are much more strictly applied than here, and the tone you used here ( without consequence) can get you banned elsewhere.
This being said, good luck with your quest
 
Last edited:
Taylah
> About Your didn't realise you had to put in the link to the other website where you have also posted to
If You had read those Forum Rules before start posting then You had followed those rules.
It's it common sense to learn - find out - what to do? ... then start to do something?
I read those rules daily and many times, because before I'll notice someone to check that those have not changed.

> Could You give useful hint - How should someone advice to read those rules afterward ( after someone has skipped those ) ?


Not sure, what you are saying?
Maybe reread your post and edit so it makes sense?

I was just wanting some help from some friendly people. Thank you for informing me of my mistake, which has now been fixed as the link to the other website is attached. In future when giving advice maybe try to be a little more respectful and understanding. Thanks!
 
Status
Not open for further replies.
Back
Top