Forum

How about rounding to 1 decimal place then?

Hi Bruno, It's great to hear you're enjoying our site and content! Thanks so much Thanks for explaining the data in more detail. It helps under...

Hi Paul, The problem you're discovering happens when Excel converts values to binary and back again. Sometimes referred to as a floating point. ...

Hi Bruno, Please watch lesson 6.07 of the Power Pivot course which explains how to relate multiple fact tables and which fields must be used in the...

Thanks for clarifying. You can use this formula: =SUM(INDEX(F2:F32,MATCH("Yom Kipur",G2:G32,0)-1):INDEX(F2:F32,MATCH("Yom Kipur",G2:G32,0)+1)) Obv...

Hi Lea, It's a bit hard to follow your example as I'm not sure where you got 8.5 from because that's 3 days before Yom Kipur i.e. on the 13th Septe...

Hi Kevin, There's nothing unique about rows 13 to 16 for it to make sense to copy those values from row 16 up. Why would you have duplicate rows li...

Hi Kenneth, Perhaps I'm not understanding what you mean. Where are these 60k rows downloading to? A table in the Excel file, the Power Pivot data m...

Hi William, Welcome to our forum. You can use the technique explained in this tutorial on looking up pictures in Excel. Seeing that you don't need ...

Hi Ben, Welcome to our forum. You can use the FILTER function for this like so: =COUNT(FILTER(I2:I70,(LEFT(I2:I70,2)="13")*(K2:K70="N/A"))) M...

I wonder if there's some VBA in the file that triggers something in the Slicer upon opening?

Hi Kenneth, You can turn off data load in background. File tab > Options & Settings > Options > Current Workbook Data Load: deselect '...

Hi Jessica, The User Report does not have a relationship with the Absolute Values table. If you delete the relationship between the GL by User Repo...

I don't think you're going to get an answer for this, John. It's the switching of the values from 73 to 37 that is not something Excel is designed to ...

Hi Shannon, Welcome to our forum! You can use VLOOKUP with an approximate match for this. Or use Power Query to do the equivalent of a VLOOKUP appr...