single

  1. J

    Return single number value based on range

    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 /...
  2. A

    Stop picture flashing as resized.

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

    Help, required single formula, instead of using 3

    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> <b></b><table cellpadding="2.5px" rules="all"...
  4. B

    Transpose Multiple Rows into single column

    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?
  5. G

    How to combine totals for a sheet with multiple entries for the same thing

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

    How to modify UDF into VBA Macro

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

    The opposite: Delimited to formatted text

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

    If/Then statements with three outcomes

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

    2d array pasting into single column

    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?
  10. A

    How to read approx 200 excel file in a single excel sheet one by one.

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

    Changing Multiple Lines to Single Lines

    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]...
  12. P

    Scrape details from generated webpage

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

    extract single record from recordset

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

    Tex & Hyperlinks Sharing Single Cell?

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

    Trying to convert m/dd/yyyy to mm/dd/yyyy

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

    Create side by side report from single list non vba with criteria

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

    Priority Formula help

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

    Print data from two worksheets onto one page

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

    Check is a single row in Listobject is selected

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

    Mail Merge that inserts a pdf between merged pages

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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top