Concatenate and maybe countif? but how?

W

wrylie

New Member
Joined
Dec 3, 2008
Messages
9
Hi all!
I have a list as shown below left. I need the list to look like the one below right. I have tried ump-teen different ways, and spent hours googling, but cannot figure it out. Can anyone help?
Thanks a million!​


<TABLE dir=ltr cellSpacing=0 cellPadding=12 width=578 border=1><TBODY><TR><TD vAlign=bottom width="16%" height=0>bob

​
</TD><TD vAlign=bottom width="16%" height=0>form1

​
</TD><TD vAlign=bottom width="20%" height=0>Take this
<---

​
</TD><TD vAlign=bottom width="16%" height=0>bob
​
</TD><TD vAlign=bottom width="31%" height=0>form1, form2, form3
​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>bob
​
</TD><TD vAlign=bottom width="16%" height=0>form2

​
</TD><TD vAlign=bottom width="20%" height=0>
​
</TD><TD vAlign=bottom width="16%" height=0>mary
​
</TD><TD vAlign=bottom width="31%" height=0>form1, form2
​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>bob

​
</TD><TD vAlign=bottom width="16%" height=0>form3

​
</TD><TD vAlign=bottom width="20%" height=0>Turn it into this --->

​
</TD><TD vAlign=bottom width="16%" height=0>ken

​
</TD><TD vAlign=bottom width="31%" height=0>form1, form2, form3, form4

​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>mary

​
</TD><TD vAlign=bottom width="16%" height=0>form1

​
</TD><TD vAlign=bottom width="20%" height=0>

​
</TD><TD vAlign=bottom width="16%" height=0>

​
</TD><TD vAlign=bottom width="31%" height=0>

​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>mary

​
</TD><TD vAlign=bottom width="16%" height=0>form2

​
</TD><TD vAlign=bottom width="20%" height=0>

​
</TD><TD vAlign=bottom width="16%" height=0>

​
</TD><TD vAlign=bottom width="31%" height=0>

​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>ken

​
</TD><TD vAlign=bottom width="16%" height=0>form1

​
</TD><TD vAlign=bottom width="20%" height=0>

​
</TD><TD vAlign=bottom width="16%" height=0>

​
</TD><TD vAlign=bottom width="31%" height=0>

​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>ken

​
</TD><TD vAlign=bottom width="16%" height=0>form2

​
</TD><TD vAlign=bottom width="20%" height=0>

​
</TD><TD vAlign=bottom width="16%" height=0>

​
</TD><TD vAlign=bottom width="31%" height=0>

​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>ken

​
</TD><TD vAlign=bottom width="16%" height=0>form3

​
</TD><TD vAlign=bottom width="20%" height=0>

​
</TD><TD vAlign=bottom width="16%" height=0>

​
</TD><TD vAlign=bottom width="31%" height=0>

​
</TD></TR><TR><TD vAlign=bottom width="16%" height=0>ken

​
</TD><TD vAlign=bottom width="16%" height=0>form4

​
</TD><TD vAlign=bottom width="20%" height=0>

​
</TD><TD vAlign=bottom width="16%" height=0>

​
</TD><TD vAlign=bottom width="31%" height=0>

​
</TD></TR></TBODY></TABLE>​
 
