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

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

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

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

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

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

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.

I am trying to make an action house profit calculator for a game and I have all the data setup correctly to calculate profits and auto update values when new information is put in into the material cost page. I want to have the data updated from a website either automatically or when i manually...

Hello :) I have been looking through the forums to find an answer to my query and I seem to be close but don't know what I need to do next. I have found this post which sums numbers in a comma delimited text string and modified it to count using Chr(10) as the delimiter...

Hi there, The task is to embed a pdf file into a workbook. I need to be able to click on the "pdf.name" inside the cell and open the pdf file. Such pdf file does not have to be saved in another location in the computer. I appreciate your help.

I need a formula that will calculate the average from a list of numbers in a single cell. These numbers are entered as individual percent values, and separated by commas. An example would be: A1 = [55%, 60%, 7%, 92%] For the above example list, the formula I require would spit out 54%...

Hi All, I am using excel as a scheduling program. The sheet has days of the month across the top, and staff names down the column. We have 5 shifts D,A,B,C,N. I am using the following formula to display if shifts have been scheduled for the column if(countifB10:N23,"N")=1,"X","N") i.e for the...

i want to find duplicate words from a single cell... <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> examle data cell say (A1): <o:p></o:p> At last night came, and she went to bed, but still she would not take off her sun-bonnet, for fear of losing the...

So...I know I'm a noob, but I feel like I shouldn't be having so much trouble with this! I have two columns, one with a longish string, and the other with an ID number. I basically just want to know whether or not the string in the first column contains a specific phrase. For example: <TABLE...

Hi, I am new to excel and trying to develop a Daily Status report. I am trying to figure out how to have the date and time update automatically when I open the excell sheet in one specific cell, not a colum or row, is this possible? thank you. :confused:

Hi Everyone, I'm trying to calculate the commission for work and I'm getting Really long formulas. it works like this Excel WorkbookIJKLMN77*IF****78*GPIF***79*0.25 on the total valueGPIF**80**0.25 on 300000GP>500000* * * * * * * *240,000.00*81**+ 0.3 on the difference0.25 on 300000* * * * *...

Hi everyone, I have found a few postings on looking up multiple values using a vlookup but my request is a bit different. For this example, let's say I am selling something called "Seasonal Gift Basket." In an area of my worksheet I have all the individual SKU's that make up the current...