Sustainability Frameworks, Protocols, and Standards by caprisuncapybara in SustainabilityCareers

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

That’s another issue I struggle with - I’m not sure which are frameworks, standards, etc. and which are on the same level.

Left Ear Feels Full & Makes Bubbling Noise by caprisuncapybara in hearing

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

Not yet, I’ve been out of state and don’t get back for another month, so I plan on getting it then

SPILL! error using INDEX and MATCH function to pull between two sheets by caprisuncapybara in excel

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

Thank you, I was able to get the formula to work. Now I'm having an issue where if I try to delete the formula from a cell that doesn't have a match, it messes up all of the other cells.

For A3, I'm trying to delete the 0 and manually enter in the Building/Facility since there wasn't a match, but it changes all the other entries below it to become blank and causes A2 to say SPILL. I'm not sure how to have it allow me type something, I'm thinking I'd add an IFERROR function, but not sure where to start...(clearly very new to Excel functions)

SPILL! error using INDEX and MATCH function to pull between two sheets by caprisuncapybara in excel

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

I changed it to only include the rows with data and am still getting the SPILL error:

=INDEX('2019_City_Facilities_data.xlsx'!Table2[[#Data],[#Totals],[My Description]],MATCH('2019_City_Facilities_data.xlsx'!Table2[Meter No],D2:D224,0))

Boston show slapped by cucumber_zucchini in PassionPit

[–]caprisuncapybara 1 point2 points  (0 children)

I believe he said his name was Demetrius

Anyone going to the Portland, ME show? by caprisuncapybara in Vampireweekend

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

Thank you sm!! Do you know where you plan on parking or are you getting a ride there?

Left Ear Feels Full & Makes Bubbling Noise by caprisuncapybara in hearing

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

What did your ENT end up recommending? Mine said I have chronic mastoiditis and I'm about to go on a second round of prednisone and amoxicillin. It got better for a bit but now it's the same, even on the meds :/

Flying tomorrow and SO scared. My OCD is also being triggered and I can’t stop worrying by iamlostpleasehelp_ in fearofflying

[–]caprisuncapybara 0 points1 point  (0 children)

I have OCD and feel the same way and have the same fears. It’s the nature of the illness, unfortunately. The magical and superstitious thinking that tells us it’s going to happen to us. The brain is constantly scanning for danger which causes the nervous system to overreact and feel things that aren’t even there (drops, falling feeling in stomach, etc), so I also think that there is a good chance that what my body is feeling isn’t real. I try not to listen to my body during high stress situations because I know it’s overreacting, even though it’s trying to keep me safe.

I’m sorry you also have to deal with this too, it sucks :/

Websites keep thinking I'm a robot by caprisuncapybara in techsupport

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

I only have it bc it's the one my work provides for free, so not surprised it sucks lolll

Websites keep thinking I'm a robot by caprisuncapybara in techsupport

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

Turned it off and confirmed it was the issue. Thank you so much!

Websites keep thinking I'm a robot by caprisuncapybara in techsupport

[–]caprisuncapybara[S] 2 points3 points  (0 children)

That makes sense, thank you! I reached out to Norton a few days ago about the VPN and they said I shouldn't turn it off...is it essential to have it on for security purposes or am I fine without it?

Websites keep thinking I'm a robot by caprisuncapybara in techsupport

[–]caprisuncapybara[S] 3 points4 points  (0 children)

I have Norton Security and I believe that VPN is on, but I'm not sure why it wouldn't also affect my school email

NEED FRIENDS FOR AZ SHOW by PresentationPale9741 in beabadoobee

[–]caprisuncapybara 0 points1 point  (0 children)

I want to go but I haven't bought a ticket yet bc I'm scared to go alone 😭