preferably local favorites but i understand gatekeeping haha. can't afford to go around aimlessly though because we have limited time in tokyo. any recommendations are appreciated!
edit: wouldn't mind spending 2500 yen!
accommodation: kita-ueno or asakusa
people: fit seniors, just slower pace. perfectly fine to split the group if seniors want to rest (mostly late nights)
notes: leaning towards asakusa to do last minute shopping in nakamise/ameyoko/kappabashi before going to the airport (seems like there's more to do in asakusa than in kita-ueno). overthinking!
everything is flexible except for mayo terrace as i've already reserved it.
Day 1 (Monday) - shibuya/shinjuku
Day 2 - i'm having trouble with this day bc of the fixed kewpie museum schedule
Day 3
Day 4 (Thursday)
the first 7 photos show its current state. the rest shows the original state. my father tried to diy fix it but ended up breaking the coil completely :( please let me know if this is still fixable thank you so much
hi everyone! may gumawa na ba ng matrix ng where to invest (which banks to save in for high interest rates) and what are the best payment channels for paying bills with low billing fees? (which credit card? maya?)
i know it's best to scatter your money pero would be nice to see the pros and cons of each bank :D
"poblacion X" appears in multiple cities/municipalities. my goal is to pull exactly "poblacion V", "poblacion 4", etc from the address column onto the barangay column. i do have a reference sheet of which poblacions appear in each city/municipality.
formula i used to fill in the barangay column from the address: =LET(
CityList, FILTER('Nested'!$E$2:$E$50000, 'Nested'!$D$2:$D$50000=[@[City / Municipality]]),
Matches, FILTER(CityList, ISNUMBER(SEARCH(CityList, [@Address])) * (CityList<>"")),
LongestFirst, SORTBY(Matches, LEN(Matches), -1),
INDEX(LongestFirst, 1)
)
i need to fill in the blank "barangay" cells with the value in column1. i learned about the go to function but that selects all blank cells of the table, including column 1. i just need the blank cells in "barangay". i tried selecting the barangay column before selecting "go to" but excel just freezes
