home

I'm looking for a formula to create a swimming league of 6, 7 or 8 teams (depending on how many enter) where each team has one home gala and plays away an even number of times against the other teams. With an even number of teams there were would and imbalance, say playing some teams twice and...

I have two tables. Table 1has Electric Company addresses and table 2 home addresses. I am trying to link the power company meters to the correct home addresses but the home address are some what different. How can I link the meters like the diagram below? Is there a formula I can use that will...

Hi Guys, I do have a question about winning and loosing streak in my hockey league. I have data where player can play home or away. What would be the most efficient way to count winning and loosing streak?

Hi Team, Is it possible to do the following via DAX? Table now: <tbody> Div Date HomeTeam AwayTeam HomeGoals AwayGoals 1 26/08/2017 A B 2 1 1 26/08/2017 C D 0 4 1 26/08/2017 E F 3 0 </tbody> Table wanted: <tbody> Div Date Team Place Goals 1 26/08/2017 A Home 2 1 26/08/2017 B...

I have a list of employees, and a list of offices. I want to find which office location an employee is closest to, based on the employee's home zip code - so, find the closest zip code in the office list, to each employee's home zip code: <colgroup><col><col><col...

I have a subform to which the user enters data. At the top of a form is a button which will take them to a home screen. If the user clicks on the home button, the information they have entered is saved in a new record. I would like to have some code check to see if the subform is 'dirty' and...

Sorry, but I can find a place to ask a MRExcel site question, so here it is. When I used to sign in I had a home page that had my user name, it would say Welcome SeniorTom and a way to sign out. From there I would go to the forums. In the upper left was the MRexcel logo and the logout and...

I am looking for the best way to create a list of home fixtures for a specific date (this will help me to see book a pitch at certain times), which will show me the team that's playing at home and the kick off time. The home team will always be a 'Weedon' Team I have 6 age groups and have all...

Hi All, I have database where one Colum is for Stores Like Stores Home Depot Home Depot First Home Depot Second Ralphs Food 4 Less . . . . . . . By Macro Im trying to extract data for store “Home Depot” only. In Criteria range I have: Stores Home Depot Sub Filter_Stores()...

Hello All! I did a search and couldn't find a post that matched what i'm trying to accomplish. If i have a master team schedule...showing AWAY games in column G, and HOME games in column H, i want to be able to filter and see the teams ENTIRE schedule. right now i am filtering home, then...

Hi Guys, I'm currently working on a macro that creates a shape on each visible sheet. And then I want to assign a Macro to those shapes. This is what i have so far Sub AddNavigationPage() Dim ws1 As Worksheet, ws As Worksheet With ThisWorkbook .Sheets.Add(Before:=.Sheets(1)).Name =...