+- Pokemon Uranium (https://pokemonuranium.co/forum)
+-- Forum: Pokemon Uranium (https://pokemonuranium.co/forum/forumdisplay.php?fid=1)
+--- Forum: General Chat (https://pokemonuranium.co/forum/forumdisplay.php?fid=3)
+--- Thread: Type Blancer Tool (/showthread.php?tid=43)
Pages:
1
2
RE: Type Blancer Tool - miau - 10-02-2016
(10-02-2016, 10:57 PM)TwistedLogic Wrote:(10-02-2016, 10:08 PM)miau Wrote: spreedsheet i pick a type and get n/a all overThe .xls or the .ods? I haven't been able to test the .xls one because I don't actually have Excel, unfortunately.
.xls
RE: Type Blancer Tool - TwistedLogic - 10-03-2016
(10-02-2016, 11:59 PM)miau Wrote: .xls
Alright, I think I found the issue, but I can't test it in OpenOffice. I've uploaded the new file; could you please take a look for me?
RE: Type Blancer Tool - miau - 10-03-2016
(10-03-2016, 12:07 AM)TwistedLogic Wrote:(10-02-2016, 11:59 PM)miau Wrote: .xls
Alright, I think I found the issue, but I can't test it in OpenOffice. I've uploaded the new file; could you please take a look for me?
still not working
RE: Type Blancer Tool - TwistedLogic - 10-03-2016
(10-03-2016, 01:23 AM)miau Wrote: still not workingFor some reason OpenOffice is deleting my formula when I save it.
The formula should be:
=INDEX(Sheet2!$C$2:$T$20,MATCH($A3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))*INDEX(Sheet2!$C$2:$T$20,MATCH($B3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))
In case you don't have much experience with Excel, paste that into C3, then drag it to T3, then drag all of that down to row 8.
RE: Type Blancer Tool - miau - 10-03-2016
(10-03-2016, 01:37 AM)TwistedLogic Wrote:(10-03-2016, 01:23 AM)miau Wrote: still not workingFor some reason OpenOffice is deleting my formula when I save it.
The formula should be:
=INDEX(Sheet2!$C$2:$T$20,MATCH($A3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))*INDEX(Sheet2!$C$2:$T$20,MATCH($B3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))
In case you don't have much experience with Excel, paste that into C3, then drag it to T3, then drag all of that down to row 8.
thank you
RE: Type Blancer Tool - TwistedLogic - 10-03-2016
No problem. I'll go ahead and put a notice in the OP.