Hi guys! New here!
I saw the awesome help you gave to people regarding Excel and figured this was my best bet.
I need to create a formula that observes a sheet for the criteria "Yes" and then displays the cell -above- the box where the "yes" was found, as well as knowing it has already counted a "yes".
Context wise, I am compiling a list of web assets we have in our product page, each of them with some rough keywords, and we have to correlate these assets with textbook chapters from various publishers. So, I have it set up so far that if you input an asset ID number, the keywords are listed, and then the textbooks check the keywords against their chapter criteria and give either a "yes" or "no" for each chapter. I now need it to search through the list for the "yes"'s and then display the box above the yes (the chapter title). Because there may be more than one chapter applicable, the display would have to be dynamic as well (showing more chapter title boxes if they apply to the asset). I have no idea how to go about doing this!
If someone could help, I would be very grateful!
I saw the awesome help you gave to people regarding Excel and figured this was my best bet.
I need to create a formula that observes a sheet for the criteria "Yes" and then displays the cell -above- the box where the "yes" was found, as well as knowing it has already counted a "yes".
Context wise, I am compiling a list of web assets we have in our product page, each of them with some rough keywords, and we have to correlate these assets with textbook chapters from various publishers. So, I have it set up so far that if you input an asset ID number, the keywords are listed, and then the textbooks check the keywords against their chapter criteria and give either a "yes" or "no" for each chapter. I now need it to search through the list for the "yes"'s and then display the box above the yes (the chapter title). Because there may be more than one chapter applicable, the display would have to be dynamic as well (showing more chapter title boxes if they apply to the asset). I have no idea how to go about doing this!
If someone could help, I would be very grateful!
