Search:

Type: Posts; User: Mr. Snrub; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. What is the quickest way to Paste Values by Transpose without using the mouse?

    Is there a keyboard shortcut to paste Values with Transpose?
  2. Replies
    6
    Views
    302

    Re: How do I get the Stocks data type?

    UPDATE! My IT administrator just updated all of our versions of Excel, and now I've got "Microsoft Excel for Office 365 MSO (16.0.11328.20362) 32-bit", and now I have Stocks in the Data tab!!!!! Woo...
  3. Replies
    6
    Views
    302

    Re: How do I get the Stocks data type?

    So, is "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit" the right version or not? There does not appear to be a date associated with it.

    ETA: I am using Office for PC.
  4. Replies
    6
    Views
    302

    How do I get the Stocks data type?

    I don't see "Stocks" on the Data menu. I understand that the Stocks data type is only available to Office 365. I'm not 100% sure if
    I'm running Office 365 or not. I go to File --> Account --> About...
  5. Is there a way to have “accented” columns in an Excel table?

    I have a column in an Excel table that I want to draw the user’s attention to. I know I can select the column and change the Fill color, but that’s only one solid color, I would prefer alternating...
  6. Need help creating a 401k stock database in Excel.

    I am creating an Excel database of my 401k stock portfolio. I have the following tables (all formatted as Excel tables):

    /* All the different stocks that are available to invest. */
    Funds...
  7. Creating a chart: Chart Data Range v. Series1, Series2, Series3 data ranges?

    When selecting Source Data for a chart in Excel there's a "Chart Data Range" field. But in the "Legend Entries (Series)" there are also one or more series ranges. What is the point of the "Chart Data...
  8. Is there an alternative to SUMIFS for my example?

    I have a "Data" Excel table that i need to have columns summed up with multiple criteria and presented on two "Summary" Excel tables.

    "DataTable" Table:

    <table>
    <tr>
    <th>Date</th>...
  9. Re: Do a VLOOKUP between two dates, and then return a corresponding value?

    I figured it out by just using the regular LOOKUP function since the dates were sorted. By the way, how did you get that Excel spreadsheet in your post? That looks much better than my HTML table tags.
  10. Do a VLOOKUP between two dates, and then return a corresponding value?

    I am using Excel 2016. I have a table with three columns: "Start Date", "End Date", and "Season". The table looks as follows:
    <p>
    <table>
    <tr>
    <th>Start Date</th>
    <th>End Date</th>...
  11. When I autofill a cell in my table it is filling the background color too. How do I stop this?

    I have an Excel table formatted as a table. It has a light-blue table style (alternating light-blue/white rows). When I autofill a cell down through the entire column the light-blue background gets...
  12. Can I copy-and-paste old data from my table into a values-only table, and then use that in my time series chart?

    I have an Excel table called DailyBalances that uses several SUMIF functions to other tables in my workbook to calculate values for each day. As time goes on this table is getting larger and larger...
  13. How to Organize My Source Data for Pivot Tables and Stacked Area Chart

    I am looking through the article here: How to Structure Source Data for a Pivot Table & Unpivot, and it says that in order to prepare your data for pivot tables you should organize your data such...
  14. Re: How to ensure that an Excel table is properly formatted, both in values and background?

    More info:

    https://superuser.com/questions/885587/excel-table-not-formatting-new-rows-appropriately-where-does-formatting-come-f
  15. Re: How to ensure that an Excel table is properly formatted, both in values and background?

    If you create a new row in the excel table it will NOT adopt the number formatting of the last row. Instead it will adopt the formatting of whatever the last row's cells were when the table was...
  16. How to ensure that an Excel table is properly formatted, both in values and background?

    As I understand it, an Excel table can only be formatted at the time it's created. If you want to change the number format of a column, you have to convert it to a Range, and then convert it back to...
  17. Multi-column data validation with Excel tables

    I am creating an Excel workbook to keep track of my paychecks. I have a parent table called EarningsRates that has the following columns:

    Earnings Code: Code to determine the description (e.g. os1...
  18. Replies
    0
    Views
    121

    Column in table based on previous rows

    Here is what my Excel spreadsheet formatted as a table looks like:

    <table>
    <tr>
    <th>Date</th>
    <th>Month Name</th>
    <th>Trading Day</th>
    </tr>
    <tr>
    <td>12/1/2017</td>
  19. Faster to use only one cell with a volatile function and have other cells access that cell?

    Right now I have lots of cells in my table that use the NOW function, which is volatile. Would it be faster to just have one cell outside of my table that would store the value of NOW and then have...
  20. Is there an Excel function that works like the PRODUCT function but will already add 1 to each cell?

    With Excel's PRODUCT function, you supply a range of numerical values, and it returns the product of those values. When working with financial data, especially percentages, and you want to get a...
  21. Change background color of a table cell if it is twelve rows or less above an #N/A value

    I have a table formatted as a table. One column "Date" has a list of first-of-month dates, and another column "Monthly Return" has percentage values, or if the date is in the future it has #N/A. I...
  22. How to find Records in Two Tables that Have the same values in one column but different values in another column?

    I have two Excel tables formatted as tables, Table1 and Table2. They both have a field "Case Number." Some case numbers are the same in both tables, and some are different. I also have a field in...
  23. Re: How to create a group-by sum grouped by a date column?

    I want whatever will be the most minimal effect on my workbook's memory. I thought that PivotTables were a real bear on your workbook's memory and speed. Please give more details of the second...
  24. How to create a group-by sum grouped by a date column?

    My worksheet has the following structure:



    Date Amount
    4/9/2015 28.5810426
    4/9/2015 114.3087462
    4/9/2015 428.638518
    4/23/2015 28.5803476
    4/23/2015 114.3097186
  25. Re: Use Excel to solve a complex algebraic equation?

    Um, okay. Could I have more details, please?
Results 1 to 25 of 105
Page 1 of 5 1 2 3 4