issues

Hi, Has anyone else on here experienced the issue described on the thread below? :eeek: http://community.powerbi.com/t5/Desktop/Each-data-refresh-gives-different-data-results/td-p/60989/highlight/false If so, are you still having issues or have you managed to work out what the cause was...

Hi all I have a spreadsheet with dates entered against issues we have at work I wanted a count of the number of issues that are 90 days older than today's date this code: =SUMPRODUCT(--(C1:C10<TODAY())) counts number of dates but also counts blank cells so my challenge is to avoid counting...

Hello, I am trying to build treemap graphs for a presentation that will be in PowerPoint. I know that I am not using the chart function exactly as planned but am hoping someone can help. I have created the following treemap, but am having issues with double labels showing up on the graph. Here...

Hi All, Everytime I record a Macro for some reason the first action is Delete. = even though i did not press delete while recording macro. This is is causing issues when I try to re run the macro. Can someone please why this happens? Sub Macro2() ' ' Macro2 Macro ' ' Delete. = "Hello"...

Hello, My data set has rows that are states: IA, IL, MN, MT, ND, NE< SD, and WI. Each column is a percentile: P1 - P100. I have a value and a state, I want to look-up the state and return the closest value. I have been running into issues because I have not found any formula that will both...

<tbody> Occurence Time Recovery Time <tbody> 2/25/201816:24 </tbody> 2/25/201818:14 2/25/201813:54 2/25/201815:24 2/25/201810:09 2/25/201811:24 2/25/2018 7:24 2/26/201816:24 2/25/2018 11:24 2/26/201812:24 2/26/201816:24 2/26/201816:24 2/26/201816:24...

Hi, I've set up a spreadsheet to be co-authored but some users are saying there are issues when other users freeze panes in the shared doc. Is there a way around this? (Aside from saying don't freeze panes).

Hello, Im doing a formula for Eastern Time to Mountain time, the refernced times are just in different cells IE: B1 has ET 18:00 C1 has the conversion difference 2:00 D1 has the formula for MT: =B1-$C$1 and it works However, when I get from AM ET to PM MT I have issues. If B1 is 1am 01:00 the...

Hi I am looking for a website/pdf file etc that shows a well known issues/solutions. For example, how to get rid of empty cells, issues with text and how text-to-column can help, cell with space/vs empty cells etc etc. These kind of issues that daily life users would face which has nothing to do...

=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],I_RPT_EMP,LeaveTracker[Start Date],">="&DATE(I_RPT_YR,1,1),LeaveTracker[End Date],"<"&DATE(I_RPT_YR+1,1,1),LeaveTracker[Type of Leave],'Leave Types'!b4) this is the formula im using. "leave tracker" is B4-F126 which reference the...

I want to do a special sort where columns has values STOCK RECORD and ISSUES and A. I want to sort the first cell in column A with STOCK RECORD. then next the first time ISSUES appears and then the first time A appears. It would look like STOCK RECORD ISSUES A STOCK RECORD ISSUES A STOCK...

Hi All, I did an Excel update for MAC yesterday and I am having a few performance issues. I am using version 16.9 and my question is, can I roll back to the previous version? I have office 360 and I went on the website to see if there was a list of versions that I could choose from but I was...

Edit: Application or Worksheetfunction, both giving same issue Getting strange results in VBA when trying to work with EOMONTH. Debugging in Immediate I've got: ?format(WorksheetFunction.EoMonth(clng(Date),0),"dd mmm yyyy") I'm expecting it to return 28 Feb 2018 but it's coming up with the 27th...

Hi All, I have a large data set with details from A1 to H1 containing details like Date, Time Shift, Week Number etc then from K1 to CY1 showing issues found. These cells are filled in for each product checked as a single part could have multiple issues. I am now trying to pivot this...

Hey all, having a very irritating error that I can't get resolved...I am opening and calling the same Function name from 6 workbooks. 4 of them it works perfecly fine. The other 2, I get the dreaded "Error 1004 The macro cannot be ran or macros are disabled". Everything is right. The...

HI guys I am no expert on VBA and could really do with some help. I have data in a table on one worksheet and want to click on the result in a cell that is the performance of the bucket in the worksheet Overview and then for it to take me to the second worksheet, action tracker and...

Hello everyone, I want to automatize my work with excel, but sumif function is giving me small issues. I provided a screenshot to explain you my problem. Can you please tell me how can I tell excel to sum all the values from "new errors" column but only if the event type is "ICH"? You can...

Hi All, I have a general issue with Excel files with VBA that I have developped. After a variable usage time of my files, I have no more access to some menu (like change cell color), even sometimes excel windows becomes completly blank and I have no choice to close excel window and re-open it...

Hello All, I am having issues with how to select an optionbox when I change the content of a combobox. If there is a way out then let me know. Thanks. Kelly

I have recently started using Environ("Username") quite a bit. I use it to track who's using my workbook, or track issues certain users may be having, and also to make a few of my userform functions a bit more user friendly. I've been having these strange issues with my workbook that I had not...