{
  "subreddit": "r/excel",
  "page": "https://redlisten.com/r/excel",
  "updated": "2026-11-12T00:55:58.395Z",
  "members": 902883,
  "activity": {
    "posts_last_24_hours": 19,
    "posts_per_hour": 0.3,
    "comments_per_hour": 5.7,
    "newest_post_utc": 1794430619.265,
    "newest_comment_utc": 1794427316.672
  },
  "top_threads_this_week": [
    {
      "title": "Excel suddenly deleting hidden rows when deleting filtered data. Anyone else experiencing this?",
      "score": 168,
      "comments": 52,
      "created_utc": 1793974843.022,
      "snippet": "I've been using Excel for years and never had this issue before, but for the past week or two, something seems to have changed and I can't figure out what's going on. Previously, whether I was...",
      "url": "https://www.reddit.com/r/excel/comments/1xpdzaj/excel_suddenly_deleting_hidden_rows_when_deleting/"
    },
    {
      "title": "Pulling information from one spreadsheet to another",
      "score": 44,
      "comments": 20,
      "created_utc": 1793865568.656,
      "snippet": "Hello, I’ve got an issue which is maybe simpler than most queries on here, however my own research into a solution has brought me into a dead end somewhat. The issue: There is a master spreadsheet...",
      "url": "https://www.reddit.com/r/excel/comments/1xod1c8/pulling_information_from_one_spreadsheet_to/"
    },
    {
      "title": "Anyone else notice Excel lagging even with small spreadsheets?",
      "score": 42,
      "comments": 18,
      "created_utc": 1794150891.475,
      "snippet": "Even on my brand new work laptop, working with relatively small spreadsheets, I find Excel surprisingly sluggish. The worst example is the slight delay after pressing Alt to bring up shortcuts. My...",
      "url": "https://www.reddit.com/r/excel/comments/1xr0p6g/anyone_else_notice_excel_lagging_even_with_small/"
    },
    {
      "title": "I don’t know if Excel or Power BI is better for my team",
      "score": 41,
      "comments": 39,
      "created_utc": 1793914652.651,
      "snippet": "I am the only one very knowledgeable in Excel and Power BI in my team. My colleagues know Excel basic knowledge and nothing concerning Power BI. I have to create monthly metrics and I have to do a...",
      "url": "https://www.reddit.com/r/excel/comments/1xov2yv/i_dont_know_if_excel_or_power_bi_is_better_for_my/"
    },
    {
      "title": "Awesome-Excel - What is awesome which is missing?",
      "score": 26,
      "comments": 9,
      "created_utc": 1794274629.852,
      "snippet": "Hi All, Some of you may know of me as the curator of awesome-vba. Over the past few months I've been accumulating links to awesome public Excel workbooks and projects; such that I decided to...",
      "url": "https://www.reddit.com/r/excel/comments/1xsa6n5/awesomeexcel_what_is_awesome_which_is_missing/"
    },
    {
      "title": "Power Query-Large 1-Year Inventory Transaction File",
      "score": 20,
      "comments": 11,
      "created_utc": 1794023672.301,
      "snippet": "Looking for some guidance, I think I am overthinking a relatively simple task. I manage an inventory for a supply chain and am looking to do a report that shows our slower moving items. We use...",
      "url": "https://www.reddit.com/r/excel/comments/1xpwt5b/power_querylarge_1year_inventory_transaction_file/"
    },
    {
      "title": "Power Query Now Failing to Load in Excel Web Browser",
      "score": 16,
      "comments": 11,
      "created_utc": 1794162876.894,
      "snippet": "Has anyone else been having issues with Power Query in Excel for the web since around November 5? I've got several workbooks that were refreshing just fine before, but now they're all failing....",
      "url": "https://www.reddit.com/r/excel/comments/1xr5gw9/power_query_now_failing_to_load_in_excel_web/"
    },
    {
      "title": "Getting excel to show and hide data based on drop down selection",
      "score": 15,
      "comments": 11,
      "created_utc": 1793843182.346,
      "snippet": "Good evening. My job has work instructions that are scattered across tabs. I was wondering if there is a way to get certain information to appear and disappear based on a drop down selection. I...",
      "url": "https://www.reddit.com/r/excel/comments/1xo6bs3/getting_excel_to_show_and_hide_data_based_on_drop/"
    },
    {
      "title": "How can I have Excel find the last numeric value of a column in each of ten worksheets and and provide a total in the 11th worksheet?",
      "score": 14,
      "comments": 25,
      "created_utc": 1794073583.288,
      "snippet": "I have ten worksheets. In each worksheet, column \"E\" is labeled \"30-Day Cost\". I want Excel to find the last value in column \"E\" in each worksheet and give me a grand total of all \"30-Day Costs\"...",
      "url": "https://www.reddit.com/r/excel/comments/1xqca2h/how_can_i_have_excel_find_the_last_numeric_value/"
    },
    {
      "title": "Macro to Get Data",
      "score": 13,
      "comments": 10,
      "created_utc": 1794220351.325,
      "snippet": "Hi All, macro newb here I'm trying the below steps in my macro: 1. Get Data From File 2. Choose a file in a select folder 3. PowerQuery choosecol etc. 1&3 are easy steps that record macro can do....",
      "url": "https://www.reddit.com/r/excel/comments/1xroccj/macro_to_get_data/"
    }
  ],
  "newest_posts": [
    {
      "title": "How to add a month column?",
      "score": 1,
      "comments": 1,
      "created_utc": 1794430619.265,
      "url": "https://www.reddit.com/r/excel/comments/1xttfdw/how_to_add_a_month_column/"
    },
    {
      "title": "Is my table formatted incorrectly?",
      "score": 1,
      "comments": 3,
      "created_utc": 1794430468.92,
      "url": "https://www.reddit.com/r/excel/comments/1xttd9u/is_my_table_formatted_incorrectly/"
    },
    {
      "title": "Sharing a live range with someone at a different company: what actually works?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794427758.208,
      "url": "https://www.reddit.com/r/excel/comments/1xts81b/sharing_a_live_range_with_someone_at_a_different/"
    },
    {
      "title": "Solutions for using the AverageIF function for a range of criteria",
      "score": 1,
      "comments": 1,
      "created_utc": 1794425329.954,
      "url": "https://www.reddit.com/r/excel/comments/1xtr5g6/solutions_for_using_the_averageif_function_for_a/"
    },
    {
      "title": "Should I learn VBA ?",
      "score": 1,
      "comments": 0,
      "created_utc": 1794419836.097,
      "url": "https://www.reddit.com/r/excel/comments/1xtoon2/should_i_learn_vba/"
    },
    {
      "title": "Flat vs marginal commission tiers: one formula each (they can pay the same rep $3,000 apart)",
      "score": 1,
      "comments": 1,
      "created_utc": 1794417899.11,
      "url": "https://www.reddit.com/r/excel/comments/1xtnswt/flat_vs_marginal_commission_tiers_one_formula/"
    },
    {
      "title": "Difference Pivot Table (normal table input) vs Pivot Table (Data model) - AFAS Software (extra information for dutch people)",
      "score": 1,
      "comments": 1,
      "created_utc": 1794413032.407,
      "url": "https://www.reddit.com/r/excel/comments/1xtlkta/difference_pivot_table_normal_table_input_vs/"
    },
    {
      "title": "Highlighting times in a schedule",
      "score": 1,
      "comments": 1,
      "created_utc": 1794410994.424,
      "url": "https://www.reddit.com/r/excel/comments/1xtkon9/highlighting_times_in_a_schedule/"
    },
    {
      "title": "Can no longer use upload images and files button",
      "score": 1,
      "comments": 1,
      "created_utc": 1794407075.233,
      "url": "https://www.reddit.com/r/excel/comments/1xtj1t5/can_no_longer_use_upload_images_and_files_button/"
    },
    {
      "title": "I need to unify rows with duplicate data while keeping all different values",
      "score": 1,
      "comments": 1,
      "created_utc": 1794406124.172,
      "url": "https://www.reddit.com/r/excel/comments/1xtio0k/i_need_to_unify_rows_with_duplicate_data_while/"
    }
  ],
  "words_this_week": [
    {
      "word": "data",
      "titles": 23
    },
    {
      "word": "power",
      "titles": 11
    },
    {
      "word": "another",
      "titles": 10
    },
    {
      "word": "change",
      "titles": 10
    },
    {
      "word": "query",
      "titles": 9
    },
    {
      "word": "cells",
      "titles": 9
    },
    {
      "word": "based",
      "titles": 8
    },
    {
      "word": "value",
      "titles": 8
    },
    {
      "word": "formula",
      "titles": 8
    },
    {
      "word": "rows",
      "titles": 7
    },
    {
      "word": "find",
      "titles": 7
    },
    {
      "word": "cell",
      "titles": 7
    }
  ],
  "preview": "This is a preview. Every post and comment in r/excel, live, as JSON or RSS on the same paths a Reddit client uses, plus keyword streams to Slack, Discord, webhook or email, needs a free key: https://app.redlisten.com/?signup=1&utm_source=redlisten&utm_medium=subreddit",
  "docs": "https://redlisten.com/docs",
  "attribution": "Source: Redlisten, https://redlisten.com/r/excel"
}