help !

Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help! I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...

Hi all, I have this specific task at work which I failed to do with VBA. So let me explain and even put a link to my file. I have the below arrays: Alpha: Includes a lot of Index Code|Exchange Code (Separated by "|") Beta: Includes a lot of Date| Exchange code (Seprated by "|") What is...

Hi everyone. i have a sharepoint list that contains observations my training team have made for numerous colleagues in the department. The can be observed on various different tasks and they could have been observed more than once. I ask my team to rate the colleague from 1 to 4 on that task...

Hello, Please help me find a formula for this problem I couldn't think straight. I need to get the header title/the levels using the names. I hope you guys could help me thanks. Please see image below.

Hello Everyone! I am looking to create a formula to do the following.. If C14="THIS" then look in table on page 2 (columns B-F) for data in Cell E23(from page 1) and return pricing listed in column 3, but if Cell C14="THAT" then look in table on page 2 (columns B-F) for data in Cell E23 and...

Hello! I am quite new to VBA, but I am trying to create a program that allows me to push a button that asks for a file name, and after entering the file name, it opens up the file I requested. I have attempted this here, ______________________________________ Sub Start() Filename =...

Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...

Hello, I'm having some difficulty with the SUBTOTAL function. I'm looking to find the sum of a range within a filtered spreadsheet. I entered =SUBTOTAL(9,[RANGE]) and it returned an answer of 7.10543E-14 (which doesn't make sense since my values on have two decimals). I calculated it manually...

I receive a large file each month which tracks staff who badge through a particular badge reader. I am trying to write a formula to tell me if each row was captured during regular business hours or not. below you see a paste of my excerpt (I cannot attach a sample excel file to this for some...

Hello, I have a data set of ~2500 rows, the data im concerned with is the description. The description has large variations within the data set, i am looking to consolidate the descriptions to a common description. For example ...

Hi, I'm currently working on a project where I have a number of statements which are rated between 1(Strongly Disagree) and 4 (Strongly Agree). For each organisation I am presenting their mean average on this statement against the combined mean average for all other organisations, and I would...

Hi all, So i have a long column of date data (01/10/2018 etc) in Column A:A and what I'm trying to do is have Column B:B return back the following criteria: Last Week (Which is the date in A:A is in the last 7 days) Last Week -1 (Date in A:A is from the week prior to last) Last Week -2 etc...

Hi all, I often have an issue where I will save and exit a workbook and then when I come back to it, all cells have been formatted to Accounting, despite being saved as General, Percentage, Date, etc. It's odd because it's different workbooks, not just the same one over and over again...

Greetings all... I'm in a pickle jar... Let's say I am looking at 4 different store locations. In those locations I have several lines of products that we sell. I have 5 pivot charts setup all associated to the same data sheet. I am using a slicer to auto filter all the pivots depending on...

Hello All, I have been searching for threads and while I can find some code for situations similar to mine, I can't seem to re-work the code to fit my specific situation. I just don't have a deep enough understanding of VB to understand how to modify the code. I have fleshed out what I am trying...

Hello All- I have searched the WWW and I can't seem to find exactly what I am looking for, so I am hoping someone here can help. I know enough about Excel to be dangerous so if you know how to help me please give me step by step details. So here is my problem: On my first sheet I have a lot of...

I have a range of dates in column A and I only need to identify the dates within the last 2 years. Is there a way to use conditional formatting to only highlight the dates that are within the last 2 years? Thanks in advance!

Hi All, I have a workbook which contains 100s of worksheets. In column A of each worksheet contains unique product ids. Then to the right of those product ids are numbers (column b). Sometimes we need to change what numbers are to the right of each product id. A2 = BLX6497 B2 = 20 At the...

9X60X11 I have variations of dimensions such as the string above in my cells. Their position is not consistent. The only consistent rule is that the word I want to be rid off in all my cells contains the letter x, but how?

Hi there! I am in need of some VBA macro magic here. I have a stream of data that represents energy usage on an hourly basis. It is in one column currently that goes Day 1 HE 1, Day 1 HE 2, etc. I would like to have a macro that takes the 24 hours and transposes it into a table that has the...