1. G

    Light bulbs replacement : formula

    Hello everyone, This is a very practical exercise that I am trying to do since a little while but without any success. I defined 2 informations for light bulbs : - The 1st time it is likely to burn and be replaced : For example after 2.5 years or after 0.3 year - The life time of a bulb : For...
  2. L

    What is the easiest way to tabulate multi cell patterns?

    I have searched but all answers seem to be regarding searching within a string or within a single cell.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’m using Excel 2010. Here’s my problem. I have a column of numbers (about 25,000 long) as shown...
  3. P

    complete missing values within a sequence

    Hi all, I have blanks in a sequence.. 2.2 blank blank blank 8.43 10.98 How can I fill in the blanks to complete a growth curve? Many thanks
  4. A

    How to generate a sequence of numbers in excel where the last number is constant?

    For example, How you generate the below automatically, without physically typing it out? Thank you
  5. K

    Match sequence with existing table

    Hi experts, I wonder if it is possible to insert two columns beside an existing table with matching sequence i.e. <table border="0" cellpadding="0" cellspacing="0" width="512"><colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17">...
  6. E

    reusing code for different userfroms

    I am a newbe. I have created 4 userforms to input seminar evaluation data for each of the 4 periods. Each UF has directly coded outputs to specific cells in 8 columns. I believe I could put the identical events into a module and call it up for each UF but I don't know how to get the option...
  7. J

    insert rows between sequence gaps

    I recently found a thread with the same name (, and two people had posted codes which were said to insert rows between sequence gaps, i.e. making 1,2,4,5 : 1,2,3,4,5 in column b (for example), but when I have tried using the codes, neither...
  8. F

    Adding Sequences

    Hi Everyone, I have a toughy here. I have to indictate the contact in sequence thats taken place. I have sort the data by data and contact number. Now I just need to add the contact seqence in another cell. This is an example of what I am looking for below. <TABLE style="WIDTH: 175pt...
  9. M

    Number sequence macro help

    I am extremely new to the whole macro thing. I dont understand much about it yet and I am just learning. I want to know if it is possible to create a macro that will generate the next number in sequence. So say between cells A2 and A500 I want a way to make it find the next number available that...
  10. B

    Apply Conditional Formatting in sequence

    I am trying to figure out if there is a way to apply multiple conditional formats in sequence in Excel. I have a series of numbers (bids) listed in columns. Each column corresponds to a specific company, each row (700 of them) is a manufacturing product with price bidding from each company. I...
  11. G

    Help with Query

    What I want to do with my data is a little beyond my knowledge base so I'm hoping someone can help me. I want to do an analysis on an existing database of data which will tell me the sequence of products ordered for the whole database. The database order section is set up with the following...
  12. B

    Dates out of sequence in pivot table

    Hello I'm facing a strange issue where excel is placing dates out of sequence. I have a table of ~300 records. On a different worksheet, I have a pivot table referencing the table with row labels being the day, month and year of the records. For about a year (records start in July 2009)...
  13. E

    Find positions in a main sequence not covered by internal sequence

    Dear Mr Excel, I have a dna sequence, one word of 10 letters (aattggccaa) Furthermore I have two columns; the start and end position of a number of internal sequences within the main sequence shown above. Ex 2 5 means the sequence from 2 to 5 (attg) 6 6 means the 6th position (g) I need...
  14. D

    creating a sequence from a list of codes and values

    I'm trying to write some VBA code to do the following (don't think its possible using formulas only). In column A i have a list of codes (A1:A32) in column B i have a value (between 1 and 32 in this case, but feasibly could be any integer) I am trying to achive an output in column C which would...
  15. Futile Crush

    Sequences in Excel - The Nth Term

    Hey guys. I'm new to the Mr Excel message board, I just came out because I had a question that interested me. Sequences. Those lovely little chains going up by a certain number, like 1, 2, 3, 4 ... or 2, 4, 6, 8 ... or 5, 3, 1, -1 ... they have a common term that dictates the sequence. For...
  16. P

    Sequential numbering NON VBA or ARRAY FORMULA

    I am trying to build a sequential list without the use of either VBA or ARRAY Formulas. The example below uses Array Formula, but I have used this to demonstrate what I am trying to achieve. Column B - List Ref is a random entry of numbers Column C will define the Point reference, associated...
  17. E

    sequential numbering

    Excel 2008 - Windows XP I am trying to get sequential numbers in column B based off values in column A. Here is an example of what I would like to see in column B. <table style="border-collapse: collapse; width: 102pt;" width="136" border="0" cellpadding="0" cellspacing="0"><col style="width...

Some videos you may like

This Week's Hot Topics