However, when duplicating the survey form, I've realized that I cannot access the Excel Online spreadsheet until a response is received in the duplicated form. I submitted a trial response in a duplicated form and discovered that the Excel Online workbook does not duplicate a...
Files can be either copied to another folder (use "File" menu selections) or saved as a load file (use "Save File List As..." button) or as an Excel-ready CSV spreadsheet. Note that if some PDF files cannot be opened or processed (due to password protection or document access rights...
Basically without filtering and dragging the data under the candidate name \"which is time consuming\" (and as the original spreadsheet has over 3000 names on it) - Is there a formula I could enter so the spreadsheet recognises the name of the person and once one line is complete it...
I just followed this and split my left pages from my right pages in the spreadsheet and inserted them as needed. i.e: I had all my odd days etc. in one column in the spreadsheet and applied them only in the left pages, and then all my even days etc. in on...
The excel spreadsheet example you attached looks perfect, exactly what I am trying to accomplish. But I think you are saying that you attached a "demonstration of a Power Query solution." I do not see this attachment. And I am not sure what your lines describing the process mean. I ...
DingkunXie Microsoft May 24, 2024 Currently, an online Excel file is generated only once responses are received, you cannot have an Excel file for a duplicated form that has not yet received any responses.
Thanks again for your help. I am excited to see your sample excel spreadsheet example. Peace, John Hi again Riny: Thank you for the link. I am sure you have better things to do then hand-hold me but IO have another question (I ain't that bright). ...
In the attached file, the formula in D12, copied down rows and across columns, is: Thank You - This is the actual spreadsheet (sample) The cells of interest are the "Name" and then cells "I-P" - can you possibly change the look up formula to match this exact spreadsheet?
If the lookup value is now the full name instead of the first and last names, a simple VLOOKUP would do the job. The formula in C12, copied down rows and across columns, would be: Twifoo Thank You - This is the actual spreadsheet (sample) The cells of interest are the "Name"...
=INDEX($D$5:$K11, Twifoo Hi - I have one small change and need an update on the lookup formula if possible please - previously I had the individual name separate (first name-surname) - I now will be having the Full name in one cell which has impacted your formula - if you ...