Forum Widgets
Latest Discussions
Webservice function
Hello. I want to use the WEBSERVICE function to geolocate an IP address. The address is in cell A1, and the function is in A2. The function looks like this: =WEBSERVICE("https://ip-api.com/csv/" & A1). Unfortunately, the result is #ARG!. I have no idea what is wrong. Can you help me? Best regards, Piotr
planilha excel corrompida
boa tarde, atualmente uso uma planilha em excel no meu notebook que a mesma é compartilhada no google drive, porém ao realizar a ultima modificação e ao tentar abrir ela no dia 08/09 o arquivo nao esta abrindo, aparece a mensagem erro de arquivo ou extenção verifique, estranho que ao clicar em propriedades ela aparece como 0 bites. OBS NÃO É POSSIVEL ABRIR ARQUIVO
Linked data not updating
Hi I have a rostering spreadsheet where each person has their own spreadsheet with their rota they select a shift in their spreadhseet. I have a main spreadhseet where I link each spreadhseet to my my main rota so I can see what shifts they have selecteeneed and be able to resolve any conflicts i.e 2 peole selecting sam eshift. The issue is when data is updated in the individual spreadhseet it is not pulling through to my main spreadsheet. I used Data and get data form Excel file to link the workbooks. Not sure what I am doing wrong When Dr Adams adds a Y in Thursday it is not showing in my spreadhseetBraille Translator Challenge
Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun!Formulas Challenge for 365
Thank you for reading this post! I propose a formulas challenge (The shorter the better). Attached is a workbook in need of two formulas. I have solutions for each (Formula 1 is 66 characters, Formula 2 is 72) but would like to compare notes with others and maybe learn some new things. Formula 1: Rollup data from 5 sheets. Must be sorted A-Z, no blank rows, and must include header. Formula 2: Find the j+ max for each agent. This sounds simple but you'll have to see the workbook. The arrangement is based off a client's workbook that crossed my desk several years ago. The rules are simple. For this challenge the following are restricted: vba, PowerQuery, fill handle, use of named items, and alteration of existing data. Functions available on the Beta channel are fair game. Note: You may find this exercise difficult if you're not on 365 with Insider. The goal of this exercise is to explore some of the newest functions Excel has to offer. Have at it!
