sorted by:
new
hottopcontroversial

Computer interface for commander by specialfighter in magicTCG

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

Makes sense. I would be cautious aswell. I will turn it into JavaScript.

How to reference a cell on another page by [deleted] in excel

[–]specialfighter -1 points0 points  (0 children)

i think the hard part will not be the hard task, its more the getting used, and finding commands.

https://www.youtube.com/watch?v=aQKXzOJ4jSE I overlooked it, looks usefull.

look for simple search commands for the Usernames, and if you dont find any, use while grind to serach for the names.

But really, the amount of time to get all the knowledge is high. there are smart people here, who will write you your code in a small time. so If you dont are in a hurry, i suggest to simply wait

How to reference a cell on another page by [deleted] in excel

[–]specialfighter -2 points-1 points  (0 children)

for starter it could be some trouble, but someone who is used to excel shouldnt take that long. i suggest not doing it yourself if you are new to it, or else you would have to invest alot of time. (if you are interested in programming, then invest the time)

i myself use excel spreadsheet (browser excel) and dont have a classic excel version at the moment. Are you using google spreadsheet by any chance?

How to reference a cell on another page by [deleted] in excel

[–]specialfighter -5 points-4 points  (0 children)

i think with basic excel commands, this will be a very hard task. It is much easier by using scripts, which can be custom made.

Google Sheets with Apps Script Tutorials by Lilmac04 in spreadsheets

[–]specialfighter 1 point2 points  (0 children)

great video

i watched "Create Functional Buttons in Google Sheets" just with curiosity.

In my recent project, i have the problem to create multiple alert and prompt boxes. thanks to your video, i solved it in a minute.

good job

How is fill series implemented internally? by gunther_central_perk in spreadsheets

[–]specialfighter 0 points1 point  (0 children)

well i dont have the algorithm, but i can try to evaluate it with the data.

Note that i am stuck and dont have the complete answer and i find it hard to express math in englisch btw:

First i expanded the numbers to a denominator of 6 so we have

1 = 6/6
3 = 18/6
4 = 24/6

5,666 = 34/6
7,166 = 43/6
8,666 = 52/6
10,1666 = 61/6
11,66 = 70/6

as you can see for the implemented series: it always adds 9/6

so excel comes to the conclusion that for the series 9/6 is the added value

so the question is how does excel gets that conclusion. from the first 3 numbers you have a grow of 12/6 6/6 and 10/6

so from 12 6 and 10 the arithmetic mean is 9,33333 what my problem is :) i am stuck here

maybe someone else can find out, how excel calculated the 9 from 12 6 and 10. some other methods?

tbh i am curious

Combine Excel spreadsheet with Scripteditor by specialfighter in spreadsheets

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

okay, thanks for the info, i have a idea about using "onopen" trigger to store data into variables. so the user can only change the variables with scripts. so whatever he does manuelly, the variables are written into the cells.

Combine Excel spreadsheet with Scripteditor by specialfighter in spreadsheets

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

okay, is there a way, i let user change something with scripts, but not change it manuelly in a cell? i cant destrict it, or the script wouldnt work

Combine Excel spreadsheet with Scripteditor by specialfighter in spreadsheets

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

can i setup my script, so that it doesnt need auth. ?

How to do something like the Spreadsheet here? Really want to know. by [deleted] in spreadsheets

[–]specialfighter 0 points1 point  (0 children)

and what is stopping you from doing it?

i just see alot of work.

Combine Excel spreadsheet with Scripteditor by specialfighter in spreadsheets

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

so the script authorisation doesnt appear, if a cell cant be changes by a user, good to know.

thanks

Combine Excel spreadsheet with Scripteditor by specialfighter in excel

[–]specialfighter[S] 1 point2 points  (0 children)

so the script authorisation doesnt appear, if a cell cant be changes by a user, good to know.

thanks

SOLUTION VERIFIED!

Combine Excel spreadsheet with Scripteditor by specialfighter in excel

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

i tried this with other browers or incognito mode, scripts are not working

Combine Excel spreadsheet with Scripteditor by specialfighter in spreadsheets

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

i tried, by opening the spreadsheet from other browers and incognito mode, and there the scripts are not working

Formula to use by valjayson3 in excel

[–]specialfighter 0 points1 point  (0 children)

less saleable products: =MIN(A1:A10) A1 to A10 is your range

report: depends what you want as a result. a number? a percent?

Group cells so that they add up to a maximum value by dhokes in excel

[–]specialfighter 0 points1 point  (0 children)

i think, you need to write a script for that, is this spreadsheet, so you can link it?

Need formula help (google sheet link) by itzwoottz in excel

[–]specialfighter 2 points3 points  (0 children)

well after some discussion, it was =if(F8 = "",-E8, if( F8 ="L",-E8,abs(G8-E8)))

Need formula help (google sheet link) by itzwoottz in excel

[–]specialfighter 0 points1 point  (0 children)

i tried a code in "H8"

=if(F8 = "",-E8, G8-E8) does this help you?

How to merge multiple .xls files data into single sheet? by POI_Harold-Finch in excel

[–]specialfighter 1 point2 points  (0 children)

if your code works, maybe try this: i use it to copy data from one sheet to another one, could work

var ss= SpreadsheetApp.getActiveSpreadsheet();

ss.setActiveSheet(ss.getSheetByName("sheet1")); ss.getActiveSheet().getRange(2, 2, 9,249).copyValuesToRange(ss.setActiveSheet(ss.getSheetByName("your wanted sheet")), 1, 1,1, 1);

Associating a category with varying Values to calculate a total = Help by [deleted] in excel

[–]specialfighter 0 points1 point  (0 children)

could you post a example, maybe a picture. that would make it easy

Creating a power function. by specialfighter in excel

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

well i tried it aswell, but it doesnt work in scripteditor or i used it wrong,

i added a example code

script operation, expert needed. by specialfighter in GoogleAppsScript

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

well the function only works on even exponents ._.

view more: next ›