formulas

Hi I have a formula that works perfectly but instead of returning FALSE and would like to be blank. Can anyone please help =IF(F7=0,MAX(INDEX((Append1[Compliance_Officer]=Sheet1!C7)*Append1[Date_Assessed],))) Many thanks

Hi All, 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...

Hi all, 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...

Hello, 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. EX: 174653 Contact 1 174653 Contact 2 175277 Contact 1 175277 Contact 2 178484 Contact 1...

I am trying to organise an on call roster where an individual is selected for a seven day period. This is in a table with name - start date - end date of when they are 'on call'. In a second sheet, I want a second table where people input the dates they are unavailable to be on call due to...

So I have a sheet that has a pivot table in the "Pivot Table Reference" tab, that has a slicer called reviewee name. Based on what is selected on that slicer that pivot table is referenced in a sheet on the "Output Sheet" tab. What I need is some kind of a VBA cycle code that can automatically...

Hello I am trying to track my energy usage and have a spreadsheet with two sheets ABCDEFG1No.Period FromPeriod toElectricGasVATTotal2101-Mar-2229-Mar-22 ABCDEFGHIJ1No.Period fromPeriod toFuel / StandingTypePrevious ReadingLatest ReadingUnits UsedKWH Rate or Standing Charge Daily Rate...

Hello All, I need a bit of assistance with adding a prefix to an existing value in a cell based on the value that is in another cell. Here is the scenario. I have a field called Job Type. This field has a dropdown list in it that is coming off of a named range in a second sheet in the same...

Hi, hope you all are doing well. I need help building a formula, if someone can be so kind to help me I would be very grateful. Per the image, I have a data series on column "A", on column "B" I need a formula that checks how many "x" it takes, until there is a inverse 2x change of "x". So...

Hi all, Is there any way to import values only from a table, rather than formulas? My current code is: = Excel.CurrentWorkbook(){[Name="Table1"]}[Content] How would I rewrite this to bring in all calculated formulas as hard-coded values? The issue is this: I have two tables I'm importing...

Earlier this year I was able to create a custom number format such that whenever I typed, for example, three pairs of numbers altogether: 112233 or 095543 or whatever, any combination then the outcome would always be, using the above two examples: 11:22:33 or 09:55:43 which was to signify...

Hey all Excel warriors, I'm currently designing a totally new workbook at work which involves every single item within our warehouse, combined with a forecast of the monthly marketing. I got an idea at work today and started working on a concept that I found logical and might actually work 🤔 Now...

Hi, looking for a bit of advice. i have a built spreadsheet where i am calculating the cost of a product based on other factors. To give an example: A1) 2.21 >>>>entered manually A2)=A1 >>>> (so shows 2.21) A3)=ROUND(SUM(35/B11),2) >>>> to explain, this is taking a figure of 35, then...

I have the below data and want to see how I can achieve the last column, in google sheets. I was given an excel solution in a different thread but unfortuunatelt the AGGREGATE function is non existent in google sheets. The excel solution given is: =IF(A2=A1,C1,SUBSTITUTE(B2&" TO...

Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...

Basic need is I need my macro turned into formulas or something that can be on the spreadsheet without macros. Work is getting rid of the ability to use macros (disabling all), so I need my codes to work without being codes. I have tried different formulas (find, if, vlookup, etc) and I can't...

Hello! I am trying to find a way to delete certain cells based off a check box in another. For example if H3 (which has a checkbox) is marked as true, then I would like B3,C3,E3,F3,G3, and I3 to have their contents cleared. Is this possible with a formula or script? I have attached a photo...