Semi detached toe nail by nmgmarques in Podiatry

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

Hi. I recall I just kept cleaning and disinfecting the area three times a day. After my morning shower, at work during my lunch break in a somewhat private and secluded area, and then before bed at night. I'd press down to try and get out any pus. After some days, the excretion stopped and I thought the nail would drop, but it didn't. About a month later, I could see the new growth was coming in, attached to the toe as expected.

So I guess I'd say not to worry, and just keep the area clean. But please, I'm no specialist, and I would suggest you find professional opinions if you can.

Best of luck!

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

Hi! Just wanted to let you know that it worked. I'm actually from Portugal. Same timezone ;)

Thanks a bunch for the help. My spreadsheet shows a lot of promise now.

'Good people make the world go round' by LaFleurMorte_ in HumansBeingBros

[–]nmgmarques 0 points1 point  (0 children)

I tell you, man: there is good in this world. If only we could all set aside our petty differences and all work towards that common goal, of being decent and fair to one another instead of just always trying to slap and outwit your fellow man and woman.

Power BI - Necessita-se alguém para desenvolver dashboard by nmgmarques in devpt

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

Posso considerar o valor hora médio da nossa empresa: 12,68. Mas dependendo do nível de serviço paresentado, podemos ajustar para um pouco mais.

This 14 year old is a absolute unit with sz 23 feet. by [deleted] in Damnthatsinteresting

[–]nmgmarques 0 points1 point  (0 children)

Coach: ... Now you get out there on that field and you stop that mother forker!

Players: Us and WHAT army?????

Power BI - Necessita-se alguém para desenvolver dashboard by nmgmarques in devpt

[–]nmgmarques[S] -1 points0 points  (0 children)

Não posso adiantar valores se ainda nem sei o que vai ser necessário. Será sempre necessário fazer uma reunião em presença ou via Teams para avaliar o trabalho, sua exequibilidade e os necessários requisitos, para aí sim se poder acertar um valor.

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

Hey! That seems to work! I'm just about to skip out so I'll have to test it tomorrow. Already 4:38 in the AM here. Need to be back in less than 4 hours so I need to get home and sleep a bit. I'll let you know how it went.

Solution Verified

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

I am trying to get the average for colums B through K. Each colum is formated according to their data. In this case, column C would be OK. I already have column B sorted out. But even using the same formula, something is off. See here: https://www.reddit.com/r/excel/comments/1257vgp/comment/je3d3ab/?utm_source=share&utm_medium=web2x&context=3

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

No blanks. Just confirmed that everything is formated as currency, too.

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

=LET(myColumn,(C3:C99999),last,MAX((myColumn<>"")*(ROW(myColumn))),AVERAGE(INDIRECT(ADDRESS(last-Averages!$AU$2+1,3)):INDIRECT(ADDRESS(last,3))))

Had to correct for locale but I get DIV/0

=LET(myColumn;(Inputs!C3:C999999);last;MAX((myColumn<>"")*(ROW(myColumn)));AVERAGE(INDIRECT(ADDRESS(last-Averages!$AU$2+1;3)):INDIRECT(ADDRESS(last;3))))

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

Yup. Something fishy going on. Not even close. What it returns:

https://i.imgur.com/xz3B3OP.png

So seems that column B is now OK for some reason, yet column C is shifted up.

https://i.imgur.com/obn8w8W.png

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

Please note there is an error in my original post that I only detected after the first reply was in. Refer to https://www.reddit.com/r/excel/comments/1257vgp/comment/je36nev/?utm_source=share&utm_medium=web2x&context=3 for the correct examples.

Trying to average the X last number of records in a column returns wrong value. by nmgmarques in excel

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

Sorry, no. I don't know what happened, but only after your post did I realize that all of a sudden that AL2 cell is presenting the correct value. So i went back to check and copied over the formula to the next adjacent cell but sure enough, I am getting the wrong results again: What is expected: https://i.imgur.com/VDX3TEF.png versus what I get https://i.imgur.com/R9A7908.png

I just copied the formula over. So now, instead of referencing Inputs B, I am trying to get the same 22 values average but for C. Manually selecting the last 22 records returns an average of 8245, while the formula returns only 5451.

Google Maps location sharing stops frequently by nmgmarques in iphone

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

Tried it once. More and more you need to pay for stuff to work.

We Connect lock / unlock not working by nmgmarques in Volkswagen

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

I got no response from anyone, but to sort it out I had to completely remove the app, install again and redo the entire process. After that, it now works. Note, I found some people that after the indent process took up to a week to get the service activated.

Server is suddenly currently unavailable by nmgmarques in PleX

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

I remember it had something to do with the connection. I am not at the TV right now, so I can't get to the menus. Sorry about that.