you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 1 year ago (2 children)

I get that. But it's a case that's just so incredibly common. Tagging/categorization. We end up with multiple columns like 'cat 1', 'cat 2', etc. Or doing pivot tables. I guess to me there's pretty much always something that can do the job better, but the reality is that in the corporate setting I operate in everybody uses Excel.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 3 points 1 year ago (1 child)

    You are trying to use Excel like a database and that’s not its job. Use Access for that, if you must stick within the Office ecosystem

  • source
  • parent
  • hideshow 1 child comment
  • [–] 1 point 1 year ago

    If I'm the only one doing it then I'd prefer to stick with sqlite. But the reality is that everyone I work with does these kinds of things in excel, and it's a shitshow. Yes, u could say 'don't blame the tool', but it's ms shoving it down our throats and they could've done much better with the time they had.

  • source
  • parent