1,487
edits
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) | ||
::That was swell of you. Thanks! [[User:Immblueversion|Immblueversion]] ([[User talk:Immblueversion|talk]]) 13:08, 15 February 2024 (UTC) |
edits