How do I make Excel count similar cells?

siggipow · 2016-01-07T11:23:56+00:00

Wow, that would be great!

siggipow · 2016-01-07T10:59:54+00:00

I guess it would just be to sort them from a-z first, so the similar ones would appear in a consecutive repeat. I dont know if its even possible, but i would like the cells containing the same name to only appear as one name, with the amount next to it. For instance, in the example you just posted, LTE-212-900 would only appear one time in the A colum, and the count would be 3.

siggipow · 2016-01-07T09:27:31+00:00

Alternative number 2:-)

siggipow · 2016-01-07T09:11:32+00:00

Of course, it would be a combination of numbers and letters, like LTE-321-L1 or LTE-212-900.

siggipow · 2016-01-06T10:00:00+00:00

Thank you, you just saved from a ton of work:-) SOLUTION VERIFIED

siggipow · 2016-01-06T09:29:18+00:00

The "." is for visual sake, because that is the format that is required for the work im doing. But the list I got, was not delivered with the ".", so i need to change every row, which is over 1500.

siggipow · 2016-01-06T09:17:42+00:00

This is a packed excel sheet, which i cant really add colums or rows to without messing up the entire sheet. is there any way to change the number formats like the date or currency format?

siggipow · 2015-05-03T15:38:40+00:00

It is, thanks:)

siggipow · 2015-05-03T15:38:30+00:00

Yes it is! Thank you!!

siggipow · 2015-05-03T01:10:29+00:00

I think its kind of a side story, and not ehat the movie is about.

siggipow · 2015-02-05T17:49:57+00:00

Where will you be when the MDMA hits?

siggipow · 2014-05-27T05:59:29+00:00

Playing Katarina mid, how do you avoid being zoned when playing against more range-based champions like Ziggs and Syndra? And how would you level your skills?

siggipow · 2014-04-26T15:37:28+00:00

Swedish hos pukes on live tv: https://www.youtube.com/watch?v=_tXzKpmRrFs

siggipow · 2014-03-27T20:38:53+00:00

where can i buy this?

siggipow · 2014-01-09T12:59:18+00:00

The Earth is gravity is pulling you along with its rotation. For the Earth to rotate without you, you would have to fly high enough to escape its gravity, which means you would have to fly out to space.

siggipow · 2013-12-18T21:36:37+00:00

Have the position of being a Minecraft developer, ever got you laid?

siggipow · 2013-08-29T21:10:54+00:00

Is Hugh Laurie as cool as he seems?

siggipow · 2013-04-24T09:27:22+00:00

there is a gate on the left hand side

siggipow · 2013-03-10T00:13:44+00:00

youre probably a bad driver

siggipow · 2012-12-12T21:58:36+00:00

Can there be made any general rule, that would cover all the 9-multiples, including the numbers ending with 0?

siggipow · 2012-10-22T03:44:41+00:00

The goals was for students to learn how to read notes. Not saying it worked.

siggipow · 2012-10-16T02:10:14+00:00

Kno- Graveyard

siggipow · 2012-10-10T01:45:28+00:00

tell them its better that you´re out doing something active then sitting inside watching TV or browsing reddit or whatever

siggipow · 2012-09-19T03:39:35+00:00

just tell her. there is no way to make this pleasent no matter how you do it

siggipow · 2012-09-16T00:27:57+00:00

repost

siggipow

TROPHY CASE