boss

Hello Guys, =IF(AND(CELL("format",A2)="D4", CELL("format",B2)="D4", CELL("format",C2)="D4", CELL("format",D2)="D4"), "is in DATE Format",) above formula is to check if all values in A2 to D4 are in date. my boss challenged me to simplify above formula. please help me. :)

Ive been lurking on these boards since I started working and a former boss of mine steered me to the site. you don't know it but many of you have been incredibly helpful over the last 6+ years, so thank you. boss of mine decided to start a new monthly excel challenge and while I have one way of...

Im looking for a code in order to search all of column A for a value and select it, could anyone give me a hand? My boss will not allow me to use the CTRL-F feature.

Hello, I am trying to make naming my files easier. I have a spreadsheet where I have. FILE NUMBER PROJECT NAME My boss likes to use the naming convention of: 0001_TPR_PROJECT NAME [TPR being the company name] I am trying to use =CONCATENATE(TEXT(A1,"0000_TPR_"), B1) but because I...

Okay, so I have tried to Google this issue and can't seem to find anything or I'm not using the right key words. I have Excel 2010, my boss has 2016, and a coworker has 2013. All of my spreadsheets are Calibri, font size 10 and all spreadsheets are autofitted. When my boss or coworker opens my...

Hi all - thanks for your time and expertise. I'm considering using Excel to update the way my team provides monthly updates to the boss. I imagine having a shared workbook with a worksheet for each month of the year. Each row will refer to a task assigned to the ten staff in my work area...

Hi guys, I have been given a task and am looking for advice. My boss has 9 customers. These 9 customers are ranked on 12 criteria which my boss has ordered in order of importance. My goal is this: Each of the 12 criteria can have multiple options (this is where the data validation list comes...

I've built a pretty extensive loan pricing model for my boss. Basically you put in some parameters and it does quite a few lookups to determine an interest rate we will charge. Long story short I worked for hours on the formula to get it just right. Now I want to add in functionality to where...

My organization conducts a survey of 75 companies and currently processes the results and generates the report using SQL. The process is about 20 years old and involves several different programs. It is incredibly complex and requires coding experience just to make any changes to the survey. My...

Hey All! Was hopping you could help me really quick! My boss asked me to compare two worksheets with very similar data, and find the variences. I know vlookup is my best bet here, but I haven't used it in a while and I can't get it to work properly. Please help - she needs this by EOD! The...