Leasing Report Progress

A

a_t83

New Member
Joined
Sep 16, 2015
Messages
11
Please check the below table for each leasing agent:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Client[/TD]
[TD][TABLE="width: 102"]
<tbody>[TR]
[TD]Status[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Just Browsing[/TD]
[TD]Interested[/TD]
[TD]On the Fence[/TD]
[TD]Hook Line & Sinker[/TD]
[TD]Lead Lost[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Active[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]14-Jul-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 96"]
<tbody>[TR]
[TD]15-Jul-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD]16-Jul-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 95"]
<tbody>[TR]
[TD]17-Jul-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Active[/TD]
[TD][/TD]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD]9-May-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD]16-Sep-19[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Active[/TD]
[TD][/TD]
[TD]9-Apr-19[/TD]
[TD][/TD]
[TD][/TD]
[TD]5-May-19[/TD]
[/TR]
</tbody>[/TABLE]

I need to count 5 categories as the below:

1- Just Browsing
2- Interested
3- On the Fence
4- Hook Line & Sinker
5- Lead Lost

But I want to count the last date of the progress without deleting the date/s before.

For example, in Client 1 we need to count only (Hook Line & Sinker), and Client 2 we will count only (On the Fence), etc

The results I need to be as the below:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Progress Update[/TD]
[TD]Clients Status[/TD]
[/TR]
[TR]
[TD]Just Browsing[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Interested[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]On the Fence[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Hook Line & Sinker[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Lead Lost[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]



Please let me know if this it clear.
 
Last edited:

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Here is a VBA solution that will work for you. Make sure your raw data is on a sheet called Data and the Results are on a sheet named Results. Put your Results headers in column A starting with A1.

Code: 
Option Explicit


Sub Leasing()
    Dim s1 As Worksheet, s2 As Worksheet
    Set s1 = Sheets("Data")
    Set s2 = Sheets("Results")
    Dim a As Long, b As Long, c As Long, d As Long, e As Long
    Dim lr As Long, lc As Long, i As Long
    Application.ScreenUpdating = False
    a = 0
    b = 0
    c = 0
    d = 0
    e = 0
    lr = s1.Range("A" & Rows.Count).End(xlUp).Row
    For i = 2 To lr
        lc = s1.Cells(i, Columns.Count).End(xlToLeft).Column
        If lc = 3 Then a = a + 1
        If lc = 4 Then b = b + 1
        If lc = 5 Then c = c + 1
        If lc = 6 Then d = d + 1
        If lc = 7 Then e = e + 1
    Next i
    s2.Range("B1") = a
    s2.Range("B2") = b
    s2.Range("B3") = c
    s2.Range("B4") = d
    s2.Range("B5") = e
    Application.ScreenUpdating = True
    MsgBox "Action Complete"




End Sub
Sheet Data
[table="class:thin_grid"]
[tr][td]v[/td]
[td="bgcolor:#ECF0F0, align:center"]A[/td]
[td="bgcolor:#ECF0F0, align:center"]B[/td]
[td="bgcolor:#ECF0F0, align:center"]C[/td]
[td="bgcolor:#ECF0F0, align:center"]D[/td]
[td="bgcolor:#ECF0F0, align:center"]E[/td]
[td="bgcolor:#ECF0F0, align:center"]F[/td]
[td="bgcolor:#ECF0F0, align:center"]G[/td]
[/tr][tr][td="bgcolor:#ECF0F0, align:center"]1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Client[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Status[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Just Browsing[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Interested[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]On the Fence[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Hook Line & Sinker[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Lead Lost[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]2[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/14/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/15/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/16/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/17/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]3[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]2[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5/9/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]9/16/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]4[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]3[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]4/9/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5/5/2019[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]5[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]4[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/14/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/15/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/16/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/17/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]6[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5/9/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]9/16/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]7[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]6[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]4/9/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5/5/2019[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]8[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/14/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/15/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/16/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/17/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]9[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]8[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5/9/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]9/16/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]10[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]9[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Active[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]4/9/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"][/td]
[td="bgcolor:#FFFFFF, align:CENTER"]5/5/2019[/td]
[/tr]
[/table]
Sheet Results
[table="class:thin_grid"]
[tr][td]v[/td]
[td="bgcolor:#ECF0F0, align:center"]A[/td]
[td="bgcolor:#ECF0F0, align:center"]B[/td]
[/tr][tr][td="bgcolor:#ECF0F0, align:center"]1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Just Browsing[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]0[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]2[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Interested[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]0[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]3[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]On the Fence[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]3[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]4[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Hook Line & Sinker[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]3[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]5[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Lead Lost[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]3[/td]
[/tr]
[/table]
 
Upvote 0
Many thanks it's working perfectly.

alansidman said:
Here is a VBA solution that will work for you. Make sure your raw data is on a sheet called Data and the Results are on a sheet named Results. Put your Results headers in column A starting with A1.

Code: 
Option Explicit


Sub Leasing()
    Dim s1 As Worksheet, s2 As Worksheet
    Set s1 = Sheets("Data")
    Set s2 = Sheets("Results")
    Dim a As Long, b As Long, c As Long, d As Long, e As Long
    Dim lr As Long, lc As Long, i As Long
    Application.ScreenUpdating = False
    a = 0
    b = 0
    c = 0
    d = 0
    e = 0
    lr = s1.Range("A" & Rows.Count).End(xlUp).Row
    For i = 2 To lr
        lc = s1.Cells(i, Columns.Count).End(xlToLeft).Column
        If lc = 3 Then a = a + 1
        If lc = 4 Then b = b + 1
        If lc = 5 Then c = c + 1
        If lc = 6 Then d = d + 1
        If lc = 7 Then e = e + 1
    Next i
    s2.Range("B1") = a
    s2.Range("B2") = b
    s2.Range("B3") = c
    s2.Range("B4") = d
    s2.Range("B5") = e
    Application.ScreenUpdating = True
    MsgBox "Action Complete"




End Sub
Sheet Data
[TABLE="class: thin_grid"]
<tbody>[TR]
[TD]v[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]A[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]B[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]C[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]D[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]E[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]F[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]G[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]1[/TD]
[TD="bgcolor: #FFFFFF"]Client[/TD]
[TD="bgcolor: #FFFFFF"]Status[/TD]
[TD="bgcolor: #FFFFFF"]Just Browsing[/TD]
[TD="bgcolor: #FFFFFF"]Interested[/TD]
[TD="bgcolor: #FFFFFF"]On the Fence[/TD]
[TD="bgcolor: #FFFFFF"]Hook Line & Sinker[/TD]
[TD="bgcolor: #FFFFFF"]Lead Lost[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]2[/TD]
[TD="bgcolor: #FFFFFF"]1[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"]7/14/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/15/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/16/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/17/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]3[/TD]
[TD="bgcolor: #FFFFFF"]2[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]5/9/2019[/TD]
[TD="bgcolor: #FFFFFF"]9/16/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]4[/TD]
[TD="bgcolor: #FFFFFF"]3[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]4/9/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]5/5/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]5[/TD]
[TD="bgcolor: #FFFFFF"]4[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"]7/14/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/15/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/16/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/17/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]6[/TD]
[TD="bgcolor: #FFFFFF"]5[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]5/9/2019[/TD]
[TD="bgcolor: #FFFFFF"]9/16/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]7[/TD]
[TD="bgcolor: #FFFFFF"]6[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]4/9/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]5/5/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]8[/TD]
[TD="bgcolor: #FFFFFF"]7[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"]7/14/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/15/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/16/2019[/TD]
[TD="bgcolor: #FFFFFF"]7/17/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]9[/TD]
[TD="bgcolor: #FFFFFF"]8[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]5/9/2019[/TD]
[TD="bgcolor: #FFFFFF"]9/16/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]10[/TD]
[TD="bgcolor: #FFFFFF"]9[/TD]
[TD="bgcolor: #FFFFFF"]Active[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]4/9/2019[/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"][/TD]
[TD="bgcolor: #FFFFFF"]5/5/2019[/TD]
[/TR]
</tbody>[/TABLE]
Sheet Results
[TABLE="class: thin_grid"]
<tbody>[TR]
[TD]v[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]A[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]B[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]1[/TD]
[TD="bgcolor: #FFFFFF"]Just Browsing[/TD]
[TD="bgcolor: #FFFFFF"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]2[/TD]
[TD="bgcolor: #FFFFFF"]Interested[/TD]
[TD="bgcolor: #FFFFFF"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]3[/TD]
[TD="bgcolor: #FFFFFF"]On the Fence[/TD]
[TD="bgcolor: #FFFFFF"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]4[/TD]
[TD="bgcolor: #FFFFFF"]Hook Line & Sinker[/TD]
[TD="bgcolor: #FFFFFF"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ECF0F0]#ECF0F0[/URL] , align: center"]5[/TD]
[TD="bgcolor: #FFFFFF"]Lead Lost[/TD]
[TD="bgcolor: #FFFFFF"]3[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Using Excel to copy and paste one of 9 different replies
Replies
6
Views
272
ellison
E
Asbestos_Jen
  • Question Question
Compare multiple parameters of samples to reference values (Excel 2007)
Replies
3
Views
359
Asbestos_Jen
Asbestos_Jen
O
  • Question Question
Adding new items to dataset that a UNIQUE function pulls from breaks adjacent columns
Replies
1
Views
343
SunnyAlv
SunnyAlv
E
  • Solved
Excel formula to count NEW unique names per month
Replies
5
Views
220
Fluff
Fluff
L
  • Question Question
VBA Code to add in blank rows at a specific point, then do a formula in that blank row
Replies
1
Views
784
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

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