formulas

  1. A

    Power Pivot Table - Outside calculations

    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...
  2. T

    Filling in blanks in Column B with Duplicates in Column A

    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...
  3. A

    Comparing two lists of date ranges based on name

    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...
  4. M

    I would like to make a macro that loops down a pivot table slicer list and create separate sheets based on data from each slicer selection.

    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...
  5. Chris_010101

    SUMIF/SUMIFS Help

    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...
  6. S

    Adding a prefix based on the value of another cell

    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...
  7. J

    Help with formula to check changes between numbers

    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...
  8. T

    Power Query: Import Values only From Table

    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...
  9. MrDB4Excel

    Two Posts in One: Custom Formatted Text & Extraction of Formulas

    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...
  10. deadlyjack

    Looping through A3-A13 with monthly numbers (Formulas only)

    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...
  11. S

    Excell Formula is miscalculating based on other cells.

    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...
  12. C

    Google sheets: Identify presence of difference texts across DIFFERENT cells, per group

    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...
  13. D

    Overriding Conditional Formatting Color with Manual Entries of a different color

    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...
  14. D

    Convert VBA Code to Formulas in Excel

    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...
  15. P

    Auto Delete Cells Based off a Checkbox in Google Sheets

    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...
  16. N

    Formula for adding up minutes

    Hello, I have got a log of minutes and each set of minutes has a category. I want to add up the minutes for each category at the top of the sheet as you can see. I thought a SUM would work and have tried '=SUMIFS(F2:F100,H2:H100,"Work")' - this seems to know they are minutes but also brings up...
  17. R

    Copy all sheets to new workbook without formulas and macros

    Hi All, I want to copy my whole workbook (xlsm) with formulas and macros to a whole new excel file (xlsx) without any formula and macro. I've found the script below on internet and works fine but is for 1 certain sheet. How can i include multiple sheets and copy this to the new workbook? It is...
  18. W

    VBA hard code formula problems

    Hi! I have a big workbook that evolves around a cell (O3) In this case O3=11, but this number/cell changes several times during a working day. When running the macro, I need the vba to hardcode a formula to A2 with a number from cell O3 The working formula is: =IF(sheet1!B11=0,0,sheet1!B11)...
  19. A

    Help with multiple index matches with multiple if statements

    Hi, I'm trying to write a index match formula with 2 if statements. So far my formula is =IF(I3>H3,INDEX(zb!C:C,MATCH(1,(I3=zb!D:D)*(G3=zb!H:H)*(H3=zb!D:D),0)),(IF(H3>I3,INDEX(zb!C:C,MATCH(1,(H3=zb!D:D)*(G3=zb!H:H)*(H3=zb!D:D),0))))) I want to return the data if I3 > H3 then match the data...
  20. Jyggalag

    Have formula data appear as text, maybe VBA solution?

    Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top