struggle

Hello all, In column Y I have quote numbers. In column A I need to put the quote number from column Y if it begins with CP or DC and blank if not. I tried this but the result is not right and returning (#VALUE!) =IF(MID(Y12,1,2="DC"),Y12,IF(MID(Y12,1,2="CP"),Y12,"")) Not sure what I am...

Hi all, This is my first time asking question online for excel(mostly just google and have the answer) but i struggle to think of a good way to ask this question on google. Basically I am making a cell at E2(shown below) to show subject 1 OR A2 <tbody> A B C D E 1 subject 1 subject 2...

Hi im hoping someone can help me with this because i am really struggling.. I am having issue with ".CommandText = Array( _ "SELECT * FROM Consolidated WHERE [Start Date]> '2019-01-01 00:00:00'")" it seems to be working fine if i do the criteria on brand or anything else.. however it...

Hello community! I have really been struggling with this formula for a while now, I'll try and describe it as succinctly as possible. I have an externally referenced workbook with many tabs (December 2015, January 2016, and so on...) on it containing Ticker Symbols for stocks in the first...

I've been working on this monster (monster to me) Excel for over a month. I'm not an IT person (Paramedic by trade) and the bosses keep shifting the ground under my feet. I've had some great help from a few people over the last week and I had what I thought was a workable solution. I've sat...

This might be difficult to type out but I'll do my best. I am trying to convert some financial documents to the current fiscal year, and in order to do so I need to change file names. No matter how many times I duplicate the files, they are still sourced to the original document, which we need...