Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chasethewind

    Add leading zero to number in text string

    Thanks Judgeh59, that was exactly what I was after. Solved
  2. chasethewind

    Add leading zero to number in text string

    That wouldn't return the correct value on some cases. I would end up with "N032^45'E on N32^45'E
  3. chasethewind

    Add leading zero to number in text string

    I'm looking for an easy solution to add a leading zero to a text string in excel 2010. There is the text string: N5^43'W it should say N05^43'W or S6^7'E should say S06^07'E Thanks
  4. chasethewind

    Import specific data based on value from text file

    Hello, I'm not sure where I should start. I want to import only some of the values (based on a given value) from a comma delimited text file to an Excel 2007 sheet. The reason is I have over 1.5 million rows of data and Excel can only handle a little over 1 million rows.
  5. chasethewind

    COMBINE ALL VALUES IN COLUMN INTO ONE CELL

    Excel 2007
  6. chasethewind

    COMBINE ALL VALUES IN COLUMN INTO ONE CELL

    I only leared about the function the other day. Can you use this function with a range? Like A1 through A200? I can easily use it with a few cells, but not 200. =Concatenate(A1:A200) did not work for me.
  7. chasethewind

    COMBINE ALL VALUES IN COLUMN INTO ONE CELL

    Great. Looks like it is going to work. Thank you.
  8. chasethewind

    COMBINE ALL VALUES IN COLUMN INTO ONE CELL

    I cannot figure this out. In column A 100 1001 324 542 562 And would like to place in B1 100, 1001, 324, 542, 562 Any help would be appriciated.
  9. chasethewind

    List of values from multiple columns

    Fantastic! I must have been typing while you where posting. Your formulas are exactly what is needed. Thank you for helping Skip. Cory,
  10. chasethewind

    List of values from multiple columns

    Patience, I will try to expain the situation differently I have 3 column with numbers in them. I want to take the column A values place them in (lets say in column D), then I want to take the values from Column B and append them to the results (values from column A) in column D, take the...
  11. chasethewind

    List of values from multiple columns

    I think "Skip" helped me with formula and it works great to sort the data, but "Small" is what needs changed now. I do not know what to use to not sort from smallest to largest. =IF(ROW(Q5)>COUNT(Q$6:S$194),NA(),SMALL(IF(ISNUMBER(Q$6:S$194),Q$6:S$194,""),ROW(Q5))) Thanks
  12. chasethewind

    List of values from multiple columns

    Sorry for the confusion. I have looked everywhere and cannot find a solution to my problem. This would seem like an easy task (possible already a command in Excel). No sorting. 3 4 9 23 14 8 14 32 6 9 12 15 ...
  13. chasethewind

    List of values from multiple columns

    Sorry... Excel 2007
  14. chasethewind

    List of values from multiple columns

    No macros either.
  15. chasethewind

    List of values from multiple columns

    How do I create a sequential list from the values shown? The NA's will have generate a number as well if a condition is met elsewhere. I need to keep the NA's (just because). Thanks Cory Column A Column B Column C 3 8 6 4 14 9...
  16. chasethewind

    Hyperlink Increment

    It works to get the increment of the pic name, but it will not recognize the correct incremental hyperlink file. I have found a macro that does what I want, but I was wondering if something like you suggested was possible. Credit given for macro to whomever wrote it. I don't remember what web...
  17. chasethewind

    Hyperlink Increment

    I have about 200 hyperlinks to make. The file name is is pic1.jpg, pic2.jpg, etc... is there a way to have the hyperlink automatically increment to the next pic number?
  18. chasethewind

    Create a list of values from multiple columns

    I placed the N/A there because my chart would recognize "" as a zero value. If I placed a N/A it would not. I will monkey with it some more. Thanks, My technical level in this stuff >>> "Script Baby
  19. chasethewind

    Create a list of values from multiple columns

    Yes I do get the same results. I thought it wasn't working because of the errors. I guess I will try to deal with the #nums . Thanks for all the help. I couldn't even do this before, so coodo's to progress. The n/a error is not recognized in my chart. Guess I will ask. Is there a way to...
  20. chasethewind

    Create a list of values from multiple columns

    It refuses to work. I have Column B,C,D and needs to show up in "A". I double checked the formula syntax and it doesn't seem to like it. I tried to switch the "True" and "False" result, but that didn't work. A formula is producing the #N/A values, otherwise it would result in incorrect...

Part and Inventory Search

Back
Top