CountIF Function Help

[lwilt]

I'm having trouble with the countif function. In my spreadsheet in column C starting cell C2 I have text numbers. If the cell starts with an 8 I want to put a leading 0 in front of it otherwise I want to keep the cell the way it is.


Also, if possible for the cells with just a 0 in them can I turn have it write those as null cells where the function is running?

thank you

 

[lwilt]

Also posted at:

CountIF Function Help
CountIF function Help | Chandoo.org Excel Forums - Become Awesome in Excel

 

[AlKey]

Can you give us few examples of your data and what would you like it to look like?

 

[lwilt]

Joe4 - I did post links...they are above in the 2nd post. The site is running a bit slow this morning for me and it took me a few mins to post them after the orig post loaded since I needed all links for each site.

Alkey...the links to the other site I upload a sample doc. I 'll paste it below for you to see.

Key	REF POINT		FORMULA		Look like
	11122	11122			11122
	65644444	65644444			65644444
	811111	811111			0811111
	2121212	2121212			2121212
		0
	11111	11111			11111
	13111	13111			13111
	15166	15166			15166
	1211111	1211111			1211111
	447777	447777			447777
	4545454	4545454			4545454
	29999999	29999999			29999999
		0
	899666	899666			0899666
	2222221	2222221			2222221
	1111117	1111117			1111117

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[lwilt]

Solved!!!

here was the solution
=IF(OR(C2={"","0"}),"",IF(LEFT(C2,1)="8","0"&C2,""&C2))

 

[AlKey]

Try this

[B]=IF(LEFT(C2)="8",0&C2,C2)&""[/B]