3rd

hi all new to forum & excel need help with automatically have reference from one sheet to another, i already have the item copying over the information from one sheet to another. my problem is i would like to add to the database & have this automatically go over to another sheet including any...

Hi all, I am using a UDF from njimack to achieve the following result in Excel 2013. <tbody> Column 1 Column 2 Column 3 Formula result 1st 2nd 3rd 1st, 2nd, 3rd 3rd 3rd </tbody> This is his code.Function Concatenate_Range(myrange As Range, Optional myDelimiter As String)Dim Cell...

I've searched and found some things that are similar, but not exactly what I want (i.e. Index/Match). I want to look up the 1st largest value and return what is in column A. I'm then repeating for the 2nd, 3rd, etc. If I had a formula for the 2d largest I can figure out the other nth Largest...

I've searched Google but not able to find this answer because I don't think I entered the correct search verbiage. Does one need to have a complicated VBA in order for me to do what I want? I want to give points to each category where the player is ranked then ranked from lowest. Example. Ty...

Hello! I have several worksheets on one file. The third worksheet is called <letter P + some number>, e.g. 'P27' or 'P138'. The first two sheets have very different names. What would be the VBA code to: 1. Add a new THIRD worksheet - i.e., right before the current third sheet 2. Name it <P +...

I need help setting up a spreadsheet that will arrange times, places, and divisions automatically if possible. To explain, each D is different. In a 4D format, The 1D needs to be the quickest time then the 2D is .5 Seconds off the quickest time. The 3D is 1.0 off the quickest time and the 4D is...

I need help setting up a spreadsheet that will arrange times, places, and divisions automatically if possible. To explain, each D is different. In a 4D format, The 1D needs to be the quickest time then the 2D is .5 Seconds off the quickest time. The 3D is 1.0 off the quickest time and the 4D is...

Hi Everyone, So attached is a sample logbook. In the Dashboard TAB I need to know what date my 3rd to last landing was on each type of aircraft. In Cell 'AG5:AH17 it needs to display the date plus 90 days. So for example 8 nov 17 was my 3rd to last landing in a DA42 at night. So i would become...

<tbody> A B C D E F G 1 2 1ST 2ND 3RD 4TH 5TH 3 -89.8 -89.8 -89.6 -35.2 -7.4 -15.5 4 22.4 -89.8 -89.6 -35.2 -7.4 -15.5 5 52.3 -89.8 -89.6 -35.2 -7.4 -15.5 6 1 -89.8 -89.6 -35.2 -7.4 -15.5 7 -89.6 -89.6 -35.2 -7.4 -15.5 -13.8 8 -35.2 9 -7.4 10 -15.5...

I'm trying to work out a formula for ranking but the data i need to rank contains a ton of ties. basically i have a 3 way tie for 1st, a 11 way tie for 2nd, a 8 way tie for 3rd, a 9 way tie for 4th, etc and its making my ranking look confusing. rather than the 4th place rank showing as "4"...

Hi all, this is my first post so please go easy :) I have a Speedway grand prix sheet i have put together with basic formulas. Not happy with that i have tried to go a bit further and have now gotten out of my comfort zone. As u can see from the sheet the AC column totals up the riders score...

Hi Is there anyway to filter blank cells. I google it and found the solution below which I think it is a 3rd party ad-on. Thank you. https://www.extendoffice.com/documents/excel/3689-excel-filter-include-blank-rows.html

I am trying to complie a number of spreadsheets containing dates of appointments, unfortunately one of the spreadsheets the person has enter the date as 3rd Dec 2016 instead of 03/12/16. How can i convert it please. thank you in advance.

Hi, I have two Ranked Columns Example: A B 1 3 2 4 3 1 4 1 5 5 6 1 7 2 I need to search COLUMN "B" For Highest Rank, and then once that is found, I need to have it tell me which of those have the highest rank in Column "A".... So in this instance, it would...

Hi, I have a file with a few thousand address fields which I want to covert to proper case , using =Proper(A2). However, I don't want to manually fix things like : <colgroup><col width="227" style="width: 171pt; mso-width-source: userset; mso-width-alt: 6715;"> <col width="184"...

Hi Guys, I need your help with an excel sheet (File Links below). https://ufile.io/qois1 or https://files.fm/u/wmmtttcc In column "C” I am trying to get 2nd, 3rd and 4th character/number if the Name is starting with "0". If it is not starting with "0" then i need the first 4 characters...

In rows at the top (B1 - G1) I have six team names (text). In the columns below B1 - G1 I have their scores. The scores are cumulative so a summed total occurs in B39 to G39. I want to print on a separate sheet the current highest score in the form of a leaderboard. Here is an example...

Hi there, I am trying to count entries in every 3rd column, but it is not a SUM - I have date columns every 3rd column and I need to know how many of them are completed - there is other information in the other columns but I don't want to include that in the count - can someone please help...

This is a nightmare... How are you supposed to fit text of a unknown length into a listbox control and see it all ? There's no autowidth, or multiline etc. Or am I wrong? I see a suggestion to use a listview control and will try that. Or perhaps a 3rd party control you pay for? But does that...

Hi, I am trying to #1 ) highlight the top 3 values in cell range $B$3:$B$22 and #2 ) Red = the 1st best value, Green = 2nd best value and Yellow would be 3rd best value. I am stuck. I tried the Conditional Formatting menu and am completely confused. Please help! :)