Does anyone know what causes a cell reference in a formula, to include the sheet name when the formula is in that same sheet? Ie. On Sheet 1, =SUM(Sheet 1’! A1:A10)
So, this is a SharePoint question, but I thought someone here may know the answer. Can anyone tell me how to write a formula in a date field validation to restrict responses to a date after a certain date? Say, I wanted to only allow dates after 07/05/2020. Google and YouTube failed me.
Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?
Best CapIQ tips and tricks for excel API? Recently discovered you can import screens from your account (using new template) directly into Excel with CIQ identifiers. Any other cool tricks?
Trying to count across multiple columns with 2 criteria, too long for sum product, trying to put into VBA... any ideas?
It almost feels silly to ask, but my company issues Thinkpad X1 Carbons with 16gb ram and they still crash when I try to save 10mb excel files. I know that there are tricks (like going to manual calc and turning off auto calc at save) but I struggle to believe that crashes on an ostensibly high-end machine for what’s really not a lot of data can be considered normal. Does anyone know how to improve performance (or what computer specs we should be looking to improve on if we upgrade hardware)?
Hi I need help please! Trying to sumifs with one of the criteria being a blank cell. Problem is the cell is not truly blank as it contains a formula that is producing the blank cell. How can I get around this to get my proper summed results???
Does anybody know how to create a series of PDFs from a data validation list wherein (be it macros, etc.) the program runs through each individual name in the list and pulls in the associated data points that are specific to field on the list, while simultaneously labeling each pdf report unique to the name on the list? Currently, I must cycle through one-by-one, click “save” each time, and then label it, which takes hours.
Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?
Help. OMG Help. I accidentally reverted to an old excel version and lost all of my changes. They are in none of the versions in the history. Is it gone forever??
Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?
Tip of the week thread: If anyone has any fun tips or tricks they feel like everyone should know, please comment below!
What are some good free resources for new consultants joining with zero to little experience? Things like navigating excel with keyboard. Vloookups, pivot tables?
How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(
I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.