represents

Hello, I am trying to calculate the percentage of non-contiguous cells that contain the letter "a" out of all the selected non-contiguous cell. I am new to this site and am unsure how to upload reference images. I shall try to explain this as best i can. The target cell is Q2. i want to be able...

Hi all Through column B I have a simple list of numbers which represent pounds and ounces B5 = 144.2 (so this represents 144 pounds and 2 ounces) B6 = 138.9 (so this represents 138 pounds and 9 ounces) what formula could I use so that C1 shows the difference between B5 and B6 (and shown in...

Hello All, I've been trying to find a macro to group data from a report. The problem is that the hierarchy it spits out is different so I have been having trouble finding code to work for my scenario. Below is how the data comes in and what it represents. I'm really stuck :/...

HI Guys i have he below data <tbody> Jan Feb Mar 2017 10 11 5 2017 target 5 9 13 2018 14 13 12 2018 Target 10 15 11 2019 7 3 29 2019 target 10 2 8 </tbody> I am trying to create a graph with months on the X axis and then 3 bars showing , which represents each year and inside...

I am looking for formula that can tell me if a given daterepresents the first, second, third and so on of that particular weekday. For instance, I have a column with a list of days (columnA), and I have a column beside that (column B) that identifies what day ofthe week that date represents via...

Hello, My goal is to show the correct total amount per day that will be deposited by extracting the information from contract details. here is my formula...

Hi There, I've been searching and I can quite figure this one out. I don't work with calendars/dates all that much so perhaps it's an easy answer :) I have a work book with a series of worksheets. Each worksheet represents a 4 week period. I'd like to, if possible, insert a function on...

Hi, I'm trying to show total expenses for each person, in a separate category, from a pivot table, as follows: So each bar represents the total spent, while each color represents the category it was spent on. I'm having trouble getting Excel to do this, as it just creates a new bar for each...

I have a cell with =Now() in it that is formatted like yyyy - so only the year is visible - and then, in another cell, I subtract 365 from the cell to get the number for last year - it is formatted the same - yyyy. I want the 2nd cell or another one, if necessary, to only contain the 4 digit...

Dear all, I would like to get the average of a dynamic range. Normally, the data is located row below row. However, my data set is designed in such a way that each columns represents a data point. Column A represents the name of the underlying asset. Column B represents the desired average...

Hi All,, This is my first post and i am hoping someone can help. I have a dashboard which represents a speedo from a car, there is one dial on this already and now i need to add another, however i have no clue as to how to do this, can anyone help? Regards :confused: