<div>
<blockquote>
also need the formulas in GJ , GL, GN , GP be working
</blockquote>
I can restore those formulas but we can't do anything here until the other question is complete.
</div>


<div>
When you says something like &quot;column CJ have TRI vertically' I can't tell if you are describing the current situation or if you are asking me to change something. So please reword your whole post to say thing like &quot;Currently in Sheet1 blah, blah, blah and I'd like it changed to blah, blah, bah&quot;. Or please add blah, blah, blah in column XXX.<br />
<br />
Cuando dices algo como &quot;la columna CJ tiene TRI verticalmente&quot;, no puedo decir si estás describiendo la situación actual o si me estás pidiendo que cambie algo. Así que, por favor, vuelve a redactar tu publicación completa para decir algo como &quot;Actualmente en Hoja1 bla, bla, bla y me gustaría que cambiara a bla, bla, bah &quot;. O agregue bla, bla, bla en la columna XXX.
</div>


<div>
This is now !! CJ has the vertical shape tri<br>&nbsp;like this<table><tbody><tr><td>039</td></tr><tr><td>409</td></tr><tr><td>469</td></tr><tr><td>479</td></tr></tbody></table><br><br><br><br>but needed in this way now:&nbsp;<br><br>039409469479<br><br>HORizontallly in column CI
</div>


<div>
Please show me what all these cells should be.<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572332/2021-09-11_12-39-58.png" target="_blank" title="2021-09-11_12-39-58.png (22 KB)"><img alt="2021-09-11_12-39-58.png" class="file-block lazyload" style="max-width: 268px;" data-src="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572332/2021-09-11_12-39-58.png" /></a>
</div>


2021-09-11_12-39-58.png

<div>
0392409246924792&nbsp; this can be in columns CN
</div>


<div>
Please show me what <u>all</u> these cells should be.
</div>


ex66.PNG

<div>
<blockquote>
0392409246924792 &nbsp;this can be in columns CN
</blockquote>
039 <b>240 924 692</b> 479 2<br />
<br />
Where do those parts come from?
</div>


<div>
0392409246924792 this come form column CL<br><br>039<strong>240924692</strong>479 this come from column&nbsp; CJ
</div>


<div>
there are no the same&nbsp;
</div>


<div>
That's good to know. I thought they were from C<b>I</b>.
</div>


<div>
Please explain how 039240924692479 &nbsp;comes from column &nbsp;CJ. Column CJ does not contain any 2's.
</div>


<div>
CJ is CJ don't &nbsp;mix<br><br>CL is CL don't mix<br>&nbsp;<br>each columns is apart<br>that is<br>thats the way i needed&nbsp;
</div>


<div>
I don't understand your question
</div>


<div>
You said<br />

<blockquote>
039240924692479 this come from column &nbsp;CJ
</blockquote>
Where do the 2's come from?
</div>


<div>
2 is the times it occurs in a week<br>We are counting the TRI hat occur every week
</div>


<div>
<blockquote>
2 is the times it occurs in a week
</blockquote>
How would I know that?<br />
Anyhow are you saying that it's not just CJ, it's CJ &nbsp;plus CK?
</div>


<div>
How was I to know that?<blockquote>Anyway, are you saying it's not just CJ, it's CJ plus CK?</blockquote><br>I have never said that CJ more CK<br><br>this question is not about that<br><br>here what I'm asking you is to:<br><br><br>1-column CJ have TRI vertically &nbsp;then create TRI in column CI Horintally<br><br>example in column CI68 from &nbsp;TRi from minor to mayor<br><br>2- Column EO with MIDPAIRS vertically then create MIDPAIR HORizontally in column ES<br><br><br>3- Column EY Have MidTRi Vertically then create MidTRI vertically in Column FC<br><br>4- also need the formulas in GJ , GL, GN , GP be working &nbsp;why they not??<br><br><br><br><br><br><br><br>
</div>


<div>
Let's not talk about 3 and 4 now. <br />
<br />
Above you said<br />

<blockquote>
039240924692479 this come from column &nbsp;CJ
</blockquote>
and all I'm saying is that there are no number 2's in CJ, but there are 2's in CK, so should I combine what's in CJ with what's in CK?
</div>


<div>
you don't have to because i asking you use the column CL <br><br>CL have the count already
</div>


<div>
You said &quot;039240924692479 this come from column &nbsp;<b><u>CJ</u></b>&quot;!!!
</div>


<div>
So when you said &quot;039240924692479 this come from column &nbsp;CJ&quot;, was that a mistake and instead you should have said &nbsp;&quot;039409469479 this come from column &nbsp;CJ&quot;?
</div>


