single

Heya, im barely great at Excel, and im struggling to develop a formula. I have one sheet that has a Numeric result in ONE cell - S2 The number is ANY value, with ANY decimal point value I need to put a formula in another cell that defines a grade 1-5 based on its value S2's value. *Each Peak /...

I didn't write this and can't remember where it came from. Consists of a Form and a class module. An image file is loaded via the Forms Picture property, and a "handle" on the Form lets you drag the picture to any size. It's brilliant. Except as you drag the picture it flashes and looks awful...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> To get final result in the column K, I am using 2 more formula in the column E & G, please can someone make a single formula in the column K. </SPAN></SPAN> Using example....</SPAN></SPAN>...

Hi, I have a range B2:Y194 of which I need to transponse from a row into a single column in cell A196, How would I go about doing this please?

I have a large sheet with soccer players & the number of goals they have scored each season (each column is 1999-2000, 2001-2002, etc. up to 2019-2020). The players names are often duplicated down about 3500 rows of data. How can I get a single row count of all their goals? For example...

Hi All, The below UDF will make us to identify the positive and negative value if any value is split into multiple values. Example, 100, -50, -50, -800, 200, 200, 200, 200 <tbody> Function Find_num(rng As Range, cell As Range, num_range As Single) </tbody> <tbody> Dim com() As Single, c...

Hello, Text to Delimited text seems to be common, but not the other way around. I have an excel table with thousands of rows, all neatly organized in a rational manner. all cells are used with no spaces. i need to output data into a text file for another computer program's input. It needs to...

Hey all, I have a Userform with textboxes in it. A user can input up to two characters in each. How the values are formatted is dependent on how many characters there are i.e. Empty Textboxes are handled one way, single characters ("A") are handled another and 2 letters ("AB") are handled a...

I have 6 columns (B:G) with 16 rows (2:17) of data in each column. I am trying to get all of the info of the array into one single column starting at cell K4. I have been able to write a loop to go down the rows but I can't seem to get the loops right. Any suggestions?

Dear All, I have a folder named transaction that contains approx 200 excel file. the excel file name is e.g 19875 , 23,456,1450 etc. I want to copy all excel file data in a single excel file one by one. Suppose excel file name 19875 contains data that consist of 30 rows then file name 23 then...

Hi Guys, I need to change a multiple line excel sheet to the a single line sheet. I have the below sheet <colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C J </thead><tbody> 1 Exported On: 16/08/2019 15:40:57 2 #00DC00[/URL]...

Hi We're looking at a basic licensing tool - it's going to be straight forward where someone inputs a licence code (generated from website) which auto populates a single line confirmation. I'm trying to see how I'd add this single line into a excel cell somehow, and then work with the string...

I want to create a recordset that contains only a single result from a larger recordset, how can I do this? I have a recursive algorithm that calls itself many times, passing a single record in, and getting a new set of results where one entry will be used in the next step and then passed on...

Hello, Is there a way for one single cell to share both text and a hyperlink? For example, I want a cell that describes something, and then after the description, I'd like there to be a hyperlink that would access a webpage extending the topic? So the text body is separate from the hyperlink...

I need the leading 0 in the single months. I have 1/01/2019 and want it to be 01/01/2019.

Looking for a method to produce side by side list either double triple or quad I have a csv list from an external source for example containing in date order Date,type,item,count To save paper either in portrait have two lists from source Sourcerow1, sourcerow2 Sourcerow3, sourcerow4 And so...

Hello All, I am trying to create a survey that results in a priority. Here's the detail. I have 10 questions, each answer is to be entered as a number (0 = no, 1 = not sure/maybe and 2 = yes) After answering them all, I have the total in a cell, lets call it B13, which will be anything from 0...

Hi. I have a file with data on two separate worksheets. They need to stay on separate worksheets. But I need to print both worksheets on a single page, without scaling either. They're not large, they will both fit onto a single sheet without scaling. I did an internet search, my friend...

I am looking for a way to check if the user has selected a single cell or single row within a Listobject. If this is the case, then I would like to return the value from Column 1 of the Listobject for the particular row. Not sure how to start with this one. any help is much appreciated. many...

I have an spreadsheet that summarizes various documents and includes the file path to each document. I have created a mail merge that creates a document summary page for each document based on the data in the spreadsheet. What I would like to do next is generate a single PDF that places the...