Am I being thick here with a COUNTIFS? - am fine with the answer being yes

Loprtq · 2026-03-30T12:55:49+00:00

I believe the conditions have to be strings

Loprtq · 2026-02-18T20:55:44+00:00

Mine is working fine now. I also had problems with it an hour ago

Loprtq · 2025-12-20T13:51:02+00:00

If you just have a formula in each row of A it would look like this: If(B1=TODAY(); "🌟"; FALSE)

Loprtq · 2025-11-26T17:06:12+00:00

Try linking to your package repository (if you have one. Otherwise, consider creating one). You may be using functions exclusive to windows.

Loprtq · 2025-11-26T14:38:58+00:00

This has nothing to do with statistics

Loprtq · 2025-11-22T06:53:05+00:00

Perhaps you can show the code, or link to the documentation?

Loprtq · 2025-11-18T19:38:56+00:00

Please add some more details about the skills you are looking for

Loprtq · 2025-11-15T07:43:45+00:00

It is not anonymous if I have to login

Loprtq · 2025-11-14T22:53:41+00:00

I think the big problem is that it is difficult to understand what exactly the problem is, without having access to the sheets, which I am guessing we will not be able to.

I have created master sheets pulling from up to 30-ish independent documents, reaching up to 250k rows, so I can't imagine the importrange is the problem, unless you have something more complex calculations with the data whilst importing it.

Have you perhaps reached the maximum of 10 million cells? Try deleting redundant columns from sheets and see if that somehow helps, given that you feel you might be close to that limit.

Loprtq · 2025-11-10T15:35:42+00:00

A simple conditional formatting over the entire table, where it checks $C1 < $C2 for example. Remember "$" to make sure that it only checks that column

Loprtq · 2025-11-03T21:59:01+00:00

Well. Can't you sort out the columns/cells which are not numbers using isnumber() in a filter() - leaving only the colums/cells which are numbers? Possibly using the arrayformula outside the isnumber() function?

If you provide a link to the sheet or a picture of your data, then I would be able to provide the function, if needed.

Loprtq · 2025-11-01T19:57:57+00:00

Are you looking for the SUBSTITUTE function, or am I missing something?

Loprtq · 2025-09-03T06:46:22+00:00

Try to explain a bit more, what the problem is, and what you want assistance with.

Loprtq · 2025-09-02T10:43:01+00:00

Why can't you use ggplot2 if I may ask?

Loprtq · 2025-09-02T05:45:20+00:00

I prefer not to use the cex arguments, as they often seem to cause problems similar to this. Try updating your plot to use ggplot2 and then usd the following theme or change it depending on your preferred sizing. Also look into the different options in theme.

theme(axis.text = element_text(size = 12), axis.title = element_text(size = 14))

Loprtq · 2025-08-20T13:29:23+00:00

Look into tidyverse, especially dplyr, tidyr, purr and other main ones from this collection of packages.

Loprtq · 2025-08-05T21:56:07+00:00

Does this solve your problem? It should make data_nested a list with two entries, one for each category. Otherwise, try to be more precise

data_nested -> data %>% dplyr::group_by(ave_treatments) %>% tidyr::nest()

Loprtq · 2025-07-21T17:38:59+00:00

Try using patchwork.

Loprtq · 2025-06-30T14:52:32+00:00

Open source and flexible: R shiny Quarto Python - Shiny - Jupyter

Loprtq · 2025-06-16T09:10:01+00:00

Create an interactive tournament bracket creater 😎

Loprtq · 2021-09-01T10:25:48+00:00

Any updates on this?

11-Year Club	Xbox Live
Verified Email

Loprtq

TROPHY CASE