Editing User talk:Zawza46
From the Kingdom Hearts Wiki, the Kingdom Hearts encyclopedia
Jump to navigationJump to search
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 33: | Line 33: | ||
::<small>Putting this in small text, since I doubt anyone knows or cares about Excel stuff, but if you were curious: I made it copy every line and swap the order only if the current row is a certain number of lines after the ''nihongo'' template. The exact formula, shown here for line 50, is: <code>=IF(OR(ISNUMBER(SEARCH("nihongo",A45)),ISNUMBER(SEARCH("nihongo",A46)))),A52,IF(OR(ISNUMBER(SEARCH("nihongo",A43)),ISNUMBER(SEARCH("nihongo",A44))),A48,A50))</code>. Such is the joy of working with spreadsheets.</small> | ::<small>Putting this in small text, since I doubt anyone knows or cares about Excel stuff, but if you were curious: I made it copy every line and swap the order only if the current row is a certain number of lines after the ''nihongo'' template. The exact formula, shown here for line 50, is: <code>=IF(OR(ISNUMBER(SEARCH("nihongo",A45)),ISNUMBER(SEARCH("nihongo",A46)))),A52,IF(OR(ISNUMBER(SEARCH("nihongo",A43)),ISNUMBER(SEARCH("nihongo",A44))),A48,A50))</code>. Such is the joy of working with spreadsheets.</small> | ||
:Anyway, the sandbox should be all good to go. —<span style="font-family:'Times New Roman'; font-size:110%>[[User:Aid1043|<span style="color:#9932CC">Aid</span>]][[User talk:Aid1043|<span style="color:#9932CC">1043</span>]]</span> 07:03, 15 February 2024 (UTC) | :Anyway, the sandbox should be all good to go. —<span style="font-family:'Times New Roman'; font-size:110%>[[User:Aid1043|<span style="color:#9932CC">Aid</span>]][[User talk:Aid1043|<span style="color:#9932CC">1043</span>]]</span> 07:03, 15 February 2024 (UTC) | ||