positions

  1. E

    NBA Fantasy Spreadsheet formula to assign players to respective 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...
  2. S

    Working with GPS position/coordinate formates

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

    Identify position based on voltage data

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

    Schulte table

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

    vlookup woes

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

    Date format Reordering

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

    Formula to Return Positions of Values from an Array as an Array?

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

    Split numbers in 7 positions and make all possible sets adding 0 in it

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

    Vlookup??

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

    planetary positions calculator

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

    Using MATCH to link different sheets as one

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

    Populating a cell if the cell next to it is empty

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

    Radar Charts

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

    Productivity Targets

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

    Making a macro more efficient

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

    Ppulating cells where adjacent cells are empty

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

    Excluding Members from a query exclude for 1 or 2

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

    Preventing duplicate records from showing in query

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

    Formula to exclude items in a range of cells

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

    Conditional Formatting for multiple specific texts

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top