Rank Duplicate Values With Duplicate Ranks Without Skipping Sequence

P

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,750
Hi all,

I have the following data in A1:A7

100
40
80
80
85
60
60

In the corresponding column B, I want to return the rank of each (descending) i.e.

1
5
3
3
2
4
4

If I use the function rank, what I get is:

1
7
3
3
2
5
5

How can this be done?

Thanks
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
see data and explanation below

Excel Workbook
AB
1dataserial
21001
3402
4803
5804
6855
7606
8607
Sheet2


data is in col A
in col B type 1 2 3 4 etc (or enter 1 in B2 and select B2 to B8-click edit fill - series - OK)
B col will be 1 2 3 4 5 etc
sort col A and B according to col.A descending.
C1 enter "rank"
c2 enter 1
c3 formula
=IF(A3=A2,C2,C2+1)
copy C3 down
highlight C2 to c8 edit copy (control+c)
keeping highlighting same edit-
pastespecial-values

sort cols A B C
according to column B ascending

the complete set (result) will be
Excel Workbook
ABC
1dataserialrank
210011
34025
48033
58043
68552
76064
86074
Sheet2
 
Upvote 0
venkat1926 said:
see data and explanation below

Excel Workbook
AB
1dataserial
21001
3402
4803
5804
6855
7606
8607
Sheet2


data is in col A
in col B type 1 2 3 4 etc (or enter 1 in B2 and select B2 to B8-click edit fill - series - OK)
B col will be 1 2 3 4 5 etc
sort col A and B according to col.A descending.
C1 enter "rank"
c2 enter 1
c3 formula
=IF(A3=A2,C2,C2+1)
copy C3 down
highlight C2 to c8 edit copy (control+c)
keeping highlighting same edit-
pastespecial-values

sort cols A B C
according to column B ascending

the complete set (result) will be
Excel Workbook
ABC
1dataserialrank
210011
34025
48033
58043
68552
76064
86074
Sheet2
Click to expand...

Hi Venkat,

It is not an option for me to sort column A.

If I could sort, a solution would have been just to enter 1 in B1, then a formula in B2 that says =IF(A2=A1,B1,B1+1) then copy down.
 
Upvote 0
PATSYS said:
Hi all,

I have the following data in A1:A7

100
40
80
80
85
60
60

In the corresponding column B, I want to return the rank of each (descending) i.e.

1
5
3
3
2
4
4

If I use the function rank, what I get is:

1
7
3
3
2
5
5

How can this be done?

Thanks
Click to expand...
Try this...

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Verdana,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=0><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 72px"><COL style="WIDTH: 72px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">Value</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">Rank</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">100</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">40</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">5</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">80</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">3</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">80</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">3</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">85</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">2</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">60</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">60</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">4</TD></TR></TBODY></TABLE>


This formula entered in B2 and copied down:

=SUMPRODUCT((A2 < A$2:A$8)/COUNTIF(A$2:A$8,A$2:A$8))+1
 
Upvote 0
T. Valko said:
Try this...

Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Verdana,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=0><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 72px"><COL style="WIDTH: 72px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">Value</TD><TD style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">Rank</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">100</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">40</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">5</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">80</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">3</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">80</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">3</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">85</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">2</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">60</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">60</TD><TD style="BORDER-TOP-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid; BORDER-LEFT-WIDTH: 1px; BORDER-LEFT-COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: center">4</TD></TR></TBODY></TABLE>


This formula entered in B2 and copied down:

=SUMPRODUCT((A2 < A$2:A$8)/COUNTIF(A$2:A$8,A$2:A$8))+1
Click to expand...

Works great, thanks!
 
Upvote 0
T.Valko

I have tried your given formula but getting error, you can see below... Can you tell me where I am doing wrong?


Excel Workbook
AB
1ValueRank
21001
31001
4954
5992
6983
7954
8954
9954
10964
Rank Function
 
Upvote 0
proficient said:
T.Valko

I have tried your given formula but getting error, you can see below... Can you tell me where I am doing wrong?


