bagehis

u/bagehis


r/realmadrid•

https://football-italia.net/ancelotti-breaks-silence-as-prosecutor-requests-jail-term-for-real-madrid-coach/

This is something that I must have missed in previous reporting about Ancelotti 's tax case: the year in question is 2015, the year Real Madrid fired him. He was a resident until he was fired in mid-May, them he moved to Vancouver (prior to May 25) for spinal stenosis surgery and treatment:

https://www.theguardian.com/football/2015/may/25/carlo-ancelotti-west-ham-manager-surgery-real-madrid

He lived in Spain for less than five months, so he paid taxes in Italy (where he is a citizen). As far as I can tell, Spanish law says you have to pay taxes in Spain if you lived in Spain for mo

23

r/excel•

I am trying to make a formula to find the next match on the sheet (equal to some columns, within a range for other columns, and not equal to another column). I am currently using index-match. I am open to other options, as this seems to not work. Column A is the rank - used for filtering and ranking data from the raw input, Column B is the index number of the row of data.

Current formulas:

=INDEX(B3:$B$5001,MATCH(1,(E2=E3:$E$5001)*(G2=G3:$G$5001),0))

This returns the first index number that matches two criteria.

=INDEX(B3:$B$5001,MATCH(1,(E2=E3:$E$5001)(G2=G3:$G$5001),0)MATCH(F2,M3:$M$5001,-1))

This was supposed to return the first index number that matches two criteria and is greater

11

r/excel•

I am currently using index-match. I am open to other options, as this seems to not work. Column A is the rank - used for filtering and ranking data from the raw input, Column B is the index number of the row of data.

Current formulas:

=INDEX(B3:$B$5001,MATCH(1,(E2=E3:$E$5001)*(G2=G3:$G$5001),0))

This returns the first index number that matches two criteria.

=INDEX(B3:$B$5001,MATCH(1,(E2=E3:$E$5001)*(G2=G3:$G$5001),0)*MATCH(F2,M3:$M$5001,-1))

This was supposed to return the first index number that matches two criteria and is greater than a third cell of data (Column L is the minimum of the range and M is the maximum of the range). The intent was to have one match filter for the mi

13


r/BreakingPoints•

He kept hammering on with this simplistic model of an economy where the only driver of inflation is how much money is printed. If economics was that simple, we would stop studying at Economics 101 and the Fed could be run by one person who just crunches the numbers about how much money should be created each year. This isn't reality. Economics is far more complicated than that and I think he knows that and I'm disappointed that he wasn't pressed on that.

136

r/Netsuite•

I work at a company that has been around for a minute and has customer numbers using two different naming conventions (one old and one new). When they setup NS, they associated the ID used in the CRM with the customer ID in NS. They want to update the old IDs to use the new naming convention. I know how to update the customer ID manually. There are several thousand records however, so I'm hoping to automate this. Other than letting new records be creating when we import customer records next, then merging the existing accounts into the new accounts, or manually updating each existing record, is there a less onerous way to update these records?

24