position

  1. C

    Can a letter have a value in a cell?

    <tbody> POSITION POSITION TOTAL HOURS AMC AMC 8 </tbody> IF POSITION AMC EQUALS 4 HOURS HOW DO I GET EXCEL TO DO THIS FOR ME?
  2. D

    Position the "hyperlinked cell" in the middle for easy view

    Dear Professionals, I have a formula here that can target the wanted cell in the desired sheet, but it doesnt lock on the position for better view in the middle of window. Please help. =HYPERLINK("#"&CELL("address",INDEX(Pivot!BL:BL,MATCH(MID(B358,1,6),Pivot!BL:BL,0))),MID(B358,1,6)) From...
  3. S

    need tricky formula

    I'm looking for a non-array formula that will find the position in a list of the number closest to another number. In A1:A6, let's say I have 1;2;7; ;8;9 The closest number to 6 would be 7, so the formula would return 3 for the 3rd position. The closest number to 3 would be 2, so the formula...
  4. reneev

    Pull info from First Column with Data

    I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and...
  5. D

    How to set the start position of a modeless user-form?

    Hello all. I know how to position a modal form, but a modeless form, acting as a 'please wait' sign is not responding in the same way. If anyone can help I would be very grateful. I position a regular form with the following private sub in the forms code window Private Sub UserForm_Activate()...
  6. M

    Seat Allocation formula

    Hi, need help on how to use Excel to meet below requirement. Below sample is just small population of total seatings so would need to automate. Appreciate your help please, thank you!!! =) Requirements: 1. Allocate the Box capacity following the Position hierarchy, such that "Head" starts to...
  7. T

    "Can't execute code in break mode" when copying worksheet array to a new file

    I am trying to execute the code below to create a set of workbooks to send out various people in my organization. It copies a series of worksheets to a new file, breaks the links, and saves with their name and position number. When I step through this code manually, it works as intended...
  8. L

    List of Names: Extract Address like info into individual row list (eg. Husbands/Wives/Singles)

    I'm sure this has been asked before - if so please direct me. I have Fields: LastName,FirstName,Spouse,Position,Spouse Position It's a list that also includes people that are singles. Just looking for direction how to keep my original list AND elsewhere to have a list that derives and splits...
  9. L

    Vlookup OR Index/Match function with multiple criteria

    <tbody> Employee Name Employee ID Position # Position Status Employee A 111111111 111111 A Employee A 111111111 777777 W Employee B 222222222 222222 A Employee C 333333333 333333 A Employee D 444444444 444444 W Employee D 444444444 555555 A </tbody> Hello there...
  10. 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...
  11. O

    Help - How do I Remove Duplicates

    Hi Master Excel Users. I have a two dimensional cell range of cells say from A1 to P5000 I would like to remove all duplicates within this range but keep the uniques where they currently are sitting, in their current position. Any good way of doing that? Alot of cells are blank within this...
  12. B

    Reverse Match & ISBLANK

    Hi I have {=IFERROR(MATCH(FALSE,ISBLANK(B14:AM14),0),"")} to return the position of the first non-blank cell in that row. What I would like to do is return the position of the last non-blank cell in that row. I tried {=IFERROR(MATCH(FALSE,ISBLANK(AM14:B14),0),"") - that was, of course, far...
  13. C

    Count Unique Values with Multiple Criteria in a Filtered List

    I have a table that tracks positions across multiple companies and years. I want to count the number of unique positions. The difficulty is that the same position title can be with infinite companies (ie. "Associate" is a position at Company A and Company B, etc) There are also multiple...
  14. D

    Match function in reverse direction

    Is it possible to use the MATCH function to find the ordinal position of text, but going up instead of going down. X Y Program A B C Program R S Here In the cell with "Here" in it, I want to be able to find the position of the first time that the word, "Program," appears, but going up instead...
  15. B

    Commence macro from current (not absolute) cursor position

    I should know how to do this, but I don't. When I use Record Macro to create some new VBA code, it records the absolute position - row, column, and sheet name - but I often want a macro to work anywhere from the starting position. See the code below. My goal is to select a set of cells in a...
  16. XL Pro

    Position of a range within another range

    What's the easiest what to determine the position of a range within another range via VBA? In my case, I want to know what column (not the column number) a range falls within another range? For example: Range("C1") in Range("C1:G1") Range("N1") in Range("L1:O1") I would like to know that C1...
  17. M

    Complicated Formula ?

    I have a spreadsheet that lists all of our candidates by name and the corresponding manager. It also includes the position number they are interviewing for. On a separate sheet, I have the position number in cell i7, I'd like $j8 to show the candidates name. If there have been 10 interviews...
  18. M

    Can a macro select items in another macro's UserForm's ListBox ?

    Hello everyone, I have a macro that I wrote that duplicates a selected range at some position in my worksheet. The position is selected based on informations given by the user through an UserForm's ListBox. This macro works well and I would now like to determine its runtime depending on the...
  19. M

    Moving and locking a Comment Box

    I have a comment box that displays in a very bad position on my Excel 2016 Spreadsheet. Even when I move it under the Edit Comment Function, when I hover over the cell, it still displays in the the comment box in the original position. Is there anyway I can lock the comment box in the location...
  20. S

    Vba code to replace and position text box in PowerPoint

    Dear All, The code above replace my font Size and Apart from this I need to align to the below mentioned position . Please help me to incorporate this code Sub changeFont() For Each aSlide In ActivePresentation.Slides For Each aShape In aSlide.Shapes If aShape.Type = msoTextBox Then If...

Some videos you may like

This Week's Hot Topics

Top