3rd

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

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

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

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

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

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

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

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

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

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

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" ?

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

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

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

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

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

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

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

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

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