Forum Discussion
Auto Populate Win Sheet via Numbers in another worksheet
I am running a pool and want to have the Win Sheet auto populate an X in a new column for every time the number comes up in the master worksheet. I was trying to use this formula =IF(COUNTIF(Mast...
If you have access to LAMBDA, you could this:
=MAKEARRAY(100,COUNTIF(numbers,MODE(numbers)),LAMBDA(r,c,IF(c<=COUNTIF(numbers,r),"x","")))
This formula creates a 100x5 matrix. The number of columns can expand depending on how many times the MODE is counted in your numbers list.
This is a fun task. You will get some good options for this one!
Thanks Patrick - I do not have access to Lambda, However I will look into this further - may have it through a work account and not know.
- A lot of companies use the Semi-Annual update channel where these functions aren't available, but you may have access to them in the Excel web app.