This question is for Google Sheets. I'm asking two questions in one post, both are related to the same thing.
Is there a way we can use formulas like in the picture below, to achieve the results, instead of hardcoding the ranges in the charts setup?
It is also crossposted here, no answers so...
I wondering if its possible to create a formula that would split a cell by a comma and keep only the values that start with "TV -".
Keep only unique values
Take the data and insert a line feed between each grouped value before saving it to the column as shown in the...
Could a formula be created to count occurrences of values in ranges and list the occurrences at the conclusion of values in column a.
example - looking for a total count of Crits would find 2 values that fall in the Ranges value of 900-1000 [the ones showing 1000]
I am trying to figure out how to determine the number of Work, Annual and Sick hours an employee would be assigned based on their allocated budget.
Once an employee works 500 hours they are entitled to one hour of annual leave per every 15 hours worked and 1 hour of sick leave for every 20...
hi - First post in a very long time - I'm wondering if someone could help please?
I am trying to work out how we can establish our stock levels
Each row would identify either a customer order - using columns for customer name and product code or an item in stock using the term "stock" and...
I track the whole company's absence on a single excel tracker (excerpt below). At the end of each week, I am required to provide an individual absence report to managers in each location. There are currently 62 in the business across 8 locations and this is hours of work on a Friday.
Good Afternoon Everyone,
I'm starting to dial back in on creating macros and I'm wondering if there's a way to either capture all of my left column formulas and drag them over to the right while also capturing the changes between each formula.
For example (left)...
I would like to create a formula that copies all the data from rows which contain "00" in the last two digits of column L, to a new sheet (such as the cells highlighted in yellow). I know I could sort column L by "00" in the last two digits and then copy/paste, but I am trying to...
Apologies but my work won't allow XL2BB for security reasons.
The formula in column G is: =IFERROR(SUM(F9-C9)/F9, "")
This returns a percentage increase or decrease between the figures in columns F and C.
However, the exact same formula in column J: =IFERROR(SUM(I9-F9)/I9, "")...
I have two sheets, named:
1. Master Data - This sheet will be updated daily by pasting a system report over the existing data
2. 2022 - I want to calculate some stats from the master data sheet on this sheet
The gist of this is, I need to report on people who leave between 0 and 5...
i create daily stock distribution order and want to distribute a value (warehouse stock) based on 2 different values(pharmacy stock & pharmacy sales).
For example, my stock in warehouse is 20 units and in a pharmacy the stock for same item is 10 units but the sales of that item in that pharmacy...
I have a formula that works perfectly but instead of returning FALSE and would like to be blank. Can anyone please help
Kind of new to VBA, and have been studying previous posts
I have 100s of worksheets with different ranges, but all need the same formulas applied to column A and B (if blank, preferably so that i can add and update the worksheets later).
I can only get A2 to populate, any chance...
Good afternoon all.
Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in.
As you can see below - A, B and C all share the same data and i need them merged into...
Is there a way to show skins for each hole? I have provided what I have done so far, but the final step to this sheet and will save me a whole lot of time is if it could calculate the skins for me. There are two options I wouldn't mind using that I have shown as a little bit of an example...
I need to create a spreadsheet, which has an integrated 15 working day SLA. The SLA clock starts 1 day after the 'Claim Lodged Date' (Column A). The SLA clock then stops when a barrier is raised (on the day of the 'Barrier Raised Date') and then restarts when a barrier is closed (on the...
I have a power pivot table I am using to summarize some data. I am using it as a daily report and outside the pivot table I pull out and summarize specific data related to individual departments.
Two of the Lines I want to combine the total units produced. Which works fine, when both...
Hello Excel Masters.
I am trying to write a formula that will fill in the blank cells for Column B with "Contact 1", "Contact 2", or "Contact 3". Depending on how many duplicates are in Column A.