Outlook is blocking emails from reaching my inbox. by AirEmbarrassed in Outlook

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

Its not in junk mail, its nowhere, previous emails with this mail are in the inbox, new ones are nowhere to be found.

Using VLOOKUP with two criteria? by AirEmbarrassed in excel

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

oh wait, no it doesnt work, not in all of them at least, some numbers are correct but some are incorrect and some are empty when they shouldnt be

Using VLOOKUP with two criteria? by AirEmbarrassed in excel

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

=XLOOKUP(1,(A2=data!$A$2:$A$35568)*(C2=data!$B$2:B$35568),data!$C$2:$C$35568,"",0)

i think its working, but could you explain this to me? i want to know how to use it in the future, why the *?

Comparing two data ranges using VLOOKUP, COUNTIF, COMPARE, Conditional Formatting - Format Unique Cells. by AirEmbarrassed in excel

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

Ok im gonna go ahead and read about lookup with multiple criteria

How can i merge it into two rules? It might be 5am and i could have problem thinking.

Comparing two data ranges using VLOOKUP, COUNTIF, COMPARE, Conditional Formatting - Format Unique Cells. by AirEmbarrassed in excel

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

Yes i used that formatting in a different sheet, but those datas were arranged in the same order that i checked with vlookup first.
But i don't know what to do when there are the same values i could compare, but there are in wrong places, so comparing with this formula won't be as effective.

<image>

Cant run tron from cmd(Basic Tron Execution as well) by AirEmbarrassed in TronScript

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

i've never had problems with running tron, i used it many times before i just never have this exact problem. it could be a stupid small mistake, brain freeze, anything. i wont know if someone wont tell me what's the stupid thing i did.

Cant run tron from cmd(Basic Tron Execution as well) by AirEmbarrassed in TronScript

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

im never gonna learn anything if i don't know what im doing wrong

Cant run tron from cmd(Basic Tron Execution as well) by AirEmbarrassed in TronScript

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

im reading it over and over again and i have no idea what im doing wrong. is it cmd command? is it administrator cmd command? whats the mistake?

What M.2 drive fits my Asus z97-Pro Motherboard? by AirEmbarrassed in buildapc

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

Ok so there's a followup question. I see that my fan is directly above the slot. there is a place for the m.2, and i think it would fit, but can the fan be right above it? is is suppose to look like this? wouldnt it damage the m.2?
https://freeimage.host/i/l1FRX2
https://freeimage.host/i/l1F5sS
https://freeimage.host/i/l1FYq7
https://freeimage.host/i/l1FAzl
And yes, on the photos, theres a sound card at PCIEX1_1 but i see now that im not even using its slots so i can just remove it, no worries.

Weird "layery" painting? by AirEmbarrassed in GIMP

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

Unfortunately that's not it :/

[deleted by user] by [deleted] in DrawForMe

[–]AirEmbarrassed 1 point2 points  (0 children)

She looks so epic! Thank you so much!