<div>
ok i see was my mistake&nbsp;
</div>


<div>
i have to repeat so many time the same situation because you don't understand<br>even if I say things right!
</div>


<div>
It means that I'm too frustrated to continue helping you any longer.
</div>


<div>
Thanks Very Much !<br>Do not be frustrated Friend, life is and has many beautiful ways of sharing it even when our hearts do not speak the same language
</div>


<div>
We have been working together for many years<br>&nbsp;I have always had my communication problems<br>and I have been sincere<br><br>I try to explain the same thing many times in many ways to help it be understood<br><br>I appreciate the help! ! today I have tried to answer quickly to be able to close the question! If I ask for help it is because I have a good intention to do something creative and productive<br><br>Concentrating on being an excel expert is not what I occupy<br>Well, I couldn't focus on what I'm doing<br><br>After so many years you come out with that !!<br>I thought you were a true friend !! and that between one thing or another you could help me !!<br>sometimes I have even walked away from the project so as not to bother with my questions<br>And you have written to me if I still work it and when I'm working on it, you treat me like this !!!<br><br>I am a Good and Serious Lady and I am not here looking for problems with anyone on the contrary, although you deny me, I have helped you to be a better Expert !! with my ideas and new solutions<br><br>The least you could have done was finish the question<br>Friend !! If you are not interested in my friendship, you are not obliged<br>we spent many hours at work and I am not just anybody from the street!
</div>


<div>
Is TRIPAIRS correct?<br />
<a href="https://filedb.experts-exchange.com/incoming/2021/09_w38/1572377/29224080.xlsb" target="_blank" class="file-inline" title="29224080.xlsb (8.2 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>29224080.xlsb</a>
</div>


29224080.xlsb

<div>
Great Job working as needed Many Thanks !!<br><br>but I also need to do these Please! :<br>&nbsp;<br>1-BZ &nbsp;vertically &nbsp;to CC Horizontally<br><br>2-EO verticcaly (MID PAIRS) to EN Horizontally<br><br>3-EQ vertically to ES Horizontally<br><br>4-EY vertically (MID TRI) to EX Horizontally<br><br>5-FA vertically to FCHorizontally<br><br><br><br><br><br>
</div>


<div>
Before I do the rest I wanted to point out the column CM is not being used. Would you like me to use CM instead of CN?<br />
Antes de hacer el resto, quería señalar que la columna CM no se está utilizando. ¿Le gustaría que use CM en lugar de CN?
</div>


<div>
<blockquote><blockquote>Before I do the rest I wanted to point out the column CM is not being used. Would you like me to use CM instead of CN?&nbsp;</blockquote></blockquote><br>Thanks Martin for the comment on CM<br><br>The CM column has a counter that I have not put to work<br>we will not be able to use it<br><br>so the CM Columns is not available
</div>


<div>
<blockquote>
1-BZ &nbsp;vertically &nbsp;to CC Horizontally
</blockquote>
Which columns should I use for the new output?<br />
¿Qué columnas debo usar para la nueva salida?
</div>


<div>
1-BZ &nbsp;vertically &nbsp;to&nbsp; &nbsp;&nbsp;<u><strong>CC Horizontally&nbsp; (output)</strong></u><br><br>2-EO verticcaly (MID PAIRS) to <strong><u>EN Horizontally&nbsp;<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br>3-EQ vertically to <strong><u>ES Horizontally&nbsp;&nbsp;<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br>4-EY vertically (MID TRI) to <strong><u>EX Horizontally_<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br>5-FA vertically to <strong><u>FC Horizontally__<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br><br>
</div>


<div>
<ol type="1">
<li>BZ is already being used. Are you saying that it's okay for me to replace what's there with the new vertical data?</li>
<li>I previously added the HOR button. Is it okay if I remove that button and include what it does when the PAIR button is clicked?</li>
</ol>
<br />

<ol type="1">
<li>BZ ya se está utilizando. ¿Está diciendo que está bien que reemplace lo que hay allí con los nuevos datos verticales?</li>
<li>Anteriormente agregué el botón HOR. ¿Está bien si elimino ese botón e incluyo lo que hace cuando se hace clic en el botón EMPAREJAR?</li>
</ol>
</div>


