Excel issue

Ace Modder

Ace Modder

Ace Modder

Soldato
Joined
8 Sep 2003
Posts
23,180
Location
Was 150 yds from OCUK - now 0.5 mile; they moved
Hi guys

I have come across a very odd issue with Excel.

My columns are listed in numbers, not in letters. What the hell? and how can i fix it?

Screenshot%202016-04-05%2010.41.45.png
 
Thanks to you both.

I've just created this on a spreadsheet I'm using...
Code: 
=SUMPRODUCT(--('Sheet1 (2)'!A:A=A2),'Sheet1 (2)'!E:E)

Took me a few mins to do it :)
 
You must log in or register to reply here.
Back
Top Bottom