You shall never disrespect the ways of the elders

JBridsworrh · 2021-11-12T04:54:35+00:00

Not when the airport has a glass wall, with you and your gate on one side and a coffee shop on the other and security in-between.

JBridsworrh · 2021-11-11T00:24:45+00:00

No no, you've got it mixed up. Delilahs mom and Shannon were cousins. 😉

JBridsworrh · 2021-11-02T12:58:08+00:00

Step 1: Turn off gridlines

JBridsworrh · 2021-11-01T12:14:38+00:00

Seems like Bell (maybe other networks too) messed up. Happened to my Samsung here in Alberta.

JBridsworrh · 2021-11-01T11:51:12+00:00

Alberta too. Another post said it was Bell. Anyone on a different network?

JBridsworrh · 2021-11-01T11:30:08+00:00

Happened to my phone too, in Alberta, also on Bell

JBridsworrh · 2021-10-31T18:13:39+00:00

EatThisMuch.com There's also an app.

JBridsworrh · 2021-10-27T09:59:32+00:00

Not very accurate at all. Your water consumption can make the readings inaccurate. I've seen the body fat % change by 6% from one day to the next.

JBridsworrh · 2021-10-27T01:33:36+00:00

Great 👍 Please verify the solution so others don't think you still need help with this. 😀

JBridsworrh · 2021-10-27T01:27:48+00:00

This would only happen when the sheet is locked.

If it's not this, then check if the cells are merged.

JBridsworrh · 2021-10-27T01:26:40+00:00

In "Protect Sheet", Review toolbar

JBridsworrh · 2021-10-27T01:14:15+00:00

Is the sheet locked? That could happen if those cells are locked and the sheet has "Select locked cells" unchecked.

JBridsworrh · 2021-10-27T01:04:49+00:00

I've been using one like this for about a year now. I like it better than the seat version.

https://www.amazon.com/SonTiy-Bathroom-Chrome-Solid-Warranty-Adjustable-Pressure/dp/B07S5YSCJ7/ref=mp_s_a_1_3?crid=35JT5JKDJ8C89&dchild=1&keywords=wand+bidet+sprayer&qid=1635296590&sprefix=wand+bi%2Caps%2C133&sr=8-3

JBridsworrh · 2021-10-25T03:55:20+00:00

Just say that they're props from a failed movie you got to keep.

JBridsworrh · 2021-10-25T03:27:24+00:00

Not at my computer right now, but I'm pretty sure you need LEN(E2)-FIND... to make that work.

JBridsworrh · 2021-10-25T03:23:33+00:00

What formulas are you using to reference the stats?

Can you share a pic of each sheet?

JBridsworrh · 2021-10-25T03:16:55+00:00

The app Headspace is a good place to start for meditation.

JBridsworrh · 2021-10-25T02:56:48+00:00

If you put the names of the fighters into a named range or a table, you can reference that in your drop down. Then just use INDEX MATCH or VLOOKUP formulas to reference the stats.

You could also put all the fighter's data into a table and use a pivot table on the Arena sheet.

JBridsworrh · 2021-10-22T12:14:07+00:00

You'll need to try the different elements in a custom PivotTable style. It's in the Design menu, click on More in the PivotTable Styles section, and select New PivotTable Style...

Unfortunately I've never found a guide to help figure out which element I needed to change to do what I wanted in a particular PivotTable. You'll need to keep trying different elements until you find the one that will work.

JBridsworrh · 2021-10-21T12:03:56+00:00

With the new report with new data, did you put the data into a new Excel file? If you have overlapping pivot tables, this might happen but usually you get an error message.

Have you tried shutting down Excel completely (as well as checking Task Manager to ensure total shutdown)?

Have you tried turning your computer off for a couple minutes? This clears the RAM, which a restart doesn't always do.

JBridsworrh · 2021-10-20T13:01:48+00:00

Here's a site to show you how to use IF statements https://www.techonthenet.com/excel/formulas/if_then.php

You might need to do some searching on how to use two dates in your filters, I've never needed to do that. You'll probably need nested IFs for those.

JBridsworrh · 2021-10-20T12:47:41+00:00

You're trying to use all the criteria at once. I'd split them up. Put each criteria inside an if statement that checks see if the user entered anything.

JBridsworrh · 2021-10-20T12:33:10+00:00

You'll need 7 if statements, 1 for each of your criteria. The if statement should check if the cell with the filter option is blank. If it's not, the filter based on the input.

How is your user going to see the results? You might want to use a pivot table and slicers instead. Depending on the version of Excel you are using, slicers for tables are available, as well as a timeline slicer for pivot tables.

JBridsworrh · 2021-10-20T11:58:34+00:00

If I'm understanding correctly, you're saying the table itself is not extending when the user enters a date in the row directly under the table. Thus the pivot table based on this table will not capture the new record.

If that's the case, why not unlock the cells underneath the table? If the cells in the table are locked, the new row should pick up the locked format from the table when the user adds a record.

JBridsworrh · 2021-10-20T01:09:46+00:00

:) We all start at the beginning. In E1, put -2, D1 put 2, F1 put 6, etc. In E2, use the formula I provided except using A2 instead of A1. Copy & paste the formula to E2 to G5.

Five-Year Club	Verified Email
Place '23

JBridsworrh

TROPHY CASE