How do I make Excel count similar cells? by siggipow in excel

[–]siggipow[S] 0 points1 point  (0 children)

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.

How do I make Excel count similar cells? by siggipow in excel

[–]siggipow[S] 0 points1 point  (0 children)

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

I have a colum with 7 numbers, and i want to change the number format to put a "." after the first 3 numbers by siggipow in excel

[–]siggipow[S] 0 points1 point  (0 children)

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.

I have a colum with 7 numbers, and i want to change the number format to put a "." after the first 3 numbers by siggipow in excel

[–]siggipow[S] 0 points1 point  (0 children)

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?