Sign in to join the conversation:
Is there a way to populate formula in columns if multiple rows of data when pasting several rows to the columns next to formula column?
I would be willing to use CTRL +D, but it does not work in either of three browsers I have.
Can you provide more detail or some examples of what you are trying to do?
Thank you for your response. I actually observed interesting behavior. two columns that have formulas got populated properly when column next to them is populated with text/number, but were not populating before, when date column was next to them. I will keep watching if I can figure out other cases when it it or is not populated.
I would like a formula that counts the # of entries that are marked for the event "Non-Public Schools Leadership Conference" that contain an admission item marked "Exhibitor" whose payment method is not marked "Free". What am I doing wrong in the formula below? =COUNTIFS([Event Title]:[Event Title], "Non-Public Schools…
I recently created a new archive file and want to update the formula so that it will also search the new sheet. Here is the current formula I have. it works on current sheets but not the new archive. Any help or suggestions would be appreciated. =UPPER(IFERROR(IF(LEFT([Excel PO Approval Number REQUIRED]@row , 2) = "PO",…
Hi i'm looking to a formula using INDEX and MATCH to refer data from two sheets. i have 2 source sheets sheet: "project" and "Archive projet". in each, there are same columns for projet number and contact name. i would like to refer the contact name in a third sheet with a formula that can find the contact name based on…
