Rounding off decimals

B

baidya91

Board Regular
Joined
Jun 1, 2016
Messages
147
How to round off 19 years 2 months to 19 years, 19 years 3 months 20 days to 19 years 3 months, 19 years 6 months 6 days to 19 years 6 moths and 19 years 9 days 20 days to 20 years in excel?
 
Last edited:
Sort by date Sort by votes

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
baidya91 said:
Thanks again
Click to expand...

[TABLE="width: 173"]
<tbody>[TR]
[TD="class: xl65, width: 173"]26 years 9 months 30 days cannot be turned into 27 years 0 months. It is turned into 27 years () months which cannot serve my purpose. () is to be filled in by zero (0). Please see to that.[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Don't know what you mean, see last row of my sample below, it's working per your previous descriptions.
If you need the results presented a different way, please show samples, before and after.


Book1
AB
119 years19 Years
219 years 15 days19 Years
319 years 0 months 15 days19 Years
419 years 2 months19 Years
519 years 3 months19 Years 6 months
619 years 3 months 20 days19 Years 6 months
719 years 6 months 6 days19 Years 6 months
819 years 7 months 1days19 Years 6 months
919 years 9 months 20 days20 Years
1019 years 11 months 20 days20 Years
1126 years 9 months 30 days27 Years
Sheet422
Cell Formulas
RangeFormula
B1=LEFT(A1,FIND(" ",A1)-1)+IF(ISNUMBER(SEARCH("month",A1)),IF(MID(A1&" 0",SEARCH("years",A1)+6,2)+0>=9,1,0),0)&" Years"&IFERROR(IF(ISNUMBER(SEARCH("month",A1)),SUBSTITUTE(" "&CHOOSE(MID(A1,SEARCH("years",A1)+6,2)+0,,,6,6,6,6,6,6,,,,)&" months"," months",""),""),"")
 
Upvote 0
jtakw said:
Don't know what you mean, see last row of my sample below, it's working per your previous descriptions.If you need the results presented a different way, please show samples, before and after.
AB
19 years19 Years
19 years 15 days19 Years
19 years 0 months 15 days19 Years
19 years 2 months19 Years
19 years 3 months19 Years 6 months
19 years 3 months 20 days19 Years 6 months
19 years 6 months 6 days19 Years 6 months
19 years 7 months 1days19 Years 6 months
19 years 9 months 20 days20 Years
19 years 11 months 20 days20 Years
26 years 9 months 30 days27 Years

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

</tbody>
Sheet422​
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B1[/TH]
[TD="align: left"]=LEFT(A1,FIND(" ",A1)-1)+IF(ISNUMBER(SEARCH("month",A1)),IF(MID(A1&" 0",SEARCH("years",A1)+6,2)+0>=9,1,0),0)&" Years"&IFERROR(IF(ISNUMBER(SEARCH("month",A1)),SUBSTITUTE(" "&CHOOSE(MID(A1,SEARCH("years",A1)+6,2)+0,,,6,6,6,6,6,6,,,,)&" months"," months",""),""),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...
I need the result in the following manner:
19 years19 Years 0 months
19 years 15 days19 Years 0 months
19 years 0 months 15 days19 Years 0 months
19 years 2 months19 Years 0 months
19 years 3 months19 Years 6 months
19 years 3 months 20 days19 Years 6 months
19 years 6 months 6 days19 Years 6 months
19 years 7 months 1days19 Years 6 months
19 years 9 months 20 days20 Years 0 months
19 years 11 months 20 days20 Years 0 months
26 years 9 months 30 days27 Years 0 months

<tbody>
[TH="align: center"][/TH]
[TH="align: center"]A[/TH]
[TH="align: center"]B[/TH]

[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

</tbody>
 
Last edited:
Upvote 0
jtakw said:
Don't know what you mean, see last row of my sample below, it's working per your previous descriptions.
If you need the results presented a different way, please show samples, before and after.

AB
19 years19 Years
19 years 15 days19 Years
19 years 0 months 15 days19 Years
19 years 2 months19 Years
19 years 3 months19 Years 6 months
19 years 3 months 20 days19 Years 6 months
19 years 6 months 6 days19 Years 6 months
19 years 7 months 1days19 Years 6 months
19 years 9 months 20 days20 Years
19 years 11 months 20 days20 Years
26 years 9 months 30 days27 Years

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

</tbody>
Sheet422​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B1[/TH]
[TD="align: left"]=LEFT(A1,FIND(" ",A1)-1)+IF(ISNUMBER(SEARCH("month",A1)),IF(MID(A1&" 0",SEARCH("years",A1)+6,2)+0>=9,1,0),0)&" Years"&IFERROR(IF(ISNUMBER(SEARCH("month",A1)),SUBSTITUTE(" "&CHOOSE(MID(A1,SEARCH("years",A1)+6,2)+0,,,6,6,6,6,6,6,,,,)&" months"," months",""),""),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

I need the result in the following manner:

19 years19 Years 0 months
19 years 15 days19 Years 0 months
19 years 0 months 15 days19 Years 0 months
19 years 2 months19 Years 0 months
19 years 3 months19 Years 6 months
19 years 3 months 20 days19 Years 6 months
19 years 6 months 6 days19 Years 6 months
19 years 7 months 1days19 Years 6 months
19 years 9 months 20 days20 Years 0 months
19 years 11 months 20 days20 Years 0 months
26 years 9 months 30 days27 Years 0 months

<tbody>
[TH="align: center"][/TH]
[TH="align: center"]A[/TH]
[TH="align: center"]B[/TH]

[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

</tbody>
 
Last edited:
Upvote 0
Copy formula As-Is, No "double spaces" for " months"


Book1
AB
119 years19 Years 0 months
219 years 15 days20 Years 0 months
319 years 0 months 15 days19 Years 0 months
419 years 2 months19 Years 0 months
519 years 3 months19 Years 6 months
619 years 3 months 20 days19 Years 6 months
719 years 6 months 6 days19 Years 6 months
819 years 7 months 1days19 Years 6 months
919 years 9 months 20 days20 Years 0 months
1019 years 11 months 20 days20 Years 0 months
1126 years 9 months 30 days27 Years 0 months
Sheet422
Cell Formulas
RangeFormula
B1=LEFT(A1,FIND(" ",A1)-1)+IF(MID(A1&" 0",SEARCH("years",A1)+6,2)+0>=9,1,0)&" Years "&IFERROR(CHOOSE(MID(A1&" 0",SEARCH("years",A1)+6,2)+0,0,0,6,6,6,6,6,6,0,0,0),0)&" months"
 
Upvote 0
oldbrewer said:
I would have thought a look up table would be a better way to go.....
Click to expand...

OP's requirements have changed along the way, so I was just tweaking my original formula to suit.

A LOOKUP version would be something like below (just a hair shorter):


Book1
AB
119 years19 Years 0 months
219 years 0 months 15 days19 Years 0 months
319 years 2 months19 Years 0 months
419 years 3 months19 Years 6 months
519 years 3 months 20 days19 Years 6 months
619 years 6 months 6 days19 Years 6 months
719 years 7 months 1days19 Years 6 months
819 years 9 months 20 days20 Years 0 months
919 years 11 months 20 days20 Years 0 months
1026 years 9 months 30 days27 Years 0 months
Sheet422
Cell Formulas
RangeFormula
B1=LEFT(A1,FIND(" ",A1)-1)+IF(MID(A1&" 0",SEARCH("years",A1)+6,2)+0>=9,1,0)&" Years "&LOOKUP(MID(A1&" 0",SEARCH("years",A1)+6,2)+0,{0,3,9},{0,6,0})&" months"
 
Upvote 0
[TABLE="width: 1156"]
<colgroup><col span="6"><col><col><col><col><col span="2"><col><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]col k[/TD]
[TD]col L[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]start date[/TD]
[TD]servdays[/TD]
[TD]intmonths[/TD]
[TD]intmonths-3[/TD]
[TD]intyears[/TD]
[TD]MONTHS[/TD]
[TD]SERVICE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/11/2015[/TD]
[TD="align: right"]1153[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD]2 years 9 months[/TD]
[TD][/TD]
[TD]mytable[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/08/2015[/TD]
[TD="align: right"]1242[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD]3 years 0 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/05/2015[/TD]
[TD="align: right"]1331[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]3 years 3 months[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/02/2015[/TD]
[TD="align: right"]1420[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[TD]3 years 6 months[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10/11/2014[/TD]
[TD="align: right"]1509[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD]3 years 9 months[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13/08/2014[/TD]
[TD="align: right"]1598[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]4 years 0 months[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16/05/2014[/TD]
[TD="align: right"]1687[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD]4 years 3 months[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16/02/2014[/TD]
[TD="align: right"]1776[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD]4 years 6 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]19/11/2013[/TD]
[TD="align: right"]1865[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD]4 years 9 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]22/08/2013[/TD]
[TD="align: right"]1954[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD]5 years 0 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/05/2013[/TD]
[TD="align: right"]2043[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]5 years 3 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/02/2013[/TD]
[TD="align: right"]2132[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD]5 years 6 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]28/11/2012[/TD]
[TD="align: right"]2221[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD]5 years 9 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]31/08/2012[/TD]
[TD="align: right"]2310[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD]6 years 0 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]assumptions[/TD]
[TD]a month is[/TD]
[TD="align: right"]30.4375[/TD]
[TD]days[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]M5 (2 years 9 months)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]=K5&" years " &VLOOKUP(L5,mytable,2)&" months"[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Current financial year and Pior financial year
Replies
3
Views
94
Sarah7828
S
D
  • Question Question
20 team round robin golf league schedule - 3 courses
Replies
0
Views
372
dep1969
D
M
  • Question Question
Calculate Date + 2 years starting 1st Jan
Replies
5
Views
75
FormR
FormR
B
  • Question Question
Chart help - rainfall data
Replies
2
Views
261
JV0710
J
S
  • Solved
Conditional Formatting for when the month/year date for the same ID on two worksheets doesn't match
Replies
7
Views
125
etaf
etaf

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,623
Latest member
Techenthusiast

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