+ Reply to Thread
Results 1 to 2 of 2

When & how to split calculated columns from "big" data table in Excel?

  1. #1
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Question When & how to split calculated columns from "big" data table in Excel?

    I'm looking for general advice for general tables in Excel, especially when they become very big and have calculated columns (I have sometimes seen 3-4 calculated columns iterating over 10,000 rows! Oh, I wish I had some idea how to split calculations from database).

    How would I split (normalise the database) the "database" and "calculations" if one of my stakeholders needs the table with values?

    I thought of the following options:
    • Is Microsoft Access (for data) the alternative (don't know if you could add calculated columns as I am still learning access).
    • Using DAX measures? How would one use DAX measure as alternative to vlookup calculated columns in Excel?

    If you have any pointers on data normalisation for these chunky Excel tables, please share.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: When & how to split calculated columns from "big" data table in Excel?

    It will help if you can give examples of the "big" data and the calculations.

    See the yellow banner at top of page on how to attach a sample workbook. Please ensure is representative of your actual situation but limit the data to a reasonable number of rows.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table Calculated Item Error - "may not be enough memory"
    By GerryLab in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-11-2021, 03:51 PM
  2. Replies: 2
    Last Post: 12-11-2015, 08:35 PM
  3. Replies: 3
    Last Post: 11-11-2015, 03:44 PM
  4. what can I use insted of KONT_ALLOMANY[KOCKAZAT_VEGE]="" Calculated Columns
    By gyorgy.udvardi in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 10-29-2014, 11:39 AM
  5. Pivot Table calculated field to count if issue "needs follow up"
    By xnukemx47 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-07-2014, 06:18 PM
  6. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  7. How to "blank" pivot table calculated fields if result = 0
    By Joe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 01:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1