Sort by date Sort by votes
I have a feeling I've messed this table up because the 3rd column isn't always different numbers (sometimes they're the same) and fixing it would just be abusing the thread, I'll just try and figure it out. Sorry about it everyone.
 
Upvote 0
Calvinball96 said:
I have a feeling I've messed this table up because the 3rd column isn't always different numbers (sometimes they're the same) and fixing it would just be abusing the thread, I'll just try and figure it out. Sorry about it everyone.
Click to expand...
It isn't a problem, the forum exists to provide help. :)

If you want more help, just post back with some more representative data and expected results.
It would also help if you clarified the columns used and where the results should go. In post #10 you mentioned data in columns A:G (7 columns) but your data table only had 5 columns of data.
 
Upvote 0
Peter_SSs said:
It isn't a problem, the forum exists to provide help. :)

If you want more help, just post back with some more representative data and expected results.
It would also help if you clarified the columns used and where the results should go. In post #10 you mentioned data in columns A:G (7 columns) but your data table only had 5 columns of data.
Click to expand...

Thanks for the advice Peter. After not thinking about it for a while I decided that not asking for help and work aimlessly would probably just get me more frustrated and wrong results. It appears I was hiding columns on accident so that's why I had the extra columns.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD][/TD]
[TD]a[/TD]
[TD]AA[/TD]
[TD]AA[/TD]
[TD]<<[/TD]
[TD]into[/TD]
[TD]>>[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]a, a[/TD]
[TD]AA[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]a[/TD]
[TD]AA[/TD]
[TD]AA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]B[/TD]
[TD]1[/TD]
[TD]b, c[/TD]
[TD]BB[/TD]
[TD]BB[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]b[/TD]
[TD]BB[/TD]
[TD]BB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD]d[/TD]
[TD]CC[/TD]
[TD]CC[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]c[/TD]
[TD]BB[/TD]
[TD]BB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]D[/TD]
[TD]2, 3, 4[/TD]
[TD]e, f, f[/TD]
[TD]DD[/TD]
[TD]DD[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD]d[/TD]
[TD]CC[/TD]
[TD]CC[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E[/TD]
[TD][/TD]
[TD]d[/TD]
[TD]EE[/TD]
[TD]EE[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]2[/TD]
[TD]e[/TD]
[TD]DD[/TD]
[TD]DD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]a[/TD]
[TD]FF[/TD]
[TD]FF[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]3[/TD]
[TD]f[/TD]
[TD]DD[/TD]
[TD]DD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]4[/TD]
[TD]f[/TD]
[TD]DD[/TD]
[TD]DD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD][/TD]
[TD]d[/TD]
[TD]EE[/TD]
[TD]EE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]1[/TD]
[TD]a[/TD]
[TD]FF[/TD]
[TD]FF[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The data goes from columns A:E with A being order numbers (these repeat) B tracking info (to be combined, comma separated), C descriptions (combined as well, comma separated), D and E are client info based on column A and repeat as well. The column cells to be combined when rows are brought together are B and C, the other 3 don't need to be. The results would over-write the original columns.

Transposing whats in the original sheet to this online table would have been a pain so hopefully the above table does a well enough job representing it. Thanks again for this and if something doesn't make sense ask away.
 
Upvote 0
This seems to work for the sample data provided at least.

<font face=Courier New><br><SPAN style="color:#00007F">Sub</SPAN> Rearrange_v2()<br>  <SPAN style="color:#00007F">Dim</SPAN> r <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN>, lr <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>  <br>  Application.ScreenUpdating = <SPAN style="color:#00007F">False</SPAN><br>  lr = Range("A" & Rows.Count).End(xlUp).Row<br>  <SPAN style="color:#00007F">For</SPAN> r = lr <SPAN style="color:#00007F">To</SPAN> 2 <SPAN style="color:#00007F">Step</SPAN> -1<br>    <SPAN style="color:#00007F">If</SPAN> Cells(r, "A").Value = Cells(r - 1, "A").Value <SPAN style="color:#00007F">Then</SPAN><br>      <SPAN style="color:#00007F">If</SPAN> Cells(r, "B").Value <> Cells(r - 1, "B").Value <SPAN style="color:#00007F">Then</SPAN><br>        Cells(r - 1, "B").Value = Cells(r - 1, "B").Value & ", " & Cells(r, "B").Value<br>      <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>      Cells(r - 1, "C").Value = Cells(r - 1, "C").Value & ", " & Cells(r, "C").Value<br>      Rows(r).Delete<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>  <SPAN style="color:#00007F">Next</SPAN> r<br>  Application.ScreenUpdating = <SPAN style="color:#00007F">True</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>
 
Upvote 0
Peter,

You are quite the excel expert. I am hoping you can help me. The VBA I need is similar to those you have posted already. I have the following set up in excel (except "Audit Experience" and " Capability Experience" formula) but I cannot figure out the formula to get "Audit Experience" or "Capability Experience" to give me these values:

[TABLE="width: 1398"]
<colgroup><col span="3"><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]Auditor[/TD]
[TD]Title[/TD]
[TD]Client[/TD]
[TD]Site[/TD]
[TD]Audit Type[/TD]
[TD]Capabilities[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[TD] [/TD]
[TD]Auditor[/TD]
[TD]Number of Audits To-Date[/TD]
[TD]Audit Experience[/TD]
[TD]Capability Experience[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]TBD[/TD]
[TD]Vendor[/TD]
[TD]a[/TD]
[TD="align: right"]11/1/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]Adam[/TD]
[TD="align: right"]6[/TD]
[TD]Vendor, Site, ARO, ARO, ARO[/TD]
[TD]a, g, d, e, b, e[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Site TBD[/TD]
[TD]Site[/TD]
[TD]b[/TD]
[TD="align: right"]10/1/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]Bob[/TD]
[TD="align: right"]6[/TD]
[TD]Site, Vendor, ARO, ARO, CRO, TMF[/TD]
[TD]b, a, c, h, a, d[/TD]
[/TR]
[TR]
[TD]Jeff[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Site TBD[/TD]
[TD]Site[/TD]
[TD]c[/TD]
[TD="align: right"]10/1/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]Jeff[/TD]
[TD="align: right"]3[/TD]
[TD]Site, Vendor, ARO[/TD]
[TD]c, h, f[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Vendor TBD[/TD]
[TD]Vendor[/TD]
[TD]d[/TD]
[TD]N.A.[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]James[/TD]
[TD="align: right"]1[/TD]
[TD]Vendor[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]Claudia[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Site TBD[/TD]
[TD]Vendor[/TD]
[TD]e[/TD]
[TD]N.A.[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]Claudia[/TD]
[TD="align: right"]1[/TD]
[TD]Vendor[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Jenn[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Site TBD[/TD]
[TD]Site[/TD]
[TD]f[/TD]
[TD="align: right"]10/1/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD]Jenn[/TD]
[TD="align: right"]6[/TD]
[TD]Site, Vendor, Vendor, ARO, Vendor[/TD]
[TD]f, I, b, g, I, b[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Site TBD[/TD]
[TD]Site[/TD]
[TD]g[/TD]
[TD="align: right"]10/1/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jeff[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Vendor TBD[/TD]
[TD]Vendor[/TD]
[TD]h[/TD]
[TD]???[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jenn[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Vendor TBD[/TD]
[TD]Vendor[/TD]
[TD]i[/TD]
[TD="align: right"]11/15/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Vendor TBD[/TD]
[TD]Vendor[/TD]
[TD]a[/TD]
[TD="align: right"]11/15/2012[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jenn[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Site TBD[/TD]
[TD]Vendor[/TD]
[TD]b[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Site TBD[/TD]
[TD]ARO[/TD]
[TD]c[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Vendor TBD[/TD]
[TD]ARO[/TD]
[TD]d[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Vendor TBD[/TD]
[TD]ARO[/TD]
[TD]e[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jeff[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Vendor TBD[/TD]
[TD]ARO[/TD]
[TD]f[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jenn[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Site TBD[/TD]
[TD]ARO[/TD]
[TD]g[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Site TBD[/TD]
[TD]ARO[/TD]
[TD]h[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jenn[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Vendor TBD[/TD]
[TD]ARO[/TD]
[TD]i[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Vendor TBD[/TD]
[TD]CRO[/TD]
[TD]a[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Vendor TBD[/TD]
[TD]ARO[/TD]
[TD]b[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jenn[/TD]
[TD][/TD]
[TD]def[/TD]
[TD]Site TBD[/TD]
[TD]Vendor[/TD]
[TD]c[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD]xyz[/TD]
[TD]Site TBD[/TD]
[TD]TMF[/TD]
[TD]d[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD]abc[/TD]
[TD]Vendor TBD[/TD]
[TD]Site[/TD]
[TD]e[/TD]
[TD="align: right"]1/0/1900[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Basically I know the "Number of Audits To-Date" is a simple countif, but the "Audit Experience" and "Capability Experience" needs to concatenate all the values in "Audit Type" in the next column, and the same for Capabilities. I'll take VBA or any formula.
Please help and thank you in advance.
 
Upvote 0
Just joined MrExcel so I can comment on this thread. I use this forum quite frequently and have found many answers to my questions. But this problem that I have been having has taken me two days to work on and after seeing this thread this fixed my issue so quickly. Just wanted to give a huge thanks for this!!! Nice job Peter_SSs!!!
 
Upvote 0
Peter_SSs said:
jindon's code didn't work for me, so here is another suggestion. Try it on a copy of your workbook.


Sub Rearrange()
****Dim lr As Long, r As Long
****
****Application.ScreenUpdating = False
****lr = Range("A" & Rows.Count).End(xlUp).Row
****For r = lr To 2 Step -1
********With Cells(r, 1)
************If .Value = .Offset(-1).Value Then
****************.Offset(-1, 1).Value = .Offset(-1, 1).Value & ", " _
****************************************& .Offset(, 1).Value
****************.EntireRow.Delete
************End If
********End With
****Next r
****Columns("B").AutoFit
****Application.ScreenUpdating = True
End Sub
Click to expand...

Hi Peter,

sorry to reopen this thread but i have a question. I have almost the same issue as the original poster but.

Column A has my lookup value
Column E has the multiple values i wish to bring together
Column I is where i would like the "concatenated values to be pasted.

i'll keep tinkering with our code to try and work it out but if you get to this message before i do that would be amazing.

thanks again for all your support and wisdom.
 
Upvote 0
kristian84 said:
i'll keep tinkering with our code to try and work it out but if you get to this message before i do that would be amazing.
Click to expand...
I would do it differently now.
Try this in a copy of your workbook.
Post back with details if it isn't what you wanted.

Rich (BB code): 
Sub Rearrange_New()
  Dim lr As Long, r As Long, j As Long, k As Long
  Dim a, b
  
  lr = Range("A" & Rows.Count).End(xlUp).Row
  a = Range("A1:E" & lr).Value
  ReDim b(1 To lr, 1 To 2)
  k = 1
  b(1, 1) = a(1, 1): b(1, 2) = a(1, 5)
  For r = 2 To lr
    If a(r, 1) = a(r - 1, 1) Then
      b(k, 2) = b(k, 2) & ", " & a(r, 5)
    Else
      k = k + 1
      b(k, 1) = a(r, 1): b(k, 2) = a(r, 5)
    End If
  Next r
  With Range("I1").Resize(k, 2)
    .Value = b
    .Columns.AutoFit
  End With
End Sub


Sample data & results:

Excel Workbook
ABCDEFGHIJ
1bobform1bobform1, form2, form3
2bobform2maryform1, form2
3bobform3kenform1, form2, form3, form4
4maryform1
5maryform2
6kenform1
7kenform2
8kenform3
9kenform4
10
Concatenate
 
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Question Question
How to Expand Components of an Assembly while preserving Dates
Replies
2
Views
121
Vog2654
V
A
  • Question Question
Switch data between columns on same row
Replies
8
Views
162
Peter_SSs
Peter_SSs
SFCChase
  • Question Question
Use Dropdown to search other tabs
Replies
4
Views
243
SFCChase
SFCChase
D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
953
smozgur
smozgur
N
  • Solved
Averaging every Nth cell in a column
Replies
9
Views
215
Peter_SSs
Peter_SSs

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top