Formula/method to link the data/responses I get from my forms into a different table.
Hi everyone! I need help with a project that I'm creating. Im making use of Microsoft Forms in order to input certain information. I made use of branching since some answers depend on the previous choice. So moving on to my problem, I want my table2 to get the responses/data from the data table created by the forms. Table 2 Table of responses For reference for the spill error, here is the formula that I used. Any insights will help a lot. Thank you have a great day everyone.Long Date Format Text Wrapping
I need my dates to be in the long date format: Monday, December 8, 2025 However, I also want that text to wrap. I do not want an really wide column for that date. I would like it to wrap at whatever point it wrap at when I adjust the column width. Simply choosing "wrap text" in the alignment section does not work. Any column width shorter than the amount of space needed for the entire date turns the date in that cell to pound signs. Heck, I'd be happy if I could even just shorten the column width and see only the beginning of the date. Though I would prefer it just adjusting like it does in every other column. I have tried work arounds like a custom date format where you force the second line to be part of the date - which it will do but the column width still must be as long as if it were in one long line or it still goes to pound signs. Is there a workaround that I can't find? Is this something that Microsoft could work on fixing in an upcoming app update? Because I have been suffering through this problem for years and would love for it to be fixed. (Also - I do not want to change the column to "text" - I want to be able to type in 12/9 and have it automatically change to Tuesday, December 9, 2025 for me. I am often changing dates or inserting dates and need it to be dynamic and not manually entered each time. (Thus the whole point of having the date format to begin with.)Excel Tools for Network & Windows
Excel Tools for Network & Windows Some time ago I already shared an earlier version of this project. Since then, I have added several new features. These tools are based on functionalities that already exist in Windows and its associated software. I have consolidated them into a single Excel-based interface, allowing all tools to be executed directly from Excel. The files are free for private use. For business or enterprise environments, a more comprehensive toolbox can be developed, enabling direct support, repair, management, monitoring, and control of users and systems. Everything can be customized according to specific requirements — the scope depends solely on the desired functionality, time investment, and budget. I appreciate any positive feedback, suggestions, or constructive tips. If this project is not of interest to you, please feel free to ignore it. Thank you, and I wish everyone happy holidays.
Viva Engage - Photos Not Loading in Conversations
Good morning. I have cleared my cache and also tried a new browser (from Chrome to Edge) and photos that were loaded in a Conversations post yesterday are not loading today - just large gray boxes were the images were. What else can I do to fix this?Name Manager using for create name which is contain atleast two name.
Hello. I creating somthing in excel with tables. These tables has thier own name, and can be dynamic or not. Any way. I using list in cell to select each data from a tables column. For that I created names with the content of a column. Unfortunatly i had to make a kind of name which is contain atleast 2 columns. These can grow dynamicly. So I think a plus helper tabel is not the right sollution for that. I think about 3 kind of solution. 1. =UNIQUE( VSTACK( INDEX(Tabla1[#Data];0;MATCH("Type_name";Tabla1[#Headers];0)); INDEX(Tabla2[#Data];0;MATCH("Column_name";Tabla2[#Headers];0)) ) output #name? 2. =UNIQUE(VSTACK(Lista_A; Lista_B)) lista_A as a name output #name? 3. created a helper table with the existing names. Created another name and use the table in it. output was the elements contained by the helper tabel, and the lista_A and lista_B tables each dedicated column. So How can i create list for a cell or cells from two column which are dynamicly growing, without a user needs to touch the core modell? Best Balázs
no me funciona la barra espaciadora (solo en word)
hola, estoy teniendo un inconeveniente con la aplicaccion de word, comienzo a escribir bien normal, escribo por ejemplo (hola, todo bien) y se escribe ¨holatodobien] por mas de que toque la barra espaciadora no funciona, si hago deble clic muy fuerte si funciona pero sino no, ya probe todo, cambie el teclado no funciona, fui a aotras aplicaciones y si funciona, es solo con word el probelma, necesito si alguien sabe como hacer quee tocar, capaz toque algo yo y no se por favor ayudaaaa
Small Business
Hello Surya Narayana, first thank you for responding to my question. I still have a problem with the formulas. The original formula still returns the wrong entry such as (JAN-00), the second formula returns an entry (#VALUE!) I've tried to change the date format in every way but, the result is the same. Thank youNeed help with conditional fomatting formula based in text on cells
Hi everyone, I have a list of owners' names in column C. C2 contains 1+1 CAR CORPORATION C3 contains 8-J ENTERPRISES, LLC C4 contains LOYD RENTALS LLC C5 contains SMITH PAUL & PAULA C6 contains DOE JHON & JANE C7 contains MENENDEZ JAMES C8 contains BROWN INVESTMENTS, INC. And so on I'd like to highlight the whole row for the cells that have CORPORATION, LLC, INC, ENTERPRISES in their names. Hope this makes sense and someone can help me. Thank you.
