fix

Hi. In the linked spreadsheet, please could someone fix the count in column 'T'. It keeps counting one too many. Thanks in advance. https://1drv.ms/x/s!AtIvkRgReIvwgRbfii9zm52ozImr

The ToggleButton not working after I hided/unhided the rows. Anyone can help me to fix this issue? many thanks!

The Cardinals for friends worksheet have some #NA . I not how to fix time problem. picture of problem https://1drv.ms/u/s!AnJwxxiz0Ezpg8do84YcIJ5oZ_8T0A?e=tYnSMh get file link below https://1drv.ms/f/s!AnJwxxiz0Ezpg8dpKW10NS9p7fke-A Thanks You Thomas

Hello, Im looking for a way to generate random numbers when my standard deviation and mean are fix. So i used google and YouTube and there are many tutorials. (Like this: https://www.extendoffice.com/documents/excel/2472-excel-random-number-mean-standard-deviation.html ) The problem is: every...

There is a spreadsheet that is print protected[indented for third party input directly into the sheet - like a questionnaire]. It was print protected in the "Thisworkbook" so that the 3rd part would need to populate it and return it electronically. However we shot ourselves in the foot as WE...

Hi I cannot seem to get my spreadsheet to calculate over 24hours. I have tried the [h]:mm format but this is still showing values over 1000. I suspect it might be the calculations throwing it off but would be grateful if anyone can help me fix it. I have put a linlk to pictures of the...

Hopefully somebody can help me out a bit here. I have a range I need to sum =SUM(F5:F3000) But I need to allow the users to be able to delete rows within this range once they are completed, this then has the effect of changing the formula even if it absolute =SUM(F$5:F$3000) How do I fix this...

Hi I have these formulas I am using to plot my charts to keep track as the data expand and shrink . =Offset(DataSheet!$B$2,,,CountIf(DataSheet!$B$2:$B$12,"<>")) =Offset(DataSheet!$C$2,,,CountIf(DataSheet!$C$2:$C$12,"<>")) It's working great just that when the cell B2 or C2 becomes blank...

hi, i need to hyperlink my data from 1 tab to another tab in the same workbook. but i often need to insert data and my hyperlink will all run. is there anyway to fix a hyperlink to that particular data so that when i add new data on the hyperlink page, it will fix.

Hello All, This has happened to me before, and I still have no idea how to fix it. I have looked around for an easy fix, and it usually revolves around "going to tools, then references and unclick the missing reference". My problem is that I can't open the References box, it just won't open...

Excel 365 kept crashing on inserting a template. I think i have tracked it down that you can no longer have more than 2-3 folders in templates. Soon as you have more it crashes Anyone know of fix or workaround

Is there any way to have Navigation buttons (like Access record selectors) on an Excel Form? I have a Form displaying pictures.. and would like to enable Next-Previous-End. Because the picture uses the whole Form (and can be dragged smaller/larger) extra controls on the Form aren't ideal as I...

Hi, When I open an excel workbook, I get the message "Sorry, we couldn't find \\...\hstbar.xla Is it possible it was moved, renamed or deleted?" Does anyone know what the issue is or how to fix this? Thanks

Hi All, When loading data there is a column under number format but some starts from A and a space therefore power BI treats it as error, what would be the best way to fix it? I am thinking about fix the source excel data change it to text and add a apostrophe otherwise it shows scientific...

Afternoon, I have recorded the following Macro on Excel, All i am trying to do is delete all the unwanted info from the reports i download from the system at work and have it set up to how i want it at the hit of the button. I keep getting a debug message with the activesheet.Paste being...

Hi My computer is printing the spreadsheet only (cell only), leaving out the contents. It is printing the cells only but not the contents. How do I fix it? Stan

Hi I am trying to run this macro to run upon a drop down list change and am getting an error that the macro might not be in this workbook? I've noticed that all the macros I renamed now show with the workbookname then macro? please what have I done wrong and how to I fix? Private Sub...

Hi all =) I have this formula =if(a1=3,b1/c1,0)*100 Now if b1 is “0” and c1 is “0” then I get the #div error. I have tried typing “ iferror” at the start but it isnt working. Can someone help me fix this please?

Hi there, I need to create a spreadsheet for recording defects so that depending on the defect classification - Sev 1, Sev 2, Sev 3, Sev 4 - then an 'Expected Response Date/Time' and 'Expected Fix Date/Time' can be automatically calculated based on 'Assigned Date/Time'. The Response and Fix...

Hello, I have a couple of columns that seem to have UNCHAR (62) in them. The ? symbol. I am trying to remove them. I tried to find and replace but it removed the entire cell. Here is an example of what I am trying to fix: Arrow Rivet, ?.312 Hole, ?.219 Panel Thk