positions

Hello there! I have an NBA Fantasy spreadsheet which I use for scheduling and analysis. There are 5 basic positions namely: PG (Point Guard), SG (Shooting Guard), SF (Small Forward), PF (Power Forward), C (Center). A player can have 1 or more designated positions. For example, Steph Curry is PG...

Hi, I am working on a data set which manages positions for landing sites. I need to be able to format positions in 2 different ways, one as Degrees Decimal Minutes (including symbols), and the other as Decimal degrees (+ and - based on E/W). The positions are entered in an info sheet for each...

Hi, I am using an accelerometer to determine a patient's position on a bed. Five positions need to be identified. In the table below, corresponding accelerometer voltages were measured in each of the five positions. Orientation Vx Vy Vz Supine flat 1.666 1.68 1.007 Supine 10˚ 1.657 1.88...

Good morning, I'm trying to do a schulte table 3x3 with random 5 alphanumeric. Can you help me pls ? I need to see this table for just 1 second and then after 7 seconds another one with random positions, the numers are from 1 to 9 and the letters from A to Z.

Good Morning So I have two sheets. both have Zip codes but on one sheet some of them are 00000,some are 00000000 and some are 00000-000. the other sheet are all 5 position 00000. for them to match I'm using =LEFT(A1,5) and it shortens them all to 5 positions but then Vlookup no longer works...

Hi. Please see link to the relevant file, below: https://1drv.ms/x/s!AtIvkRgReIvwgRPV4fmLEL1-gjz- I have a problem that I can’t seem to solve. I have this list of times and positions, with the times in hh:mm:ss format. However, the times have the minutes and and seconds in the wrong...

Consider the following array, {1, 2, 3, 4, 5, 6, 7, 8, 9}, is there a way that I can return the positions of the values in a separate array that match a certain criteria? For example, if I wanted just the positions of the even values from this example array, {1, 2, 3, 4, 5, 6, 7, 8, 9}, the...

Split numbers in 7 positions and make all possible sets adding 0 in it</SPAN></SPAN> Hello,</SPAN></SPAN> I need to produce all possible set adding 0 in to given numbers (spiting in to 7 positions)</SPAN></SPAN> Which finally sum should be = 7 for each of lines</SPAN></SPAN> Here are the...

I currently run a report on a weekly basis that will show all of our open positions. I then copy and paste that report into my spreadsheet, so I can run any vlookup to suits my needs. Each week when copying and pasting the report into my sheet, I do not overwrite the previous data, I paste it...

I need a MS Excel calculator to find Planetary positions on any given day (past, present or future) as I am a Astrology enthusiast. Can somebody help.

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...

I have a spreadsheet which lists members who hold multiple leadership positions. I have an array that pulls positions from a different sheet. If they hold 3 different positions, then I would like the position to be on 3 rows, instead of one. Right now, for example, Joe Blow holds there...

Hello, How do you move labels on a radar chart? I have 45 "Pie" slices that have a description for each and they are illegible at twelve and six o'clock positions. The labels overlap each other. Is there a way to separate the labels a bit further or change their axis to be radial instead of...

I am building a document that shows a productivity target for almost 200 positions. My data is trailing 12 month actual productivity for each position by week. Currently I have a formula that counts the weeks if they are greater than the current productivity target, divided by the number of...

I recorded this macro the other day but it takes about 30 seconds to run. I tried to clean it up the best i could but I'm wondering if using a loop might be more efficient. [code] Sub ClearBlanksSiteRepsRADelegates() ' ' ClearBlanksSiteRepsRADelegates Macro ' Clear sheet of non leadership...

I have a spreadsheet where I am trying to populate positions from a lookup table on another sheet (LocalStateSCC Falcon positions) where all the source positions are in a single column. I have a column for Local, a column for State and a column for SCC in my destination sheet (the one which...

I have to create directory reports for members who hold leadership positions within our organization. Some of our members hold multiple leadership roles in either Local, state or federal positions. Say, for example, I wanted to create a query that would exclude all members that held federal...

I have query where one member can hold different positions within our organization but I only want their name to appear once in the query-- it'ss being used to generate a report. I did change unique values to yes on the query property sheet but I don't think this situation would apply since they...

I have a number of cells that I want to concatenate into one cell (merge multiple records into one record). However, I would like to exclude cells that start with the words State or Service Center since these have to be placed into a separate field in the record. Column A has all the member...

I have two sheets in one workbook, sheet1 is the values that I use as a referral to sheet2 which has the real work. in sheet2 I have a column named (Positions) which I put the position of each new employee in sheet1 I have a column that has all the types of positions in our company. how can I...