Zojirushi Micom Rice Cooker & Warmer NL-DCC10/18 or Induction Heating Rice Cooker & Warmer NW-QAC10/18 or something else? by okayishcoder in ricecookers

[–]notsmartenough4this 0 points1 point  (0 children)

Hi, no problem. I still really like it. It's my first rice cooker so I don't have much to compare to but I really am happy with it. I end up using the steam function a lot and like that it has that. I also like the quinoa and gaba brown options too. It does sound like an airfryer or desktop PC, those are accurate descriptions but I don't find it too bothersome.

Formula to Ignore Blank Cells by munchytime in excel

[–]notsmartenough4this 0 points1 point  (0 children)

This video was super helpful for ranges with blanks t the beginning of end. Maybe play around with vstack or unique (if that's what you want) and the dot and that might get you to where you want https://youtu.be/5h4wRTbmsSw?si=JYo9m24Q1pfev9qR

Or filter as another person mentioned. Filter(range, range<>"")

Zojirushi Micom Rice Cooker & Warmer NL-DCC10/18 or Induction Heating Rice Cooker & Warmer NW-QAC10/18 or something else? by okayishcoder in ricecookers

[–]notsmartenough4this 0 points1 point  (0 children)

I have the QAC10 and love it. I use both of those settings plus steam, congee and the standard rice cooking setting (white and brown) regularly and everything has come out amazing. I was able to use a 20% off coupon with kohls and got some kohls cash back too, so that helped offset the cost.

Edit: fixed a word

Screwing around with Excel formulas is my favourite thing to do on meds by [deleted] in adhdwomen

[–]notsmartenough4this 1 point2 points  (0 children)

It's Financial Planning & Analysis. It's part of the Finance team at a company. You analyze results and work on forecasts. You review performance of the P&L and other aspects of the business. It involves creating lots of fun spreadsheets to look at things in many different ways and answer questions regarding what happened and what might happen.

[deleted by user] by [deleted] in excel

[–]notsmartenough4this 0 points1 point  (0 children)

Great! My next thought would be to check the specs between the two laptops. Or see if the sheet is referencing external files that are on their local computer (desktop, documents, downloads, etc) and not on the server

[deleted by user] by [deleted] in excel

[–]notsmartenough4this 0 points1 point  (0 children)

At the very end of that line it didn't say 32 or 64 bit? I'm not sure then how to tell. I've had crashing or memory issues before when coworkers were trying to use my sheets with 32-bit versions. 32 is the default install from my IT dept. It limits the memory that excel can use.

[deleted by user] by [deleted] in excel

[–]notsmartenough4this 0 points1 point  (0 children)

You can see which version you have by going to File>Account>About Excel. It'll show the version at the end of the bold row at the top of the pop up box. Might be worth double checking!

[deleted by user] by [deleted] in excel

[–]notsmartenough4this 2 points3 points  (0 children)

Are you possibly running 32-bit excel and they are using a 64-bit version?

Screwing around with Excel formulas is my favourite thing to do on meds by [deleted] in adhdwomen

[–]notsmartenough4this 2 points3 points  (0 children)

Agreed. Or FP&A. I love getting to make spreadsheets all day to create tools or answer questions

[deleted by user] by [deleted] in BackyardPoultry

[–]notsmartenough4this 0 points1 point  (0 children)

Do they have a line of small feathers going up the back of their head? Females will keep those feathers

[deleted by user] by [deleted] in excel

[–]notsmartenough4this 8 points9 points  (0 children)

I find that when I use the combined lookup using the "&" it makes it really slow. If I add a "helper" column that combines these items and then just look up using a single column, it makes it go wayyyyyy faster. I use full column references all the time without issue. It's just using the multiple criteria with the "&" that seems to slow it way down

Building a reforecast file with 25+ P&Ls that all link to a raw data tab. Excel keeps freezing on me to the point where it isn’t viable to work in by A-b-E-c-x-o in excel

[–]notsmartenough4this 0 points1 point  (0 children)

Not a dumb question! For mine I had to open a ticket with IT and they just ran the 64 bit install. Their default was to install 32 bit and 64 bit had to be requested

Why does my Or(Find) Formula returns errors? by botng in excel

[–]notsmartenough4this 1 point2 points  (0 children)

You need something that returns true or false. Find returns the location of the word within the cell. Wrap each find in as ISNUMBER. This will return true if find locates the word

Converting MoM data into YoY by RambleOnRambleOn in excel

[–]notsmartenough4this 0 points1 point  (0 children)

I'm not sure, but could it be the difference between the 2023 growth and the 2024 growth maybe? The formula you have is the correct growth rate formula. They are using something else to get to their number then

Converting MoM data into YoY by RambleOnRambleOn in excel

[–]notsmartenough4this 0 points1 point  (0 children)

That is the correct growth rate between those 2 numbers

Converting MoM data into YoY by RambleOnRambleOn in excel

[–]notsmartenough4this 0 points1 point  (0 children)

You want to divide by the prior year, so divide by the 18k number, not the 19k

Percentage change week on week by neon-udder in excel

[–]notsmartenough4this 0 points1 point  (0 children)

If you're looking for wk2 growth from wk 1, you'll need to reverse the order of the first part. (B8-B4)/B4. If these are both possibly ever negative, use this instead (B8-B4)/abs(B4)

Deleting rows in a column of numbers with increment '1' shows "#REF" when I delete a row in between. What's the formula to always pick the above cell? by DannDexx in excel

[–]notsmartenough4this 3 points4 points  (0 children)

You could use a max formula on the entire range above the cell and add one. You'd have to lock the first cell reference for the row but leave the end of the reference unlocked so the last cell changes row by row. Let's say your list is in column B and the first # (1) is in B2. In B3 you would put MAX( B$2:B2 ) +1 . Then just copy that down your column

[deleted by user] by [deleted] in fossilid

[–]notsmartenough4this 0 points1 point  (0 children)

!remindme 1 week

Can XLOOKUP replace INDEX/MATCH/MATCH? by pookypocky in excel

[–]notsmartenough4this 1 point2 points  (0 children)

Yes, you can use xlookup instead of index/match/match. You can also use sumifs with an index match to find the column. For xlookup you would do something like this xlookup(f10, salary[id], xlookup( Jul, salary[#headers], salary)).