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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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

B
  • Question Question
Create graphs, charts or dashboards to show activity progress over time
Replies
0
Views
84
benobee
B
E
  • Solved
Using Excel to copy and paste one of 9 different replies
Replies
6
Views
274
ellison
E
Asbestos_Jen
  • Question Question
Compare multiple parameters of samples to reference values (Excel 2007)
Replies
3
Views
392
Asbestos_Jen
Asbestos_Jen
O
  • Question Question
Adding new items to dataset that a UNIQUE function pulls from breaks adjacent columns
Replies
1
Views
370
SunnyAlv
SunnyAlv
O
  • Solved
Index/Match, Nested IF statements, or Array Formula?
Replies
9
Views
166
Ol Reliable
O

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

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