Search:

Type: Posts; User: jha900; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. someone told me you need too use Latin Square...

    someone told me you need too use Latin Square formulas. Don't know what those are
  2. 12 unique combinations in Excel with random-ness

    Hello - I need a way to take numbers 1 through 12 and make 12 different "sets" where each number is in a different position of the "set".

    That probably doesn't make sense so i've attached a...
  3. Add parens to first 3 numbers of phone number

    Hello - I have an excel file with a column of phone numbers. They are formatted 000-000-0000. I need them to have parens around the area code (000) 000-0000. I haven't found a way to do this by using...
  4. Excel formula or macro for string of numbers

    Hello - I have a sheet (before) that has a list of numbers. I need it to look like the after sheet.

    The numbers in COL A have a .1 and/or a .2. There are usually a pair of numbers like 5.1 and...
  5. Excel formula or formatting to change number

    I have a column of numbers like



    42,045,532


    42,086,369
  6. I have about 20 charts on 7 different sheets that...

    I have about 20 charts on 7 different sheets that reference the 2011DataPull worksheet within the same excel file. I need to change them all to reference a new worksheet (but the exact same ranges)...
  7. I've tried Alt-F9 keys but nothing happens. When...

    I've tried Alt-F9 keys but nothing happens. When I use Replace and enter 2011DataPull for find and enter 2012DataPull in the replace box and I select workbook, it doesn't search within the data...
  8. Need Excel VBA to cycle through chart objects and change data source

    Hello - I have an Excel 2010 file that has several worksheets in it. Each worksheet has several bar, pie or column charts on them with the data source being the 2011DataPull worksheet. I need a macro...
  9. wow :o: fantastic

    wow :o:
    fantastic
  10. Formula to find highest number in single cell

    Hello - How would I write a formula in excel to return a 5 (the highest number in the cell) from a single cell that contains the following...

    Simple - 1
    Freak - 5
    Hi - 3
    Mill : 3

    Thank you...
  11. Concatenate macro to make whole number and cap letter

    Hello - I need to iterate through a range of cells - B5:P24 and compare them to B30:B48. If B5 matches B30 then any capital letters in columns C to P, row 30 need to be concatenated with the number...
  12. Replies
    2
    Views
    694

    Return column containing number 1

    I have an excel file with 5 columns A1:E1 and 100 rows. Each row has numbers 1 to 5.
    I need a formula in F1 that will return the column that has the number 1 in it. So in the example below, I need...
  13. Replies
    1
    Views
    1,853

    Excel charts data-point property for border

    I can't find the vba property in Excel 2007/Excel 2010 to put a black thin border around a data point in a chart. I can fill it (highlight it in yellow), but i can't find the property for a black...
  14. Replies
    1
    Views
    37,342

    Powerpoint 2010 - where is update link

    For the life of me i can't find where to change my links to Excel charts in my powerpoint 2010 file. It used to be in "prepare" in ppt 2007, now i can't find it. I have a ppt 2010 document that has...
  15. Replies
    7
    Views
    1,705

    Countif formula to count number in a range

    I have a column of numbers and need to count how many 1's, 2's, 3's occur. I've tried =countif(a1:a6,"1*") as an array formula but don't get the correct answer.

    135
    2345
    12345
    234
    45
    145
  16. I'm wondering how to do the same thing. Did you...

    I'm wondering how to do the same thing. Did you ever find out? Thanks
  17. Replies
    1
    Views
    732

    I am trying to make the percentages in 14 point...

    I am trying to make the percentages in 14 point and the letters next to them in 12 point in the 2 charts attached. Actually, it's not just the 2 charts, i'd like to have a macro that could go through...
  18. Replies
    1
    Views
    1,649

    Hello - I have an existing chart in ppt 2007...

    Hello - I have an existing chart in ppt 2007 (sp2), i double-click on it and Excel opens. I make some changes on the worksheet and then click outside the object. The ppt object now clips the last...
  19. Replies
    4
    Views
    6,602

    I have an Excel file with a column of whole...

    I have an Excel file with a column of whole numbers. I need them to have 2 decimals like 275.00, no dollar sign. I formatted the column with currency no $. But when I convert the file to a csv, it...
  20. Replies
    3
    Views
    6,120

    Works great! Many Thanks

    Works great! Many Thanks
  21. Replies
    3
    Views
    6,120

    Is it possible to make a snake graph like the...

    Is it possible to make a snake graph like the attached in Excel 2003?

    Thanks for the help.
  22. Replies
    4
    Views
    573

    Sorry, I'm not quite sure how to use this...

    Sorry, I'm not quite sure how to use this formula. I'm uploading a file and put the trigger cell in A1. The formula is in F3. Thank you for the help.
  23. Replies
    4
    Views
    573

    I have a set of data... Trigger cell Total...

    I have a set of data...

    Trigger cell Total Rank Rank Males Rank Females
    Concept 1 3 4 1
    Concept 2 2 2 2
    Concept 3 4 ...
  24. Replies
    5
    Views
    736

    ok, thanks for the explanation. Now, I have...

    ok, thanks for the explanation.

    Now, I have the max formula working and then i tried to copy it to the next row and change max to MIN. The help screen says to use the fx bar but it doesn't show...
  25. Replies
    5
    Views
    736

    thanks for the formula Hans. Does the "*" between...

    thanks for the formula Hans. Does the "*" between the 2 criteria mean "and", is there an "or" operator?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4