|
Type Blancer Tool
|
10-03-2016, 01:37 AM
(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. |
|
« Next Oldest | Next Newest »
|
| Messages In This Thread |
|
Type Blancer Tool - by TwistedLogic - 09-17-2016, 01:00 PM
RE: Type Blancer Tool - by Cataclyptic - 09-28-2016, 07:08 PM
RE: Type Blancer Tool - by TwistedLogic - 09-29-2016, 01:34 AM
RE: Type Blancer Tool - by Cataclyptic - 09-29-2016, 10:18 PM
RE: Type Blancer Tool - by TwistedLogic - 10-02-2016, 03:16 PM
RE: Type Blancer Tool - by Cataclyptic - 10-02-2016, 04:47 PM
RE: Type Blancer Tool - by miau - 10-02-2016, 04:57 PM
RE: Type Blancer Tool - by TwistedLogic - 10-02-2016, 07:08 PM
RE: Type Blancer Tool - by miau - 10-02-2016, 10:08 PM
RE: Type Blancer Tool - by TwistedLogic - 10-02-2016, 10:57 PM
RE: Type Blancer Tool - by miau - 10-02-2016, 11:59 PM
RE: Type Blancer Tool - by TwistedLogic - 10-03-2016, 12:07 AM
RE: Type Blancer Tool - by miau - 10-03-2016, 01:23 AM
RE: Type Blancer Tool - by TwistedLogic - 10-03-2016, 01:37 AM
RE: Type Blancer Tool - by miau - 10-03-2016, 11:00 AM
RE: Type Blancer Tool - by TwistedLogic - 10-03-2016, 12:52 PM
|
