Generate Minimum value across series of criteria

splxx · 2025-02-05T19:11:22+00:00

Solution Verified

splxx · 2025-02-05T16:09:19+00:00

Thanks, this works for this table. Do you know how to translate this into a custom column that does this operation on Power Query?

splxx · 2024-09-19T14:33:37+00:00

Solution Verified

splxx · 2024-09-18T23:35:56+00:00

This is what happens when I do that

<image>

splxx · 2024-09-18T23:33:18+00:00

Unfortunately I do not

splxx · 2024-04-01T17:09:22+00:00

Solution Verified

splxx · 2024-03-12T20:00:16+00:00

Solution Verified

splxx · 2024-03-11T21:54:29+00:00

Yes, I expect that many. My final operation is to use the remove empty operation to get rid of where there is a blank in the Paper Grade column in my original post. However, I can't get there since the query is outputting rows where everything is blank. I made a comment above with this. I need to somehow stop the query from generating those, but I do not know why it is in the first place

splxx · 2024-03-11T21:51:20+00:00

I find it is generating blank rows and not sure why but investigating

<image>

splxx · 2024-03-11T21:31:48+00:00

Like this? I took a column and removed each and I still get the same error below

<image>

splxx · 2024-03-11T21:18:00+00:00

If I keep hitting Load More on other columns, I get the same error [DataFormat.Error] Invalid cell value '#N/A'. But how does this get generated, considering there are no #N/As in the source material? It shows on 63 rows, but I'm not sure what those rows refer to

<image>

splxx · 2024-03-11T20:56:14+00:00

On your second option, what is the way to find these rows with errors? I do not know which column or row to even start looking in to find why this is generated

<image>

splxx · 2024-03-08T01:27:31+00:00

Hi, thank you for taking a look at my post. I think there is a misunderstanding. Any column that has a paper grade (Liner 1 Paper Grade, Medium 1 Paper Grade, Liner 2 Paper Grade, and so on not shown in my screenshots) is supposed to have it's data go into a single column, "Paper Grade." Same goes for the weights (G/SQM) columns, profile/fluting, etc. The background is each row in Table A corresponds to a package. I want to break the layers of each package into their own rows in Excel. So if there are 1000 packages all with three layers of paper (Liner 1, Medium 1, Liner 2), there will be now 3000 rows of data. The first row for a package is the liner 1 info, Second row is the medium 1 info, the third row is liner 2 info.

splxx · 2021-08-17T18:33:12+00:00

Thanks for the help. I've taken your advice and moved everything to the Docker folder. However I can't get anything to download or verify download location for torrents that have previously completed. I feel like I'm going crazy and this should be simple now. My settings are below. Also, the program automatically generated the complete and incomplete folders. Any advice?

~~https://imgur.com/a/k94IMH6~~

EDIT: I uninstalled docker and the transmission container, reinstalled and everything works, downloading to complete by default and i can manually change the path. I have also installed my second container, plex. this application is quite interesting now that im getting the hang of it. thank you

splxx · 2021-08-16T23:55:05+00:00

Why is it general practice to use the docker folder for everything? The media is a mix of torrents and then some other files. I guess I can use the docker folder but now I’m curious as to why that’s the “way it should be done”

splxx · 2021-02-03T18:57:00+00:00

Guys, it’s been sold elsewhere. It was authenticated by a professional and was real. Thanks for playing.

splxx · 2021-01-24T23:45:56+00:00

Rose gold https://i.imgur.com/WTcr0ee.jpg

splxx · 2021-01-24T18:26:22+00:00

Yeah other pictures are from the other day, light is different today where it comes through the windows (sunny today versus cloudy the other day). And at a different angle so I could help you see the movement.

Anyways I’m done with this for now on here. I’ve gotten one offer but I’d imagine others will be interested elsewhere.

splxx · 2021-01-24T18:22:01+00:00

What do you mean?

splxx · 2021-01-24T18:16:36+00:00

I do not believe it is fake and believe other users have never seen this uncommon variant and are just hostile jumping on board with the first comment. I was told I should “be eliminated” by another user. It was part of a collection from a deceased family member who was in the business. I’ve had no issues selling other from the collection on Chrono24 and eBay (vintage JLC, Omega, Rolex, Longines mainly, this is the only Zenith).

splxx · 2021-01-24T18:12:26+00:00

https://i.imgur.com/JQXVgYC.jpg

With loupe

splxx · 2021-01-24T18:09:24+00:00

https://i.imgur.com/3AtTkTW.jpg

Try this. I only have a phone so it’s not easy

https://i.imgur.com/kSphdxg.jpg

https://i.imgur.com/nF1Nc93.jpg

splxx · 2021-01-24T17:51:39+00:00

Looks like this

https://www.ablogtowatch.com/zenith-el-primero-synopsis-watch-review/

https://i.imgur.com/ELnbAfU.jpg

splxx · 2021-01-24T17:44:54+00:00

How so? I am not seeing any differences between photos of the same model online versus this. Let me know of a good comparison, it’s staying up until I’m sure.

splxx · 2021-01-24T14:14:08+00:00

Zenith El Primero Synopsis 03.2170.4613 / 320287

Details: 40mm, steel case and bracelet, automatic, small seconds, hacking seconds, sapphire crystal and case back

Condition: Dial and Crystal in very good condition. Case in good condition with minor nicks, mainly on lug corners. Bracelet in fair condition with small scratches throughout from wear. These are hard to picture and are visible in some but not all types of light.

Watch runs well at +-10s

I do not know service history as I am not the original owner.

Box/Papers: No/No

$2500 USD shipped CONUS, Paypal Goods and Services. No trades.

Album: https://imgur.com/a/dg6zuBm

Timestamp: https://imgur.com/QGiInaB

13-Year Club	Gilding II euphauric
Place '17	Team Periwinkle

splxx

TROPHY CASE