position

I have a shared spreadsheet that I am trying to eliminate laziness in on the part of my users. Column B contains a case number, and column S contains a position (validated lookup of 10 options including Other and blank) My issue is that users are failing to fill in the position of the person...

Hello, I'm trying to build a fantasy baseball spreadsheet. I have a list of players that I'm hoping to fill in each roster spot for each team. The player's name is in Column B. The player's position is in Column C. On the same tab, I'd like to place each player into a roster spot which is...

Hi Thank you in advance for any help with this one. To put things into context, the spreadsheet as a whole filters a number of pivot tables by 'manager name' and this updates some data which updates a chart in five different sheets. This chart is then copy and pasted as a picture in...

I run Win10 Pro on a Thinkpad. The size and position of opened, then closed Excel-windows is not preserved between Windows-sessions. This is true for other windows as well, e. g. Edge. They reopen at any position and/or any size. Is there a setting to keep positions and sizes like in former...

Hello, I am trying to figure out how to have the cells lookup the value in closest proximity to the cells to the left of my desired cell. For example, how to have the 2 show up in the x position, how to have the 1 show up in the y position, and the 3 in the z. And if I was to continue to input...

Hi all, I have to set of data. Both lists have a Employee reference which is unique to each person. First: List of all positions people have ever had in the company with start and end date. Second: List of all the salaries people have had within the company with a start and end date. I need...

This post can be deleted as I figured out the solution, but the option to delete is no longer available. Regards Pete

I am trying to pull data from another excel spreadsheet while it is closed using drop down menus to change the year and month. The reason for the drop down is to change the file that is referenced as I will be saving the files with the correct year and month. Here is what I have...

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

Hi, In .xlam file I have added UserForm which initialize by set position of the form in middle on main screen with dual monitors. I am using it commonly in all other forms in xls/xlsm. Me.StartUpPosition = 0 Me.Left = Application.Left + (0.5 * Application.Width) - (0.5 * Me.Width) Me.Top =...

Hi, I am trying to return the minimum value of the position of all numbers in Mi Yang 1337 =MIN(FIND(0&1&2&3&4&5&6&7&8&9;A2&"0123456789")) Using the above function gives 13 as result. It should be 9. What is wrong?

I want to track all the changes in our headcount:* All the dates employees were hired, which position they were hired for, and which team they belonged to* All the dates employees were promoted, including the new positions (and the team)* All the dates employees resigned / left the companyFor...

Hello! Is there way to calculate the hours needed at two separate rates that add up to the total cost of a project? For instance, the estimate is 40,000, and the hourly rates are 120/hr for one position and 150/hr for another position. How many hours of each rate would I need to get to 40,000...

Hi everyone, My question is this: Cell A1 = 3 Cell A2 = 3 Cell B1 = 0 Cell B2 = 1 Cell C1 = 2 Cell C2 = 2 Need a formula that count the total number of times a digit repeats from the cell below. So using the example above the total = 2 since the 3 repeated in cells A1 & A2 and also 2...

Hi. Some background. I work on a vessel laying subsea cable on the bottom of the ocean. Usually we need to draw this cable position in XY, and also in Z. For the position in Z, we generate a profile view along the XY position. Giving the orange line in the attached screenshot. However, since...

Bonjour, Depuis que j'ai changé de machine (W10 1803 + Office 2016 puis avec Office 2019) j'ai un problème avec l'alignement des chiffres quand j'utilise le format "Comptabilité" sans afficher de symbole de monnaie (aucune). En effet les séparateurs de milliers s'affichent, les deux décimales...

Hi Team, Below is the table <colgroup><col style="mso-width-source:userset;mso-width-alt:3693; width:76pt" width="101" span="3"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt"...

If I've got the coordinates of the location where I want the cursor to go (can't use setfocus), what is the trick to move it to any given x,y coordinates? I've been able to find code to tell me the the cursor's position when it is clicked on a label, but when I'm done I want it to return to...

Would it be possible to loop thuru all the worksheets , counting how many rows are used in colum A, and move the position of the worksheets so the ones with the highest @ of entries are on the left , diminishing to the right?

Hi from partially cloudy 9 Degrees C York UK, I am struggling with conditional formatting. This is what i want to achieve.. Phrase "Hotels York" - Wk 1 Position 5 | Wk 2 Position 1 - (Promotion Green Arrow Up) Phrase "Bed & Breakfast York" - Wk 1 Position 2 | Wk 2 Position 2 - ( No movement...