single cell

  1. S

    Storing an array of dates into single cell

    Hello, I am trying to store multiple dates in a single cell as an array, similar to ={1,2,3} and due to the structure of my table I can't use more than one cell for the content of the array. The dates are formatted like this: 14-9-2018 14:00 (d-m-yyyy hh:mm) I can't store the dates as text...
  2. N

    Delete data in a single cell

    I have what should be a simple problem but I have been racking my brain trying to figure out what I am doing wrong. I collect data using a wireless device that sends a signal to the PC and thus into Excel. Once the number is populated into a cell, it automatically moves to the next cell to the...
  3. R

    Return values from string that match defined range within a single cell

    How can I search through a string and return only the values that are in a defined named range within a singe cell? Ex: assume cell A1 contains the string "blue_yellow_red_orange". However, I want cell B2 to return only those substrings that are present in my named range "Colors", which contains...
  4. 2

    From column to single cell

    Hello Friends, Could you please help with VBA code for doing following: 1) Read list of values in a single column 2) Enter all those values delimited by semi colon in to another single cell. For example following Input values in Column A Input Values (Heading) 100 200 300 400 Will appear in...
  5. C

    Cell with comma seperated values and vlookup

    1st table/report has cells with single values as well as multiple values separated by comma. <tbody> Identifier AA XY,AA,YX BE RE,WX,EW,XT AB,ER, </tbody> if any of the values in the cell is there in the 2nd table I need to filter the 1st report. 2nd table/report <tbody>...
  6. J

    Removing Duplicates in a single cell with multiple separator

    Hi I'm having a helluva time with excel since I remove duplicates from 33k row of entries from column A to P Now I came across an issue, I need to merge multiple address in a single file row how ever each entry have multiple name, I need help in removing those multiple names after merging...
  7. A

    Prevent Duplicate Entries in Single Cells from UserForm with Embedded ListBox - time sensitive

    Hi All, I have scourged the internet to no avail. I am trying to do something that seems very simple: I am using a multiple selection listbox which is embedded into a UserForm. (It is a check-all-that-apply form linked to a DV list). All I would like to accomplish is a way to prevent duplicate...
  8. C

    Multi selection to a single cell and in a combined cell

    I need for my multi selection in the data validation list box to populate in the columns to the right in a single cell and still continuing to populating in the same cell. Below is my code any help is appreciated. Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal...
  9. N

    Multiple indent levels in a single cell

    Hi there, I'm looking to create multiple levels of indent in a single Excel cell, as a way of displaying hierarchy of information. Here's the situation: I'm currently preparing a list of files and am using an Excel spreadsheet to keep track of each file. Each line in my spreadsheet is a...
  10. T

    Conditional Format each row based of a cell at the end of each row

    I am trying to conditional format each individual row, based on a checkbox value (True or False) at the end of each row. For the first row (row #2), I linked the checkbox to cell (o2) o2 reads (True or False), depending whether the box is checked or not. I selected the portion of the row that...
  11. I

    Within single cell, return text value from between 2 consistent known border values

    Hello, everyone. My first post/question. Thank you in advance for the help. I need to determine unique company names from within a list of clients, 12,000+. There are numerous variations on how the company names are presented. I don't feel like trying in Excel to go after disambiguating...
  12. K

    Match index & concatenate help!!

    Hello All, So I want to return a text value based on 4 criteria. I can do this with the Index Match function, however I want to concatenate ALL text values found in the column that match the 4 criteria into a single cell seperated by "; ". I desperately need help on this! The data would look...
  13. K

    Need to Concatenate Array with Index, Match function so all text values show in SINGLE cell

    Hi All, I'm beyond frustrated trying to get multiple text values to appear in single cell. This is the formula I have at the moment and the goal is to return the audit name, which it will do but only if all conditions are met and for one single audit name. =INDEX('Master Audit-IR...
  14. M

    Store and retrieve multiple values in one cell

    Thought I'd share this. I have been looking for a way to store multiple values in a single cell while having that cell's value be and display the first, or primary value. I found a lot of ideas that just didn't work but I finally came up with my own that does. In the VBE add a module and creat...
  15. R

    Combining multiple text cells into dedicated single cell, and inserting line break to separate text bulk in the dedicated single cell?

    Hello, I need to combine multiple product description texts which are in their own cells into a one single dedicated overall description cell which will encompass all the bulk texts from those separate cells, however not make all the text flow in single string without line breaks. Required...
  16. H

    Adding 2 numbers in the same cell to another defined by a word

    Hi guys. I'm really sorry if this question is a common one, and is already answered on the forums. I don't know how to word my question properly in order to make use of search features. The question: In Cell A I have "+1 Bananas / -1/2 apples" in cell B I have " -1/2 Bananas / +3 apples" I...
  17. R

    Timestamp with VBA when pasting new data into cells

    Hi All, I've been searching online for this solution for a while, and while there are a lot of discussions out there, none of them seem to fit exactly what I'm trying to do. I'm an Excel 2010 user, and have only used VBA for the most basic functions (ie, I copy and paste VBA language!). I'm...
  18. C

    Max,Min, & Avg of multiple numbers in a single cell

    Here is my excel example data: Cell A1 = 26,4,12 Cell A2 = 4,4,5 Cell A3 = 0,3,3,3,6,5 I'm trying to get the following results... for MAX: B1 = 26 B2 = 5 B3 = 6 for MIN: C1 = 4 C2 = 4 C3 = 0 for AVERAGE: D1 = 14 D2 = 4.3333 D3 = 3.3333 the number of integers in each cell is variable I've...
  19. Z

    need help in generating formula by extracting text and then looking up the value both present in a single cell

    I have a column as named particulars below and my requirements are in columns ahead...plz someone can give me a solution.. Would be grateful…thanks in advance. <tbody> Particulars Look up fields from the column 1 End result required for individual look up...
  20. P

    Unique Values from a single cell

    Hi, I have a single cell comprising A|B|C| A. How do i get the unique values? Also please let me know if there is a chance to count the variables. Thanks. I badly need a excel function to sort this out.

Some videos you may like

This Week's Hot Topics

Top