Combine if and countif in Google Sheets

I am trying to make a list on Google sheets that increases according to the value of the number. So it would look like this as you go down: 2,2,4,4,4,4,6,6,6,6,6,6,8...

I have tried putting 2 in column A1 and below it putting this formula: =if(A2<(COUNTIF(A$2:A2,A2)),A2,+2)But all I get when I drag it down are rows of 2s.

Is there some way of combining if and countif so I can count how many occurences of the number in A2 there are, and once there are, say, four 4s, it adds 2 (and once there are six 6s, it adds two, and so on)?

Thanks

Tardy

1

Best Answer

You just need to change A2 to A1 otherwise you would be getting a circular reference:-

=IF(COUNTIF(A$1:A1,A1)<A1,A1,A1+2)

enter image description here

Random Posts

Stable Diffusion 1.5, 2.0 webui-user.bat not found launch error in cmd [WinError 2]java skeleton code from design class diagram. Remove errorBinary Search Tree Implementation in C++ STL?Replace multiple values with jinja2How to use the s3 hook in airflowRecursively add the entire folder to a repositoryHow to print Python array within HTML email body?How to use std::invoke_result_t to get return type of a functionRegex Matching in golangArduino IDE gives "can't open device "/dev/ttyS0": Permission denied" ErrorHow do I remove a submodule?Electron app with databaseCould not automatically detect an ADB binary - Android StudioWhy virtualbox fails to install on Ubuntu20.04What Unicode characters represent "time"?Fontawesome always reloading iconsGet a list of distinct values in ListSplunk - Use streamstats with transaction command to find gaps in event logsIs there something like "if not exist create sequence ..." in Oracle SQL?How can I force the 'this' keyword on local fields and methods with the Spotless Java code formatter?