position

Hi Folks, I hope you can assist me. I've tried a few IF, AND combinations and even Pivots without success hence the plea. I am looking to determine, per Reference, any date range for that reference that is not covered by a period where the Main Position = 1. Reference Date...

Hi there! I am using INDIRECT to make it so that I can reorder my tabs and have the data on a summary page track. However, with tons and tons of tabs, I need the hyperlink to track. So, if I move the tab from position 1 to position 5, I want the hyperlink to still direct to position 1. I...

I have automated the creation of a PPT slide. However, the issue I run into arises when I run it on other computers. The size and positioning of the shapes seems to change ever so slightly, but noticeably. I have the shapes set to position themselves automatically based on original position...

Hi All Apologies VBA isn't my thing but thinking there must be a way to do this. My workbook has 2 worksheets, sheet1 and sheet2 My data is stored in Sheet2, cells A38:B43 I need to create a column chart in Sheet1 say in position H5:L9 The idea being that I then attach the macro to a button...

I am using Excel 2007 Is there a way of seeing or getting the exact position coordinates of a object on a worksheet, maybe a macro that can return or display the coordinates into a cell or on the clip board? The object is a option box called "OptionBox1" What I mean by exact position is the...

Hi all. I am struggling to find a way to lock the position of multiple slicers, yet allow them to still work. I have a report to send to players and the worksheets will be protected. When I do this the slicer is not usable but other methods mean that it can be moved and deleted by the end user...

I found a UDF that extracts a word at a time, how do I change the code to extract 2 words at a time? many many thanks Function findword(Source As String, Position As Integer) Dim arr() As String arr = VBA.Split(Source, " ") xCount = UBound(arr) If xCount < 1 Or (Position - 1) >...

Hello, I am trying to automatically update references in formulas based on the row position of its cell. For example (Sheet1): A1= 1 B1= ='WBS1'!$C$13 A2= BLANK B2= BLANK A3= 2 B3= ='WBS2'!$C$13 A4= BLANK B4= BLANK A5= 3 B5= ='WBS3'!$C$13 In this example it shows...

Hi, This is one formula i have: =IFERROR(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!C:C,ROW()),'Main Squad'!$A$17:$AM$17,0),0),"") & this is another: =IF(Table7[[#This Row],[POSITION]]="Goalkeeper",(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!$C$1:$O$1,),'Main...

Hi, This is one formula i have: =IFERROR(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!C:C,ROW()),'Main Squad'!$A$17:$AM$17,0),0),"") & this is another: =IF(Table7[[#This Row],[POSITION]]="Goalkeeper",(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!$C$1:$O$1,),'Main...

Hi, One day i'll get my head around how to you these 2 functions properly. I want to find my best Goalkeeper out of a list of players. In my sheet so far i have the position & the highest rating for that position, i just need to match the position with the rating to get the player. Sounds so...

All rows have a height of 15 points There are 72 points per inch Row 303 will have a position in points of (303*15) 4545 Row 303 will have a position in inches of (4545/72) of 63.125 One of my machines produces this result. On another machine the position in inches is 62.62 (using top in crop...

Hi, i'm hoping this is an easy one, i just can't get my head around the formula to use. Below is my spreadsheet with all my players on the left & every position they play in & their ratings. On the right is every individual player & their BEST rating. What i'm wanting is for on the right under...

Hi, i'm new to this forum so i hope i've posted this in the right section. What i'm doing is making a spreadsheet for my Football Manager game. I've got everything i need in, i just need to get a formula right to make my "Match Squad" work properly. Each position i've done with all the correct...

Hi, we are trying to clean some data up & extract text which ends: 883;" from search strings... EG we would like to extract 2N5883 out of cell B2 = ;XYZ12;2N5883;B73304001;B73304;;;;;;;; The plan is to use the MID function with a helper column: a) SEARCH("883;",B2)+3 to find the...

Back Story: A couple years ago I created a FF Draft Board for my fantasy league. I hook up my laptop to my two smart TVs. One screen shows the draft board. The second screen shows each team's roster as they are drafting. The draft board will fill in the players team and position after their name...

I’m trying to create a complete fixture list for next year’s Rugby World Cup. It’s going all right but I’ve hit a problem with the group tables. I’ve managed to get the teams to adjust their position based on 1) points for winning and then 2) points difference. Whatever I do though, I cannot get...

Dear All, Please help me to know, how can i find text position within cells. Sentence is, "Election commission has organized the Election 2018." There are two "Election" and want to know both locations separately suppose first election location is 1 and second "Election" location is 38...

I have position numbers in column A. 1,2,3,4,5,6. Any number can occur for a given position. The numbers are in column C. So position 1 can have 45 occur X number of times. So, let's say that 45 occurred most often in position 1. I want to have a formula that will tell me which number...

Hi, I'm using a dataset of football player scores to try find the highest scoring combinations of players at varying maximum values. Each player has an assigned ID, position, value and score. I have only been able to return the 1st, 2nd, 3rd etc. highest scores per position so far. Ultimately...