Ages in form yy/mm manipulation error

[Novice_user]

Hi All,

I am very new to excel so bear with me please...!

So, I have a set of numbers in two columns

[TABLE="class: cms_table, width: 256"]
<tbody>[TR]
[TD="class: cms_table_xl66, width: 64"][/TD]
[TD="class: cms_table_xl66, width: 64"]A[/TD]
[TD="class: cms_table_xl66, width: 64"]B[/TD]
[TD="class: cms_table_xl66, width: 64"]C[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]1[/TD]
[TD="class: cms_table_xl69"]a[/TD]
[TD="class: cms_table_xl65, width: 64"]13/3[/TD]
[TD="class: cms_table_xl69"]14/9[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]2[/TD]
[TD="class: cms_table_xl69"]b[/TD]
[TD="class: cms_table_xl65, width: 64"]15/6[/TD]
[TD="class: cms_table_xl69"]16/3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]3[/TD]
[TD="class: cms_table_xl69"]c[/TD]
[TD="class: cms_table_xl65, width: 64"]10/3[/TD]
[TD="class: cms_table_xl69"]12/3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]4[/TD]
[TD="class: cms_table_xl69"]d[/TD]
[TD="class: cms_table_xl65, width: 64"]14/6[/TD]
[TD="class: cms_table_xl69"]14/9[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]5[/TD]
[TD="class: cms_table_xl69"]e[/TD]
[TD="class: cms_table_xl65, width: 64"]8/10[/TD]
[TD="class: cms_table_xl69"]6/5[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]6[/TD]
[TD="class: cms_table_xl69"]f[/TD]
[TD="class: cms_table_xl65, width: 64"]10/11[/TD]
[TD="class: cms_table_xl69"]12/3[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]7[/TD]
[TD="class: cms_table_xl69"]g[/TD]
[TD="class: cms_table_xl68, width: 64"]12/0[/TD]
[TD="class: cms_table_xl69"]8/2[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]8[/TD]
[TD="class: cms_table_xl69"]h[/TD]
[TD="class: cms_table_xl65, width: 64"]12/9[/TD]
[TD="class: cms_table_xl69"]14/0[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl66"]9[/TD]
[TD="class: cms_table_xl69"]i[/TD]
[TD="class: cms_table_xl65, width: 64"]9/7[/TD]
[TD="class: cms_table_xl69"]10/7[/TD]
[/TR]
</tbody>[/TABLE]


In column D I want to produce the following results - if the numbers in column C are greater than B then display the number in C, otherwise display column B

I tried using the IF formula =IF(c1>b1,c1,b1)

which was great & worked but when it got to name g the result returned was 8/2 which isn't right.

I looked further down and the results remain inconsistent throughout.

Help please!!

 

[jondavis1987]

Re: Ages in form yy/mm manipulation error - HELP PLEASE

Yeah I thought it was dates as well at first. My suggestion would be to have the source change their format on how they're sending it to you. # ??/12 is the only format I could figure out that reads about what you're already receiving and allows the formula to work.

 

[jondavis1987]

Re: Ages in form yy/mm manipulation error - HELP PLEASE

If you can't change the way they're sending it, you might have to manually reenter it.

 

[jondavis1987]

Re: Ages in form yy/mm manipulation error - HELP PLEASE

I don't really know macros but I imagine you can make a macro to automatically take the information and produce it in a different format like the # ??/12. Somebody here might be able to help with that

 

[Novice_user]

Re: Ages in form yy/mm manipulation error - HELP PLEASE

Thanks. I'll delve further to see if I can come up with something.

 

[Tetra201]

Re: Ages in form yy/mm manipulation error - HELP PLEASE

Try this formula:

=IF(VALUE(SUBSTITUTE(C1,"/"," ")&"/12")>VALUE(SUBSTITUTE(B1,"/"," ")&"/12"),C1,B1)