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...
=IFERROR(IF(ISNUMBER(SMALL(IF($A3=Master!$E$3:$E$110,ROW(Master!$E$3:$E$110)-2),COLUMN(Master!A$1))),"X",""),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. The formula is entered in cell I3 and draged across range I3:M102. In columns B to F are the manually entered expected results.
- Thank you - I am struggling to adjust this to my spreadsheet, but I will keep working on it - This gives me something to work on!