<div>
<blockquote><ol><li>BZ is already being used. Are you saying that it's okay for me to replace what's there with the new vertical data?</li></ol></blockquote>BZ have the data to be in CC.<br><br>CC have some data but can be erase (sorry, don't mention it)<br><br><ol><li>I previously added the HOR button. Is it okay if I remove that button and include what it does when the PAIR button is clicked? &nbsp;</li></ol><br>Will be Great !! yes ! you can<br><br><br>1-Data in BZ &nbsp;vertically &nbsp;to &nbsp; &nbsp;<u><strong>CC Horizontally &nbsp;(output)</strong></u><br><br>2- Data in EO verticcaly (MID PAIRS) to <strong><u>EN Horizontally <u><strong>(output)</strong></u>&nbsp;</u></strong><br><br>3-Data in EQ vertically to <strong><u>ES Horizontally &nbsp;<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br>4-Data in EY vertically (MID TRI) to <strong><u>EX Horizontally_<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br>5-Data in FA vertically to <strong><u>FC Horizontally__<u><strong>(output)</strong></u>&nbsp;</u></strong><br><br><br><br><br>
</div>


<div>
For the TRI PAIRS button we used columns CI and CN for the new output and what I'm asking you is which two columns should I use for PAIR button. Please just answer that one question.<br />
<br />
Para el botón TRI PAIRS usamos las columnas CI y CN para la nueva salida y lo que le pregunto es qué dos columnas debería usar para el botón PAIR. Por favor, solo responda esa pregunta.
</div>


<div>
<blockquote>For the TRI PAIRS button we used columns CI and CN for the new output and what I'm asking you is which two columns should I use for PAIR button. Please just answer that one question&nbsp;</blockquote><br>Columns CB and CC respectively<br><br><br><br><br>
</div>


29224080a.xlsb

ACCOUNTING ASSISTANT

ADRIANA P

<div>
PAIR and TRI<br>working as expected
</div>


<div>
still need MID PAIR and MID TRI
</div>


<div>
<blockquote>
still need MID PAIR and MID TRI
</blockquote>
I understand that. Are EN and ES the columns you want to use with MID PAIR?<br />
<br />
Entiendo que. ¿Son EN y ES las columnas que desea usar con MID PAIR?
</div>


29224080b.xlsb

<div>
Great Job !<br>Mid Pair working as expected
</div>


<div>
Are EX and FC the columns I should use for TRIPLE MID?<br />
<br />
I just noticed that column FB shows a maximum of 5 values. Do you want that changed so that it shows all possible values like we recently did for some other columns?<br />
<br />
Acabo de notar que la columna FB muestra un máximo de 5 valores. ¿Quiere que eso cambie para que muestre todos los valores posibles como hicimos recientemente para algunas otras columnas?
</div>


<div>
<blockquote>Are EX and FC the columns I should use for TRIPLE MID?&nbsp;</blockquote>Yes !! they are.<br><br><blockquote>I just noticed that column FB shows a maximum of 5 values. Do you want that changed so that it shows all possible values like we recently did for some other columns?</blockquote><br>yes Please !!<br><br><br><br><br>
</div>


29224080c.xlsb

<div>
Great Job Best Expert !<br><br>I see that all the columns after pressing the button keep the same number<br><br>but in columns CB and CC if I press the PAIR button<br><br>this keeps adding the value you could try it and verify it<br><br>the other columns don't do that
</div>


29224080d.xlsb

<div>
<div class="content wysiwyg-content fr-view">
<p>4nF to add Tri - HOR</p><p><a class="fr-file" href="https://filedb.experts-exchange.com/incoming/2021/09_w37/1572263/29223939--1-.xlsb" rel="ugc">29223939 (1).xlsb</a></p><p>1-column CJ have TRI vertically &nbsp;then create TRI in column CI Horintally</p><p><br></p><p>example in column CI68 from &nbsp;TRi from minor to mayor</p><p><br></p><p>2- Column EO with MIDPAIRS vertically then create MIDPAIR HORizontally in column ES</p><p><br></p><p><br></p><p>3- Column EY Have MidTRi Vertically then create MidTRI vertically in Column FC</p><p><br></p><p>4- also need the formulas in GJ , GL, GN , GP be working &nbsp;why they not??</p>
</div>
</div>


29223939--1-.xlsb


4nF to add Tri - HOR
29223939 (1).xlsb
1-column CJ have TRI vertically  then create TRI in column CI Horintally
example in column CI68 from  TRi from minor to mayor
2- Column EO with MIDPAIRS vertically then create MIDPAIR HORizontally in column ES
3- Column EY Have MidTRi Vertically then create MidTRI vertically in Column FC
4- also need the formulas in GJ , GL, GN , GP be working  why they not??

create   horizontally for Tri -Midpair- Midtri 4n

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.