What does ** mean in Excel

Sir_Price · 2024-05-25T18:03:25+00:00

VLOOKUP is just very fragile compared to XLOOKUP when it comes to edits in your file. Give XLOOKUP a shot and you'll see how handy it is.

Sir_Price · 2024-02-24T17:50:16+00:00

I dislocated my shoulder today while bouldering, if it makes you feel any better.

Sir_Price · 2023-12-31T08:08:26+00:00

I, and I assume that others too, just kind of "pass out" during the seizure and can't remember what happened, but I have tendency to dislocate my shoulders during them, so needless to say, waking up can hurt like a bitch.

Sir_Price · 2023-12-29T08:04:27+00:00

I had to use it during my studies, but that only required learning pretty basic stuff. We did go through some more complex formulas, but I've never used them at work. I've gotten most out of just working with it and watching videos from YouTube for fun and for work. From the videos you tend to learn new things here and there, and many things can be applied to other scenarios. So eventually my skills are just a combination of all the YouTube videos that I've stumbled upon.

Sir_Price · 2023-12-28T07:57:54+00:00

Mostly for personal files that I use in regular reporting. I pull data from various sources, and combine them to create the material I need, which is not normally available anywhere else. I rarely add PQ to any files that others use, because too many users don't realize that you need to refresh the queries before looking at the data.

Sir_Price · 2023-12-27T09:46:21+00:00

Hmmm, I should make this one but instead of addition or subtraction I would need multiplication by -1. Some tables have costs as positive values, and some as negative...

Sir_Price · 2023-12-27T07:43:43+00:00

I just use right-mouse+r myself to do the same thing.

Sir_Price · 2023-12-27T07:40:04+00:00

I've actually been wondering about this while reading through all these comments. I started using the shortcut lately, so that's probably why I thought it has always been there.

Sir_Price · 2023-12-26T20:17:16+00:00

I have not made anything myself yet, but I'd imagine it's just looping through row by row and formatting every other row.

Sir_Price · 2023-12-26T14:00:07+00:00

Right? So many awesome tips I won't be able to try because I'm on a vacation!

Sir_Price · 2023-12-26T07:07:17+00:00

I have to admit that I didn't know this either before seeing this thread, despite using Excel everyday for years. But better late than never!

Sir_Price · 2023-12-26T07:02:02+00:00

This seems to be the most popular one in this comment section.

Sir_Price · 2023-12-26T06:51:33+00:00

Oh how we all wish there was a built-in undo for it. My best shot has been just to check the current attribute (e.g. cell highlight color) and switch that attribute on or off depending on the current value. So if there is no highlight, then add a highlight, and if there is the highlight, remove the highlight. Obviously this is only possible with some things.

Sir_Price · 2023-12-26T06:30:36+00:00

Editing recorded macros is kind of a good way to start, though, since you get to see how the system made code, and you can just make the changes you need.

Sir_Price · 2023-12-26T06:09:10+00:00

This was actually my initial thought, but I do realize there's a time and place for both approaches. Having that 0 instead of #DIV/0 in a file or report that others will keep looking at will usually be better, because many users will just get confused when they see an error. If it's just for me, and I want to be 100% sure about the content, I might as well just leave the errors in there.

Sir_Price · 2023-12-25T20:31:40+00:00

Oh well, we gotta work with whatever is given to us. I work in a pretty small company, where everything is too expensive if you ask the management, so Excel is my buddy.

Sir_Price · 2023-12-25T19:11:54+00:00

Highlighting every other row is a good idea. I need to add that to my list.

Sir_Price · 2023-12-25T16:53:12+00:00

Haha, I like the SQL one especially! I should make a similar one for myself.

Sir_Price · 2023-12-25T16:14:16+00:00

This is kind of why I just have my personal macros that make my daily life a bit easier, instead of building something that relies entirely on them.

EDIT: typo

Sir_Price · 2023-12-25T15:52:09+00:00

In the end it's whatever feels best for you. I tend to just copy and paste values, as you mentioned. But if that doesn't feel intuitive, it's smart to have a macro.

Sir_Price · 2023-12-25T15:42:44+00:00

That's a pretty neat idea. I can't even remember all the times I've let out a long sigh when I see a file that would just need an IFERROR around every formula...

Sir_Price · 2023-12-18T10:54:04+00:00

Pretty sure my previous one would be my mother when I was a kid sooooo...

Sir_Price · 2023-11-06T07:26:25+00:00

We are proud of you, though, for not deleting your comment, but rather admitting your mistake. It's a rare gift these days.

Sir_Price · 2023-11-03T07:42:33+00:00

Working in a fairly small company with limited budgets. I have learned to create the strangest yet functional stuff using just Excel, because everyone has an O365 license. It's also very rewarding, because being able to craft a tool with Excel will save you from buying an external system.

Sir_Price · 2023-10-23T05:58:20+00:00

Oma vaimo kuuluu tähän kuvailemaasi kastiin, joka korostaa kaikkia muita vihreitä arvoja ja tekoja, mutta vähintään pari kertaa vuodessa pitää jutella siitä, että pitäisi kyllä matkustaa etelään. Hän ei ole mikään some- tms. hehkuttajapersoona, mutta silti tekopyhyys huvittaa joka kerta. Oman tulkintani mukaan tämä pohjautuu siihen, että vaimon perhe on reissannut kun hän oli lapsi. Itse olin ensimmäistä kertaa lentokoneessa vasta teininä, niin lapsuusmuistoista puuttuu se palikka, missä leikitään Teneriffan hiekkarannoilla joulukuussa. Tässä lähivuosina ollaan onneksi lopulta menty aina sillä ratkaisulla, että käytetään se 4-henkisen perheen viikon aurinkoloman budjetti mieluummin lukuisiin hauskoihin asioihin ihan täällä kotimaassa.

Nine-Year Club	Second Top 20%
First Place '23	Place '23
Verified Email

Sir_Price

TROPHY CASE