3rd

  1. S

    F8 not working as it should?

    Hi While using excel today i noticed that when i use F8 to select cells, it selects the first two as i press the down down arrow key and if i press it a third it disengages and then only highlights the 3rd cell. I can still do it using a mouse but not using the keyboard. This is a normal...
  2. R

    Return result for 1st, 2nd, and 3rd Row

    Hi Everyone, I'm a bit stumped on a formula I'm building. I am trying to return the close date for the 1st, 2nd, and 3rd Sales deal for all of my sales reps. I built out the following formula, which works if the sales rep has actually closed 3 deals. However, if the sales rep only closed 1...
  3. D

    if function problem need solving

    Dear Pros, Please help me with 1 function that can determine whether there is any gap by item name. example1: For itemA, "Cell E1" will show "No Gap" if b1,c1,d1 all are"No Gap" example2: For itemA, "Cell E1" will show "Gap to 1st" when b1 ="Gap to 1st" while C1 and D1 ="No Gap" example3...
  4. M

    How do I Make a 3 bar chart in excel?

    Hi, I am making a bar chart in excel and I currently have it as a 2 bar chart, but I could really use a 3rd bar. I do not see an choice for a 3 bar..is this do-able in excel??
  5. E

    Excel formula to populate value based on ascending date where values may have same dates

    Hi All, I have a table of data that contains ~600k rows (1 per customer) with a list of dates that they have purchased their first product. Example of the data is per blue text in table below. Im trying to figure out an Excel Formula that will populate the values in red text. I had a formula...
  6. A

    Formula for yielding 1st and 3rd Sunday of every month and every Friday.

    I need a formula to find the dates for the 1st and 3rd Sunday of every month, and a formula for finding the date for every Friday for every month. So I can input the month in A1 and get the results in another cell. Thank You
  7. P

    Last Month

    Any good way to get Last Month as a month number using today's date? Previously I've done =NOW()-32 and that seems to work, but without figuring it out you could run into a day in a month where this fails? Like the first day of the month would take you back 2 months until you hit the 2nd or 3rd...
  8. M

    sort and filter for userform listbox

    I am sorting worksheet by 2 columns alphabetically then filtering by a 3rd which is required to be “Yes”. Works fine on worksheet but list box on user form returns all records regardless of 3rd column - could be blank or ‘No’. Userform containing List box is based on sorted and filtered...
  9. R

    Populate a column with the dates of 1st, 3rd and 5th Mondays between two dates...

    How to create a list of dates of every 1st, 3rd, 5th Monday each month between two dates? I have in cell A2 (01 Jul 19) the first date and in B2 (30 Jun 20) the second date. How do I populate column C with the dates of every 1st, 3rd, 5th Monday each month between 01 Jul 19 and 30 Jun 20...
  10. L

    VBA - How to invert/sort line breaks within a cell

    Guys, how can we change the line breaks order within a cell? For instance, in my cell I have the values: A1 Cell <tbody> 1st Comment 2nd Comment 3rd Comment </tbody> I want to invert to: <tbody> 3rd Comment 2nd Comment 1st Comment </tbody> For a more complex case, how to Sort based on...
  11. Z

    VBA - WorksheetFunction.Small with conditions??

    Hi, Column A consists names, and Column B consists numbers. How can I find 3rd lowest value from column B, where column A contains "John" ?
  12. M

    Requesting Formula Help

    Hello, I have a table with 2 columns (Schedule, Item) of data and I would like to create a formula under the 3rd column using under the criteria below. Criteria : If Column A (Schedule) shows "Yes" and if there are multiple occurrences of the same value on Column B (Item) that satisfies the...
  13. M

    Calculating exact shift times and rates per shift.

    Hello, I am trying to find a couple formulas to extract the amount of hours worked on each shift. Time is entered beginning and end of a shift and may include a portion of all 3 shifts. 1st shift is 6am - 2pm, 2nd shift is 2pm - 10pm, 3rd shift is 10pm - 6am. Example if I punch in at 5:45pm and...
  14. A

    Finding data position in table

    Hello, can anybody help me with a solution to my problem. I receive a data set from a 3rd party that i have no control over the formatting of. I have my own sheet with various formulas that refer to data in the 3rd party sheet however the producer of the original sheet regularly changes the...
  15. R

    Return 2nd Last Value in Dynamic Range

    Hello Column DY in sheet Data W1 is populated by a number in the following row each minute by a third party program. I would like a formula to return the second last value in the column and thought the following would work but it actually returns the 3rd last value. Can anyone see where I'm...
  16. E

    3rd Friday of next month

    Does anyone know how to determine the date of the 3rd friday of next month, based on today's date? Meaning, if I have today's date in A1, and in B1 I want to have the date of the 3rd Friday of next month, how would I do it? Let's assume today's date is 4/26/19 TY
  17. R

    Unique Password Protect PDF (by batch), using excel VBA without 3rd Party program

    Dears, i have searching all over, but couldn't find this answer. i need to automate protect PDF each will have unique password. all in googles refer to install 3rd party, but that applied 1 password for all. then read this...
  18. S

    Getting Week As 1st week , 2nd week 3rd week or 4th Week of a particular Date in a month

    Hello How can i get the week defined as 1st week ,2nd week , 3rd week and 4th week of a particular date which falls in Particular Month For eg if i enter 01-Feb-2019 ie in dd-mmm-yyyy then in next adjacent cell to display as 1st Week of Feb 19 14-Jan-2019 to be...
  19. J

    Excel Table and Vlookup

    <tbody> SubCat Service Category Subcateory Subcategory Description Incident Type tbl3rdPartyAcces Access Management 3rd Party Access Disable 3rd party access =VLOOKUP([@Subcategory][@SubCat],2,FALSE) =VLOOKUP([@Subcategory][@SubCat]3,FALSE) tblDeviceEncryption Access...
  20. S

    SUM of COUNTIF with multiple criteria

    hi all... can I ask for some help with this please? i've got 2 worksheets a I trying to pull data from them and summarise it into a 3rd worksheet. my worksheets contain information relating to orders placed before and after specific dates. I need to have my 3rd worksheet check through a list...

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