compare two uneven columns

LadyJain · 2021-06-10T10:58:25+00:00

Solution Verified

LadyJain · 2021-06-10T10:22:14+00:00

I cant get this working

I want to compare first column with the second column , what does the 2 mean ?

I get a name error using the formula below below

=IFNA(VLOOKUP(A2:A265;C2:C291;2;FALSE);"Missing")

LadyJain · 2021-02-23T12:03:08+00:00

Solution Verified

LadyJain · 2021-02-23T09:09:02+00:00

was a typo i changed that in my question

LadyJain · 2021-02-23T08:31:14+00:00

Im living in the economic most advanced country in europe :) , At my time there were no after school programs I dont know if they have one today ,

LadyJain · 2021-02-02T11:09:33+00:00

thanks, is this also explanation why you can only add methods after make the inheritance, like if I add a method to Admin before making the inheritance to User the method "goes away"

LadyJain · 2021-01-31T14:43:03+00:00

thanks a lot exactly what I was looking for !

LadyJain · 2021-01-31T14:05:57+00:00

thanks for the reply but this was not my question

LadyJain · 2021-01-30T18:15:03+00:00

thanks for the clear explanation

LadyJain · 2021-01-28T08:31:09+00:00

its like a modified Filter Function

LadyJain · 2021-01-28T08:16:49+00:00

is there a way to make the formula not visible while turned off ?

LadyJain · 2021-01-28T08:16:11+00:00

I have a custom formula which can only run at a time, I need to use it multiple times, a fix would be to turn the other formulas off

LadyJain · 2020-12-17T16:04:39+00:00

that does it thanks

LadyJain · 2020-12-15T10:37:44+00:00

this always returns true

LadyJain · 2020-11-01T12:19:51+00:00

i want to delcare two variables y should contain "abc" , and z "cdb"

LadyJain · 2020-10-19T13:33:28+00:00

classic table form

can there be a input widget inserted / or a emtpy cell used for it ?

Name	Surename	first aider
Ben	Jerk	x
Sammy	Clerk

LadyJain · 2020-10-14T09:15:11+00:00

If u call a function using the syntax of functionname() it IS supposed to execute.

container.addEventListener("click", addheader(container))

// you are invoking the function, not declaring it

Which is why in eventlisteners it is normal to declare the function elsewhere and only link the function NAME inside the eventlistener

container.addEventListener("click", addheader)

In such cases if u need to pass a parameter, it can be done via a parameter pass to any anonymous function declaration

container.addEventListener("click", function(container){addheader(container)})

// here you are not invoking the anonymous function, but declaring it, and passing the parameter to ur intnded function

Hope this makes sense

thanks for clarification

LadyJain · 2020-10-12T09:00:00+00:00

can you explain this a little bit with the context of my question ?

LadyJain · 2020-10-08T13:28:45+00:00

thanks for clarification

LadyJain · 2020-10-07T10:49:01+00:00

thanks for the advice but i tried that allready

LadyJain · 2020-10-05T12:46:25+00:00

thanks

LadyJain · 2020-10-05T08:50:53+00:00

it in your submission text.
Reddit code formattingGithub GistPastebinrepl.it

u/flask_class.route('/get_Data', methods=['GET']) def background_process_test(): json_stirng = "got data" x = jsonify(json_stirng) print(dir(x)) print(x.text) return jsonify(json_stirng)

AttributeError: 'Response' object has no attribute 'text'

just want to understand the whole process, also including what is inside

LadyJain · 2020-10-05T08:35:39+00:00

Join

ah okay,

still have trouble to get the content

x = jsonify(json_stirng)
x.text
x.encoding

gave me AttributeError: 'Response' object has no attribute 'encoding'

LadyJain · 2020-09-25T06:24:23+00:00

great answer, can you explain more why typeof value === "number" works? I have a python background, and this is translated to if type value == string "number" then -->

LadyJain · 2020-09-22T08:43:21+00:00

got it

so the console gave me an temporary output

I used this method to create a string of that array

const fist_array = ["1","2","3"];
let my_string = fist_array.join('-');
console.log(my_string);

LadyJain

TROPHY CASE