This one has me a bit stumped.
Looking for a formula to help with a score card I’m doing for a tournament
Basically, if there is a valid name (word) in Column A and if there is a number in Column B, then copy that number to the next empty call in each row.
So, column A3 might have name Abe and B3 might have that Abe scored 20 points. Move the number 20 as a value only to the next empty cell in Row 3 between columns E & N.
I need it to loop through all the names and scores in column A and B, skipping blanks
Not sure if it’s important or not but columns A and B are populated using XLookup or some other index and if possible, ignore empty values.
Hope that’s clear enough, sorry it’s my 1st post so please let me know if I need to add more information.
enter image description here
Tried a bunch of formulas but nothing has come close to working
Bilbo250 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.