Rank Function

AB

<COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: center"]Value[/TD]
[TD="align: center"]Rank[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="bgcolor: #969696, align: center"]95[/TD]
[TD="bgcolor: #969696, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]99[/TD]
[TD="align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]98[/TD]
[TD="align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="bgcolor: #969696, align: center"]96[/TD]
[TD="bgcolor: #969696, align: center"]4[/TD]

</TBODY>

Spreadsheet Formulas
CellFormula
B2=SUMPRODUCT((A2 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B3=SUMPRODUCT((A3 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B4=SUMPRODUCT((A4 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B5=SUMPRODUCT((A5 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B6=SUMPRODUCT((A6 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B7=SUMPRODUCT((A7 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B8=SUMPRODUCT((A8 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B9=SUMPRODUCT((A9 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B10=SUMPRODUCT((A10 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1

<TBODY>
</TBODY>

<TBODY>
</TBODY>


Excel tables to the web >> Excel Jeanie HTML 4
Click to expand...
Hmmm...

That's odd!

If I sort the data in ascending order then that formula returns the correct results.

Try this formula:

=SUMPRODUCT(--(A2 < A$2:A$10),1/COUNTIF(A$2:A$10,A$2:A$10))+1
 
Upvote 0
proficient said:
T.Valko

I have tried your given formula but getting error, you can see below... Can you tell me where I am doing wrong?


Rank Function

AB

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
[TD="bgcolor: #CACACA, align: center"]1[/TD]
[TD="align: center"]Value[/TD]
[TD="align: center"]Rank[/TD]

[TD="bgcolor: #CACACA, align: center"]2[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #CACACA, align: center"]3[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #CACACA, align: center"]4[/TD]
[TD="bgcolor: #969696, align: center"]95[/TD]
[TD="bgcolor: #969696, align: center"]4[/TD]

[TD="bgcolor: #CACACA, align: center"]5[/TD]
[TD="align: center"]99[/TD]
[TD="align: center"]2[/TD]

[TD="bgcolor: #CACACA, align: center"]6[/TD]
[TD="align: center"]98[/TD]
[TD="align: center"]3[/TD]

[TD="bgcolor: #CACACA, align: center"]7[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]4[/TD]

[TD="bgcolor: #CACACA, align: center"]8[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]4[/TD]

[TD="bgcolor: #CACACA, align: center"]9[/TD]
[TD="align: center"]95[/TD]
[TD="align: center"]4[/TD]

[TD="bgcolor: #CACACA, align: center"]10[/TD]
[TD="bgcolor: #969696, align: center"]96[/TD]
[TD="bgcolor: #969696, align: center"]4[/TD]

</tbody>

Spreadsheet Formulas
CellFormula
B2=SUMPRODUCT((A2 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B3=SUMPRODUCT((A3 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B4=SUMPRODUCT((A4 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B5=SUMPRODUCT((A5 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B6=SUMPRODUCT((A6 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B7=SUMPRODUCT((A7 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B8=SUMPRODUCT((A8 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B9=SUMPRODUCT((A9 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1
B10=SUMPRODUCT((A10 < A$2:A$9)/COUNTIF(A$2:A$9,A$2:A$9))+1

<tbody>
</tbody>

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie HTML 4
Click to expand...

All you have to do is to adjust the range in the formula accordingly to your data, ie, A2:A10, not A2:A9

M.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Ranking values (in descending order) with 1 criteria - BUT without skipping numbers
Replies
3
Views
311
Fluff
Fluff
R
  • Question Question
How do I rank a table, formula or macro please?
Replies
5
Views
123
Peter_SSs
Peter_SSs
V
  • Solved
Rank Function
Replies
4
Views
329
vmjan02
V
V
  • Question Question
Rank function
2
Replies
12
Views
391
Fluff
Fluff
D
  • Solved
Exact Match with ISNUMBER(SEARCH)
Replies
2
Views
221
danhenshy23
D

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

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